A high-level overview of SQL Server security aspects and best practices, starting with the often overlooked physical security of the server itself.
SQL SERVER – Beginning Reading Transaction Log File
What is the SQL Server transaction log, why do we need it and how does it work? A beginner’s first step toward reading transaction log file content.
SQL SERVER – A Practical Use of Backup Encryption
A backup in the wrong hands is a data leak waiting to happen. Here is a practical example of Backup Encryption in SQL Server 2014 to keep your backups safe.
SQL SERVER – Synchronize Data Exclusively with T-SQL
Many tools sync data between databases. Here I build the functionality to synchronize data exclusively with T-SQL, step by step, from structure to triggers.
SQL SERVER – Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server
The VALUES clause does much more since SQL Server 2008. Here is a Query Plan Analysis of PIVOT and UNPIVOT queries using the profiler in dbForge Studio.