Wait Stats capture script

Performance troubleshooting should begin with capturing wait stats so we can understand where SQL Server is busy. The script below captures wait stats into a table in tempdb; the script should be ran via a…

New Look, New Web Address!

As you’ve probably already noticed, SQL Server Science has a new logo, however you may not have noticed we’ve also changed our web address to SQLServerScience.com. The old domain name, SQLServer.science, will continue to work…

Internet access to your SQL Server?

Occasionally I see questions on dba.stackexchange.com where it appears the SQL Server is exposed directly to the Internet, allowing remote connections. This is very bad. In this post, I provide some reasons why. First, it…

Vulnerability Assessment recommends disabling Remote Admin Connections

SSMS 17 has the handy ability to run quick Vulnerability Assessments against your database. One of the Vulnerability Assessment checks looks to see if the Dedicated Administrator Connection, otherwise known as the “DAC”, is enabled…