Archive for December 2019

How to get SQL Extended Security Updates for SQL 2008/2008 R2 database instance. The End of Support date for SQL Server 2008 and 2008 R2 is July 9, 2019 Extended…

Introduction The TempDB database is essential to SQL Server’s management of temporary data and execution of different tasks. The TempDB files are often kept on the same disc as the…

As a DBA you may face a few common questions whenever someone accidentally deleted some database objects or the whole database. “How long-time SQL Server will take to complete the…