Microsoft has recently released a powerful new DMV specifically to help with memory issues, sys.dm_os_out_of_memory_events. It is currently available in Azure SQL Database and Azure SQL Man­aged ...

A Microsoft data platform MVP on the state of SQL Server today -- how it's evolved in Microsoft's Azure-first word, the best features to emerge in recent years and troubleshooting gotchas.

Nothing in the event or sql logs.<BR><BR>The System log said "previous shutdown at 7:01pm was unexpected." The first of 3 database backups is done at 7pm so it froze up right after starting.

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. Mature disciplines-from medicine to aviation to ...

One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or the database is slow. In the ...

This week we will discuss how to troubleshoot different assembly errors that we get while troubleshooting installs for SQL Server. I’ll focus this article more on SQL Server and Windows systems.