SQL Server Database Backup Encryption
To manage the data security that has been backed up by the file system as a database backup files,...
How to Pass Parameters in Dynamic T-SQL Query
Developers are often faced with the need to build a dynamic query, however, there are a number of pitfalls, which we will discuss further...
Database Checkpoints in SQL Server
In this article, we will talk about SQL Server Checkpoints. To enhance performance, SQL Server applies modifications to database pages in...
SQL Server: DELETE vs TRUNCATE
T-SQL provides two keywords that allow you to delete data from a table. They are DELETE...
SQL Server Unit Testing with tSQLt Framework
In this article, we will talk about the tSQLt framework — a free database unit testing framework for Microsoft SQL Server. You...
SQL Server Transaction Log — Part 2
This is the second article in the series dedicated to SQL Server transaction log and its specificities. Here we are going to examine the...
ROLLBACK TRUNCATE in SQL Server
Have you ever accidentally executed the TRUNCATE command on a wrong table? This will lead to all...
SQL Server Transaction Log — Part 1
Every SQL Server database contains one or more transaction log files in addition to data files. Log files record all transactions and...
Retrieving SQL Server Metadata with Help of T-SQL
This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and...
