Its only about a week until SQL Saturday #52 in Denver. This is an all day, free event, being held at Cherry Creek Presbyterian Church 10150 E. Belleview Avenue Englewood, CO 80111. There are a number of great speakers, and lots of free loot to be given away.
I will be giving two presentations which are summarized below:
SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to both 2008 and 2008 R2), presents and explains over thirty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.
SQL Azure is Microsoft’s solution for hosting basic SQL Server relational databases in the cloud. Microsoft continues to add new features in each Azure Service Update that makes SQL Azure a more viable solution. For smaller databases that don’t require features such as Reporting Services, Analysis Services, or Full Text Search, it can be an easy to use technology that can save lots of money in hardware, license and maintenance costs. This session shows you how to configure, connect to, and manage a SQL Azure database, both from SQL Server Management Studio and from a .NET application, and it gives best practices and tips on how to get the most benefit from SQL Azure.
Don’t forget, there is a food drive to help the victims of the recent wildfire in Boulder, so bring in some canned food to donate. I hope to see and meet a lot of new people there!