Detect Microsoft .Net Framework versions
I use the following code to determine which specific version of the Microsoft .Net Framework 4.0 is installed on my SQL Server. It detects versions from 4.5 to 4.7, and can be easily extended as…
SQL Server 2000 Books Online Documentation
This simply serves as a repository for the SQL Server 2000 Books Online Documentation, in case Microsoft decides to no longer provide it on their website. To be clear, I’m not suggesting anyone actually use…
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…
Could not find database ‘x’, or why good object names are important.
SQL Server provides a method for specifying object names that contain special characters – you simply wrap the name in square brackets, as in [This-Is-A-Valid_$_ObjectName]. However, simply because you can do a thing, doesn’t mean…
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…
Backup Performance Testing
Reliable database backups are perhaps the single most important aspect of a Database Administrator’s job. The business risk from data-loss that can occur without a reliable database backup are substantial enough to bring many smaller…