Tag: ssms

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

5 Sep 2025 · 5 min read

How to Check SQL Server Version

Six reliable methods to find your exact SQL Server version and build number, from a quick T-SQL query to SSMS server properties and the Windows control panel.

Read article →

15 May 2018 · 6 min read

How to Fix Performance Dashboards for SQL 2008

Learn how to apply Microsoft's compatibility update to get the SQL Server 2005 Performance Dashboard working correctly against SQL Server 2008 and 2008 R2 instances.

Read article →

15 May 2018 · 6 min read

How to Speed up SQL Management Studio

SSMS loading slowly in restricted networks? Disabling the Windows certificate validation check can cut startup time from 30 seconds to under 5 seconds.

Read article →

21 Oct 2017 · 6 min read

Gettin’ Techie SET STATISTICS TIME

SET STATISTICS TIME reveals exactly how long SQL Server spends parsing, compiling and executing your queries. Learn to read the output and diagnose slow query performance with confidence.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.