Second batch of SQL MCM Readiness Videos now Released

We just added another 23 videos on Technet – making it a total of 56 videos available as of today. The new videos cover storage core concepts & guidelines, DAS vs SAN architecture, storage testing and monitoring, index internals, the clustered index debate, statistics, locking, restore internals, Waits and Queues, a clustering introduction, SQLOS concepts,…

10

How do you know if you’re ready for SQL MCM?

“Know what you know. Know what you don’t know. Don’t ever confuse the two.” Per Farny, founder of the original Microsoft Certified Master and Architect program How do you know if you are ready to take the Microsoft Certified Master SQL Server 2008 exams? This is a common question and a perfectly valid one, especially…

2

Microsoft SQL Server 2008 Administration for Oracle DBAs

I just found out today that one of our own SQL MCMs (2005/2008) & MCA, Christian Bolton, is a co-author for the recently published book Microsoft SQL Server 2008 Administration for Oracle DBAs. I just wanted to congratulate Christian on yet another published work! As an extra bonus – I was also informed that this…

0

A New Path to Microsoft Certified Master: SQL Server 2008

It’s a big day for the Microsoft Certified Master (MCM) program, as we announce the new MCM SQL Server 2008 certification path.  Our customers want to be able to earn a SQL Server Microsoft Certified Master certification at a lower price, with more flexibility, and we’ve responded by evolving the SQL Server MCM program without…

2

High Availability and Disaster Recovery for Microsoft’s SAP Data Tier: A SQL Server 2008 Technical Case Study

Apologies for my radio silence lately.  With SQL PASS next month, I’ll be getting a little more verbose again. In the meantime while I remain relatively quiet, I worked on a White Paper with Eric Holling (Microsoft IT) and with Sanjay Mishra (SQL CAT team) and contributors Juergen Thomas and Elke Bregler (along with a host…

0

Off Topic: How I chop wood and carry water

 “Before enlightenment; chop wood, carry water. After enlightenment; chop wood, carry water.”  Zen proverb  I see my daily work as nothing more than a high tech form of chopping wood and carrying water.  Work can sometimes seem to be overwhelming or unmanageable, but in the end I think that everything can be broken down into…

6

Sharing your T-SQL Code? Test it on a case sensitive SQL instance

(Reposting from cache – as the MSDN blog migration seemed to have lost my latest post) Do you share your T-SQL code with others?  If you do, then first of all, thanks for sharing.  But next question – did you test it on a case sensitive SQL instance?  Check out the following two queries: SELECT DepartmentIDFROM…

0

Eve of SQL Rotation 9 and planning for future rotations

The ninth rotation of the SQL Microsoft Certified Masters program begins Monday.  I’m really looking forward to meeting this next batch of candidates and future MCMs.  A few days ago I drew up a summary of each attendee’s experience and background and then emailed it to our instructors.  I wanted the instructors to know about the significant accomplishments…

0

Friday afternoon case of the mystery scan versus seek

So I just got finished with a Friday afternoon head scratcher (that luckily had a resolution). Problem: Ad hoc query with a predicate that references a literal value does an index seek.  0 second execution. Ad hoc query that defines a local variable with same set value does an index scan.  2 second execution. Looking at the…

1

Gotcha: When Server-Scoped DDL Triggers don’t honor ROLLBACK

I’ve used DDL Triggers before to prevent database DROP DATABASE operations.  For example:             CREATE TRIGGER ddl_ss_prevent_database_drop ON ALL SERVER FOR DROP_DATABASE AS PRINT ‘Will not drop database until you disable this trigger.’ ROLLBACK GO If you try to drop a database with this DDL trigger in place, you’ll get the following message: Will not…

2