Monthly Archives: March 2010

SQL Server 2008 SP1 CU7 is Released

Microsoft has released SQL Server 2008 SP1 Cumulative Update 7 (CU7). It is Build 2766. There are 31 fixes listed, many of which are for SSRS, SSIS, and SSAS. They have also released SQL Server 2008 RTM Cumulative Update 10 … Continue reading

Posted in SQL Server 2008 | 11 Comments

How to Enroll a Managed Instance into SQL Server Utility in SQL Server 2008 R2

After creating a Utility Control Point (UCP) you will want to enroll some managed instances (up to 25 with SQL Server 2008 R2 Enterprise Edition) into your Utility Control Point. Remember, any managed instances must also be SQL Server 2008 … Continue reading

Posted in SQL Server 2008 R2 | Leave a comment

Denver SQL Server User’s Group Meeting on March 18

The Denver SQL Server User’s Group will be having their March meeting on Thursday, March 18. Bulent Gucuk will discuss SQL Server Replication basics. The second speaker will be Dean Richards of Confio Software, giving a presentation on using Wait … Continue reading

Posted in SQL Server 2008 | Leave a comment

SQL Server Utility in SQL Server 2008 R2

One of the new management related features in SQL Server 2008 R2 is SQL Server Utility. SQL Server Utility gives you a way to manage and monitor multiple instances of SQL Server using a variation of Management Data Warehouse. You … Continue reading

Posted in SQL Server 2008 R2 | Leave a comment

SharePoint 2010 and Various Versions of SQL Server

Microsoft has recently announced that SharePoint 2010 and Office 2010 will RTM in April 2010, and will be officially launched on May 12, 2010. From historical experience, this means that the RTM bits will be available on MSDN Subscribers probably … Continue reading

Posted in SQL Server 2008 | 5 Comments

How to Easily Log SQL Server 2008 Instance Level Metrics

If you want to record the results of some useful, instance level DMV queries somewhere where you can easily query them later, you can use this technique.  This gives you a pretty decent overview of the health of your instance … Continue reading

Posted in SQL Server 2008 | 4 Comments

Easy Ways to Detect I/O Pressure in SQL Server 2008

It is pretty common for large, busy SQL Server instances to run into I/O bottlenecks. Even smaller, less busy systems often run into problems when they are not sized and configured correctly. As a database professional, you need to be … Continue reading

Posted in SQL Server 2008 | 9 Comments

T-SQL Tuesday #004 Hosted by Mike Walsh

I just wanted to remind people to participate in T-SQL Tuesday #004 on the subject of IO. You just need to post a blog post on something to do with IO between 00:00:00 UTC on Tuesday the 9th of March … Continue reading

Posted in SQL Server 2008 | Leave a comment

More SQL Azure Samples

I have been playing around some more with SQL Azure in order to get ready for an upcoming presentation, so I thought I would share some of the T-SQL commands in the script below. I have a partial copy of … Continue reading

Posted in SQL Azure | 3 Comments

Using the OUTPUT clause to retrieve new identity values from SQL Server 2008

Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity column in a table. This particular issue shows up when you have parallel execution plans, but I have also seen … Continue reading

Posted in SQL Server 2008 | 4 Comments