T-SQL Datetime Data Type
Introduction Data types are attributes that specify the kind of data that objects such as columns,...
SQL Data Discovery and Classification
With the recent data protection laws and the implementation of GDPR last year, it is imperative for us to know the type of data our...
How to Export Data to Flat File with BCP Utility and Import data with Bulk Insert
The BCP (Bulk Copy Program) utility in SQL Server allows database administrators to import data into a table and export data from a table...
Bulk Insert Data Files Into SQL Server
According to Wikipedia, the bulk insert is a process or method provided by a database management...
Dealing with NULLs in SQL Server
What is NULL? NULL or the NULL marker is the way we represent an unknown value in SQL, by SQL I am referring to the standard Structured...
Overview of Data Compression in SQL Server
The database is a critical and vital part of any business or organization. The growing trends predict that 82% of enterprises expect...
How to Generate Test Data in SQL Server
When testing the functionality of your application or the performance of a specific stored...
Passing Data table as Parameter to Stored Procedures
Real-world database applications need to make multiple requests from the front end to the database in order to carry out all sorts of...
Backup and Restore FILESTREAM-Enabled Database
In my previous articles, I explained how to create and configure the FILESTREAM feature in SQL server instance. Moreover, I demonstrated...
Storing Files in SQL Database Using FILESTREAM – Part 2
In my previous article, I described how to configure FILESTREAM in SQL Server, create...
