Some of my clients and I have been waiting on this for a little while – SQL Server 2008 Service Pack 2 has been released.  It includes resolutions for 21  issues and the inclusion of fixes for 61 issues previously resolved.

Along with the resolution of those issues, Service… Read more

Earlier this week, PASS opened up the Schedule Builder for the those that are registered for the PASS Summit.  You can also take a look at the full schedule with the At A Glance schedule.

This is your opportunity to find out what sessions are going to be when… Read more

Are you ready for Seattle?  Have you registered for the PASS Summit?  Hopefully with some good reasons you will be inspired to attend the summit this year.

Ten Reasons to Attend

There are, of course, countless reasons to attend the PASS Summit in November.  To hopefully inspire a few… Read more

In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following:

• Index Black Ops Part 1 – Locking and Blocking
• Index Black Ops Part 2 – Page IO Latch, Page Latch
• Index…

Read more

Yes, it is.  As I mentioned a few months back, it is important to pay attention to when Microsoft releases Cumulative Updates for SQL Server.

This past week, on Tuesday, Microsoft release an update to SQL Server 2008:

• Cumulative update package 10 for SQL Server 2008 Service Pack 1

Read more

Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following:

• Index Black Ops Part 1 – Locking and Blocking
• Index Black Ops Part 2 – Page IO…

Read more

As I’ve mentioned a couple times already our PASSMN meeting tonight will be in a new location.  This is a  one month change due to a scheduling conflict.  This month we’ll be meeting in the room above the Caribou across the skyway from our regular location.

8000 Norman Center Drive,…

Read more

This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put together by community volunteers.  I was fortunate enough that I was selected to present at this event.  Since others have already shared their experiences at the event I figured… Read more

Ever thought about sharing your experiences with SQL Server to more than just your immediate peers and colleagues?  Up here in Minnesota we have just the opportunity for you!

On Friday, October 29, 2010 we’ll be hosting a SQL Saturday event.  Yes, on a Friday!  And we are looking for… Read more

Enjoying the fall here in Minnesota?  The leafs are changing a bit and temp has been dropping.  Has that left you feeling a little isolated?  Maybe it’s time to get together with some likeminded peers and talk about SQL Server.  This month’s PASSMN meeting will have Kalen Delaney (blog Read more

As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following:

• Index Black Ops Part 1 – Locking and Blocking
• Index Black Ops Part 2 – Page IO Latch,…

Read more

Ever feel like you are all alone?  Maybe a little isolated?  This month’s PASSMN meeting might bring up these feelings a bit.  That’s because we will have Kalen Delaney (blog) in town talking about isolation and concurrency.

To help with these feelings of isolation.  We’ll even be meeting… Read more

As I mentioned in the my TSQL2sDay index summary post, the next few posts will be on sys.dm_db_index_operational_stats and the information that the DMV contains.  In this post, we are going to look at the locking and blocking columns.

Base Columns

Before we jump over to the meat and… Read more

Here we are with another T-SQL Tuesday and time for my entry into the fray.  This month we are talking about indexes.  This is great timing because I’ve been meaning to write about indexes for a while.  A few months back I had outlined a number of articles I wanted… Read more

Have you taken the time to plan a fall get-away for some free SQL Server training?  You can do this through some of the one-day SQL Server training event happening across the country.

These are great opportunities to learn more about SQL Server and network with your peers that are… Read more