Share via


Joe Sack's SQL Server Blog

Today is my last day with Microsoft. After five and a half years, I recently decided to join...

Date: 09/30/2011

I’ve been waiting for a long running transaction to commit, so to speak, before announcing the...

Date: 06/27/2011

The cache store “CACHESTORE_SQLCP” represents cached ad-hoc query plans, server-side...

Date: 03/28/2011

Now I’m definitely not a networking guy, so even the more basic networking concepts fill me...

Date: 03/27/2011

Consider the following scenario: You have a database that has PARAMETERIZATION FORCED enabled. You...

Date: 03/27/2011

The last two Mondays have brought us two new highly qualified Microsoft Certified Masters. If you’ve...

Date: 02/21/2011

News travels pretty fast, so I thought I would get the official word out tonight before this news...

Date: 02/10/2011

Our last planned batch of SQL Server 2008 MCM Readiness Videos are now published – covering...

Date: 01/03/2011

We just added another 23 videos on Technet – making it a total of 56 videos available as of today....

Date: 12/15/2010

“Know what you know. Know what you don’t know. Don’t ever confuse the two.”...

Date: 11/21/2010

I just found out today that one of our own SQL MCMs (2005/2008) & MCA, Christian Bolton, is a...

Date: 11/21/2010

It’s a big day for the Microsoft Certified Master (MCM) program, as we announce the new MCM...

Date: 11/09/2010

Apologies for my radio silence lately. With SQL PASS next month, I'll be getting a little more...

Date: 10/29/2010

“Before enlightenment; chop wood, carry water. After enlightenment; chop wood, carry...

Date: 06/17/2010

(Reposting from cache - as the MSDN blog migration seemed to have lost my latest post) Do you share...

Date: 06/01/2010

The ninth rotation of the SQL Microsoft Certified Masters program begins Monday. I'm really looking...

Date: 04/30/2010

So I just got finished with a Friday afternoon head scratcher (that luckily had a resolution)....

Date: 04/23/2010

I’ve used DDL Triggers before to prevent database DROP DATABASE operations.  For example:...

Date: 04/08/2010

(Cross posted on The Masters Blog) The eighth rotation of the SQL Microsoft Certified Masters...

Date: 04/02/2010

I was asked a few questions about the behavior of using “ALTER INDEX ALL… REBUILD” and thought I...

Date: 03/09/2010

Brent Ozar, who is a Microsoft SQL Server expert for Quest Software, Microsoft MVP, Editor-in-Chief...

Date: 02/10/2010

When an unexplained outage occurs on a standalone server and you need to determine root cause, DBAs...

Date: 02/09/2010

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

I spoke with a DBA today about the following scenario… When running DBCC CHECKDB in SQL Server 2005,...

Date: 12/28/2009

David Ikeda and I have updated the SQL Server 2008 MCM Pre-reading list based on the last training...

Date: 12/07/2009

** Cross posted from the Master blog.  I usually don’t cross post the new SQL MCM member...

Date: 11/26/2009

I was recently asked by a potential SQL MCM candidate if we could share testimonials about the SQL...

Date: 10/30/2009

The seventh SQL Microsoft Certified Masters rotation is almost finished. It has been a jam packed 48...

Date: 10/22/2009

We’re midway through the second week of “Rotation 7” for the SQL Server Microsoft Certified Master...

Date: 10/14/2009

We kicked off the seventh rotation of the SQL Server Microsoft Certified Master program on Monday...

Date: 10/07/2009

Just a heads up that if you've been on the fence about registering for the SQL Server Microsoft...

Date: 09/16/2009

I just posted some information on two SQL MCM Program Fee discounts available for the next SQL MCM...

Date: 08/19/2009

I downloaded the client-based version of SQL Server 2008 R2 Books Online, however the installer...

Date: 08/13/2009

Just a reminder that SQL-DMO will be removed in a future version of Microsoft SQL Server - so if you...

Date: 08/12/2009

Good Morning, Just a heads up that I just posted an introduction to nine out of twelve of the new...

Date: 07/11/2009

Short post with two updates today: After many months of development, the much anticipated SQL Server...

Date: 07/09/2009

Today I found a new (for me), undocumented method for identifying the location of the SQL Error log....

Date: 06/15/2009

I just posted a new entry on the SQL Server Premier Field Engineer Blog on Three Usage Scenarios for...

Date: 06/11/2009

The new SQL Server Premier Field Engineer Blog is now launched! It will start off small, but...

Date: 06/07/2009

Sanjay Mishra just published the following White Paper, "Data Compression: Strategy, Capacity...

Date: 05/29/2009

I recently worked on a case where a significant number of deadlocks were being generated for...

Date: 05/22/2009

Heard a similar question today, related to my post on "Override READ_COMMITTED_SNAPSHOT with...

Date: 05/19/2009

The scenario… An application is using the READ_COMMITTED_SNAPSHOT (RCSI) database option to minimize...

Date: 05/18/2009

Here is a link to the presentation deck for yesterday's Minnesota PASS presentation: "Performance...

Date: 04/22/2009

If you live in Minnesota or are visiting next Tuesday, April 21st, please stop by the Bloomington...

Date: 04/15/2009

Do you suspect you are encountering CPU pressure? Some of the more common signs of CPU pressure...

Date: 04/08/2009

Today I witnessed a performance load test against a 16 proc 64-bit SQL Server instance. During the...

Date: 03/17/2009

Today I received a copy of SQL Server 2008 Query Performance Tuning Distilled by Grant Fritchey (aka...

Date: 03/13/2009

I recently heard from a reader of SQL Server 2008 Transact-SQL Recipes who was looking for the...

Date: 03/09/2009

Next>