Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption.
SQL SERVER – How to Delete a Single Table From SQL Server Backup File (.bak)
Question: How to Delete a Single Table From SQL Server Backup File (.bak)?
SQL SERVER – How to Enable Backup Compression On by Default
In this blog post we will discuss how to Enable Backup Compression on by default.
SQL SERVER – What Are Ghost Records and How to Clean Them Up?
What are Ghost Records and How to Clean Them Up?
I loved this question when I received it last week in my SQL Server Performance Tuning Practical Workshop.
SQL SERVER – Simple Explanation of AT TIME ZONE Feature
Recently I received a simple question about AT TIME ZONE feature. This is the new feature which is introduced in SQL Server 2016 and later version of the SQL Server. As this is a relatively new feature the adoption of this feature is also a bit slow. However, let us understand how this function really works in a few simple words.
SQL SERVER – New DMV in SQL Server 2017 – sys.dm_os_enumerate_fixed_drives. A Replacement of xp_fixeddrives
Looking at the way SQL has evolved, there are changes coming up in SQL Server 2017 which would help it run on Windows and Linux platforms. Let us learn about dm_os_enumerate_fixed_drives.
SQL SERVER – 7 Important Things to Remember While Taking Effective Backup
In this blog post we will discuss 10 things to remember while taking effective backup for SQL Server.