Gaps in Database ID sequence – one reason why this can happen

I spoke with a DBA today about the following scenario… When running DBCC CHECKDB in SQL Server 2005, he noticed that there were no entries for the hidden database snapshot in sys.databases; however he did see that a database_id  value was shown when querying sys.dm_exec_requests (for the request running the DBCC command – WHERE command…

0

Updated SQL 2008 MCM Pre-reading list

David Ikeda and I have updated the SQL Server 2008 MCM Pre-reading list based on the last training rotation we conducted last October.  You can download the PDF here.  As a seasoned SQL Server professional, ideally you’ll already have read some, if not most of the material listed in this document.  If not, you’ll find…

0

SQL MCMs – Now Sixty Members Strong

** Cross posted from the Master blog.  I usually don’t cross post the new SQL MCM member announcements – but since we’re at sixty members, I thought this was a special occasion. ** Yesterday we added another SQL 2008 MCM to the community, making the total number of SQL MCMs sixty members strong.  What’s even…

0

Testimonial from a SQL MCM (who doesn’t work for Microsoft)

I was recently asked by a potential SQL MCM candidate if we could share testimonials about the SQL Microsoft Certified Master program from non-Microsoft employees  Out of the 57 MCMs in the world, only 12 are not Microsoft employees  (by the way – the numbers on our Meet the Microsoft Certified Masters and Microsoft Certified…

0

Lucky "Rotation 7" almost done

The seventh SQL Microsoft Certified Masters rotation is almost finished.  It has been a jam packed 48 hours: A full day on the topic of SQL Security from Greg Low Last night we had a Meet and Greet in Building 35 – where our candidates had a chance to meet several PMs and Devs from the SQL Engine…

0

Authors on the loose at the SQL MCM Program

We’re midway through the second week of “Rotation 7” for the SQL Server Microsoft Certified Master program. We tried something new for this rotation, providing a copy of Microsoft SQL Server 2008 Internals for each participant. So far we’ve been able to get four signatures on everyone’s copy (Paul Randal, Kimberly Tripp and Adam Machanic…

0

Rotation 7 of the SQL MCM Program has begun!

We kicked off the seventh rotation of the SQL Server Microsoft Certified Master program on Monday and I have to say how impressed I am with this latest batch of 12 candidates.  The cumulative experience in the room is significant, and the intelligence and skill level is very high.  Even though we have a room…

0

Last week to register for the October 2009 SQL Microsoft Certified Master program

Just a heads up that if you’ve been on the fence about registering for the SQL Server Microsoft Certified Master program – you have just three more days to do so (last registration day for the October rotation is September 18th).  Remember that you’ll get a $3,550 discount if you attend this year’s training rotation….

0

SQL MCM Program Fee Discounts

I just posted some information on two SQL MCM Program Fee discounts available for the next SQL MCM “rotation” (coming up in October):  SQL MCM Program Fee Discounts If you have any questions about this – feel free to contact me directly.  Thanks,  Joe

0

Using MSDN SQL Server 2008 R2 Books Online instead of using the local download

I downloaded the client-based version of SQL Server 2008 R2 Books Online, however the installer wanted to upgrade my existing version of Books Online. Rather than do that, I’ll just be using the MSDN version of SQL Server 2008 R2 Books Online which you can find here.  First thing I always look for in a new BOL…

0