SQL Server 2008 System Views Poster now available for download

I'm really proud of the work my colleagues did on the SQL Server 2008 System Views poster in conjunction with our partners. Ron Talmage led our team. But the best news is that it's now available for download for free:

http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en

 

SQL Server Certification Statistics

Ken Tanner recently reminded me of the link showing current certification status:

http://www.microsoft.com/learning/mcp/certified.mspx

 

The SQL Server related entries from this list are:

 

MCDBA SQL 2000 152086
MCTS SQL 2005 41665
SQL 2005 BI 2600
SQL 2008 Dev 336
SQL 2008 BI 134
MCITP SQL 2005 DBA 6695
SQL 2005 Dev 2925
SQL 2005 BI 1088
SQL 2008 DBA 92
SQL 2008 BI 50
MCM SQL 2005 18
SQL 2008 2

The 18 SQL 2005 Certified Masters folk have been brought across from the earlier SQL Ranger program. The list doesn't include the SQL 2008 DBA TS certification for some reason. I'd be interested in hearing your thoughts on why there was such a big drop in numbers from the 2000 versions to the 2005 versions. I suspect that part of it has to do with the 2000 exams being much easier and that they were a relatively easy option for those pursuing a variety of certifications, including the developer certifications.

New Sydney CBD Lunch-time SQL Server User Group

Victor Isakov has decided to spin up a new SQL Server user group that will be meeting on the 1st Wednesday of each month, at Westpac Place in the city. He describes the group as focussing on best practices, optimisation, design and implementation and is aiming directly at the local corporate market.

Access to Westpac Place will be quickest if you have pre-registered so Victor is asking you to let him know you're coming by sending him an email to victor@sqlserversolutions.com.au.

The first three meetings for 2009 are as follows:
 
Topic: DBA: Best Practices for All DBAs to Follow
Date: 4th February
Description: As the popularity of SQL Server continues to grow, so is the demand for new SQL Server DBAs. Unfortunately, you can't “go to school” to learn how to become a DBA. Most DBAs learn from books, seminars, short classes, and trial and error. This session is designed to encourage a cross-pollination of ideas and best practices between DBAs from different organizations. It includes best practices from the trenches which can only be obtained through experience.
 
Topic: DBD: A Comprehensive Guide to Indexing in SQL Server
Date: 4th March
Description: With the release of SQL Server 2008 the database developer has more choices in their arsenal for optimally indexing database solutions. In this session we will explore the different indexing technologies that are available in SQL Server 2005 and SQL Server 2008, such as included, composite and filtered indexes. We will discuss the primary design considerations and tradeoffs made when implementing an indexing strategy and present more "exotic" scenarios such as how to implement custom hash indexes, how to combine filtered indexes with sparse columns, partitioned indexes and how to implement partitioned views with different underlying table indexes.
 
Topic: ARCH: Reducing Your Storage Cost in SQL Server 2008
Date: 1st April
Description: Are increasing storage costs hurting your bottom line as data sizes keep growing throughout your organization? In this session, we explore how SQL Server can help you lower your storage costs. We start with Microsoft SQL Server 2005 partitioning to transparently migrate older data to lower-cost storage tiers over time. We then discuss new storage cost-saving functionality in Microsoft SQL Server 2008 such as data compression, backup compression, and sparse columns, filtered indexes, file stream which can get you to 50% or more reduction in storage requirements for typical applications. Throughout the session, we share experiences, insights, and best practices from SQL Server customers and Microsoft-internal deployments. Learn how to make good use of these technologies in combination.

DevWeek – London – March

I'm also locked in to present a one day "SQL 2k8 for Developers" preconference session and three conference sessions for DevWeek in London in March, along with a number of my colleagues from Solid Quality: Itzik Ben-Gan and Javier Loria. I'm really looking forward to it and would love to catch up with any SQL locals while there. Details are at the DevWeek site: http://www.devweek.com.

TechEd US – Full Text Indexing – SQL Server 2008

Got the email today to say I had a session accepted for TechEd US. I'll be doing the "Answering the queries your users really want to ask" session on full text indexing in SQL Server 2008. It's an update of the session that I did at TechEd EMEA in Barcelona recently.

I'm really pleased to get to present again this year, given the vastly reduced number of data track sessions.