Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Until we meet again...
Today is my last day with Microsoft. After five and a half years, I recently decided to join...
Date: 09/30/2011
Announcing the new SQL MCM Program Manager
I’ve been waiting for a long running transaction to commit, so to speak, before announcing the...
Date: 06/27/2011
Measuring impact of “optimize for ad hoc workloads” via CACHESTORE_SQLCP
The cache store “CACHESTORE_SQLCP” represents cached ad-hoc query plans, server-side...
Date: 03/28/2011
ARP Caching and SQL Server Failover Cluster install failures
Now I’m definitely not a networking guy, so even the more basic networking concepts fill me...
Date: 03/27/2011
Forced Parameterization with Filtered Indexes
Consider the following scenario: You have a database that has PARAMETERIZATION FORCED enabled. You...
Date: 03/27/2011
Two good Mondays in a row for the SQL MCM program
The last two Mondays have brought us two new highly qualified Microsoft Certified Masters. If you’ve...
Date: 02/21/2011
One less “uncertified Master”
News travels pretty fast, so I thought I would get the official word out tonight before this news...
Date: 02/10/2011
Last batch of SQL MCM videos now published
Our last planned batch of SQL Server 2008 MCM Readiness Videos are now published – covering...
Date: 01/03/2011
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....
Date: 12/15/2010
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.”...
Date: 11/21/2010
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...
Date: 11/21/2010
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...
Date: 11/09/2010
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...
Date: 10/29/2010
Off Topic: How I chop wood and carry water
“Before enlightenment; chop wood, carry water. After enlightenment; chop wood, carry...
Date: 06/17/2010
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...
Date: 06/01/2010
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...
Date: 04/30/2010
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)....
Date: 04/23/2010
Gotcha: When Server-Scoped DDL Triggers don’t honor ROLLBACK
I’ve used DDL Triggers before to prevent database DROP DATABASE operations. For example:...
Date: 04/08/2010
Free press doesn’t always mean lollypops and rainbows
(Cross posted on The Masters Blog) The eighth rotation of the SQL Microsoft Certified Masters...
Date: 04/02/2010
ALTER INDEX ALL REBUILD behavior
I was asked a few questions about the behavior of using “ALTER INDEX ALL… REBUILD” and thought I...
Date: 03/09/2010
SQL MCM Prep Week posts by Brent Ozar
Brent Ozar, who is a Microsoft SQL Server expert for Quest Software, Microsoft MVP, Editor-in-Chief...
Date: 02/10/2010
DBA 101: Collecting and Interpreting Failover Cluster Logs
When an unexplained outage occurs on a standalone server and you need to determine root cause, DBAs...
Date: 02/09/2010
Why run the SQL MCM marathon?
I’ve been a casual jogger for about 14 years, and lately I’ve been debating whether or not I should...
Date: 01/21/2010
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,...
Date: 12/28/2009
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...
Date: 12/07/2009
SQL MCMs – Now Sixty Members Strong
** Cross posted from the Master blog. I usually don’t cross post the new SQL MCM member...
Date: 11/26/2009
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...
Date: 10/30/2009
Lucky "Rotation 7" almost done
The seventh SQL Microsoft Certified Masters rotation is almost finished. It has been a jam packed 48...
Date: 10/22/2009
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...
Date: 10/14/2009
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...
Date: 10/07/2009
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...
Date: 09/16/2009
SQL MCM Program Fee Discounts
I just posted some information on two SQL MCM Program Fee discounts available for the next SQL MCM...
Date: 08/19/2009
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...
Date: 08/13/2009
SQL-DMO and SQL Server 2008
Just a reminder that SQL-DMO will be removed in a future version of Microsoft SQL Server - so if you...
Date: 08/12/2009
Meet the new batch of SQL Server Microsoft Certified Masters
Good Morning, Just a heads up that I just posted an introduction to nine out of twelve of the new...
Date: 07/11/2009
SQL Server 2008 Failover Clustering White Paper & SQL MCM
Short post with two updates today: After many months of development, the much anticipated SQL Server...
Date: 07/09/2009
Where is my SQL Error log?
Today I found a new (for me), undocumented method for identifying the location of the SQL Error log....
Date: 06/15/2009
Three Usage Scenarios for sys.dm_db_index_operational_stats
I just posted a new entry on the SQL Server Premier Field Engineer Blog on Three Usage Scenarios for...
Date: 06/11/2009
Introducing the SQL Server Premier Field Engineer Blog
The new SQL Server Premier Field Engineer Blog is now launched! It will start off small, but...
Date: 06/07/2009
New White Paper and Compression impact on Memory
Sanjay Mishra just published the following White Paper, "Data Compression: Strategy, Capacity...
Date: 05/29/2009
Troubleshooting Table Locks
I recently worked on a case where a significant number of deadlocks were being generated for...
Date: 05/22/2009
Impact of NOLOCK on READ COMMITTED SNAPSHOT ISOLATION
Heard a similar question today, related to my post on "Override READ_COMMITTED_SNAPSHOT with...
Date: 05/19/2009
Override READ_COMMITTED_SNAPSHOT with READ_COMMITTED?
The scenario… An application is using the READ_COMMITTED_SNAPSHOT (RCSI) database option to minimize...
Date: 05/18/2009
Presentation Deck for "Performance Tuning with Wait Statistics"
Here is a link to the presentation deck for yesterday's Minnesota PASS presentation: "Performance...
Date: 04/22/2009
Speaking at PASS MN Tuesday April 21 - Performance Troubleshooting with Wait Statistics
If you live in Minnesota or are visiting next Tuesday, April 21st, please stop by the Bloomington...
Date: 04/15/2009
Checking for CPU pressure via sys.dm_os_schedulers
Do you suspect you are encountering CPU pressure? Some of the more common signs of CPU pressure...
Date: 04/08/2009
Should you worry about SOS_SCHEDULER_YIELD?
Today I witnessed a performance load test against a 16 proc 64-bit SQL Server instance. During the...
Date: 03/17/2009
SQL Server 2008 Query Performance Tuning Distilled
Today I received a copy of SQL Server 2008 Query Performance Tuning Distilled by Grant Fritchey (aka...
Date: 03/13/2009
SQL Server 2008 Transact-SQL Recipes - Source Code
I recently heard from a reader of SQL Server 2008 Transact-SQL Recipes who was looking for the...
Date: 03/09/2009