Monthly Archives: July 2009

The Effect of Data Access Code On SQL Server Performance

Bob Beaucheamin, who works at SQLSkills, has an excellent new article in MSDN Magazine that explains how different methods of writing data access code in ADO.NET can have a huge effect on performance and security. Here is the executive summary … Continue reading

Posted in SQL Server 2008 | 33 Comments

Nice Mention On SQL Server Central

I just discovered that Andy Warren of SQL Server Central has chosen me as “Featured Blogger”, with some very kind words about my blog. Thanks, Andy, I really appreciate it!

Posted in SQL Server 2008 | 6 Comments

How To Get SQL Server CPU Utilization From a Query

I like to use DMV and other T-SQL queries to quickly and easily get information about how my database servers are running. I have written, used, and shared many useful queries for finding out quite a bit about what was … Continue reading

Posted in SQL Server 2008 | 7 Comments

How Much Space Does My Database Use?

Since I have been spending some time cleaning up some databases in preparation for some server consolidation work, I thought I would share some useful queries for determining things like how large your database is, how full the files are, … Continue reading

Posted in SQL Server 2008 | 32 Comments

SQL Server 2008 SP1 Cumulative Update 3

Microsoft  has released SQL Server 2008 SP1 CU3 and SQL Server 2008 RTM CU6, both of which have lots of fixes. SP1 CU3 is Build 2723 and RTM CU6 is Build 1812. Microsoft continues to do a good job of … Continue reading

Posted in SQL Server 2008 | 15 Comments

When Can You Get The Windows 7 RTM Bits?

One of the recent outstanding questions among Microsoft enthusiasts has been when exactly we could get our hands on the official, final RTM bits for Windows 7. Well, now we know, straight from this post from Microsoft’s Brandon Leblanc on … Continue reading

Posted in Microsoft | 10 Comments

Some Useful Full Text Index Stoplist Related Queries

Stoplists are used in SQL Server Full Text Indexes to exclude common “noise” words (such as to, the, etc.) from filling up the index with information that is not very useful for Full Text Searches. By default, a new Full … Continue reading

Posted in SQL Server 2008 | 20 Comments

Finding Dead Objects in SQL Server 2008

I have been doing some house cleaning on my databases, looking for stored procedures that are no longer used by any of our applications. I’m not using any fancy third party tools, just what I think is a little common … Continue reading

Posted in SQL Server 2008 | 17 Comments

Denver and Boulder SQL Server User’s Group Meetings

The Boulder SQL Server User’s Group (BSSUG) is meeting tonight starting at 5:30PM in Broomfield. I will be giving my “Using SQL Server 2008 Database Mirroring to Become a Super Hero!” presentation and demo at 7:00PM, after Peter Myer’s presentation … Continue reading

Posted in SQL Server 2008 | 5 Comments

SQL Server 2008 Failover Clustering Whitepaper

The busy people at SQLCAT have released another whitepaper, this time on SQL Server 2008 Failover Clustering. This is quite a long document at 175 pages, but it is packed with useful information. Failover clustering is a tested and reliable … Continue reading

Posted in SQL Server 2008 | 1 Comment