You may call him Master
Congratulations to my friend and colleague Greg LeClair for officially becoming a SQL Server Master! It became official today. For anyone unfamiliar with the Master’s program, check out the link … more
Business Intelligence and SQL Server
Contents tagged with SQL Server
Quick note on Fragmentation
Empirical evidence is incredibly useful for understanding your position on architecture, in deciding what the best maintenance plan for your SQL Server should be or justifying the purchase third … more
SQL 2008 Performance Problems Resource
I wish the search on the downloads site at Microsoft worked better. You can even input the name or title of this one and still no luck..... You can download "Troubleshooting Performance … more
Response to SQL Mag: Ready? Set? Kilimanjaro! Editorial
This will be a first, and I just had to do it. For some reason Michael Otey's January 2009 editorial just didn't sit well with me – it may have to do with the fact that we were at the … more
Cumulative update post for SQL 2008
Microsoft has posted the first cumulative update for SQL 2008 under article 956717. Once installed, your patched instance will go to version 10.0.1763 from 10.0.1442. more
SQL Server Dev Connections
I'm blowing my budget this year in going to the Microsoft BI conference in Seattle, but for anyone else out there who, a) will miss the Microsoft BI Conference, or b) is lucky enough to afford two … more
Cool SQL 2008 Features: Server Audits
Earlier this year, I posted a short feature on auditing in SQL 2005 using DDL triggers to capture events and log them. In SQL 2008, one of the less sexy features added, though highly important and … more
SQL 2008 DMV Additions
SQL 2008 has now been fully released for just over a month, and for those who have not been keeping track of additions throughout the CTPs and Release Candidates, here is a bit of useful information: … more
SQL 2005 System Views Poster
More wall decorations! Actually, keep this as a PDF on your computer for reference instead of printing and save paper.I came across this SQL 2005 system views poster in my travels across cyberspace. … more
Cached Plans and Performance
After putting up a primer post about statistics last week, my mind has now jumped to another facet of performance: cached plans. Cached plan objects, whether they are for procedures, ad-hoc … more
