How to use SQL Cursors for Special Purposes
This article describes SQL cursors and how to use them for some special purposes. It highlights the...
Running SQL Database Maintenance Tasks Using SQLCMD
This article is about developing an advanced understanding of the Sqlcmd utility which lets you run T-SQL commands directly from the...
Implementing Automated Database Backup and Restore with Default Means
Introduction You can find a lot of guides on how to backup and restore databases. In this one, we’ll show how this can be done using the...
In-depth Exploration of Row Level Security
Introduction Organizations are becoming more and more concerned about how to reduce the cost of...
Automatic Deletion of Forgotten Transactions in MS SQL Server
Introduction It is often the case when an MS SQL Server transaction is being forgotten by the initiator. The best example would be the...
SQL Server Bulk Insert – Part 1
According to Wikipedia, ”A Bulk insert is a process or method provided by a database management system to load multiple rows of data...
Bulk Insert Data Files Into SQL Server
According to Wikipedia, the bulk insert is a process or method provided by a database management...
Introduction to Row-Level Security in SQL Server
Why Row Level Security Matters? Prior to SQL Server 2016, table-level security was the default lowest level of security for a database. In...
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...
Essentials and usage of NOLOCK hint in SQL Server
The main idea of the SQL Server locking mechanism is that it controls the consistency of...
