SQL Server 2008 Service Pack 2 Released

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 Pack 2 includes a few new … Continue reading SQL Server 2008 Service Pack 2 Released

PASS Summit Schedule

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 during the summit.  And for those … Continue reading PASS Summit Schedule

To Be There Or Not To Be There

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 of you holdouts, I am count … Continue reading To Be There Or Not To Be There

Index Black Ops Part 4 – Index Overhead and Maintenance

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 Black Ops Part 3 – Index Usage … Continue reading Index Black Ops Part 4 – Index Overhead and Maintenance

Is It that Time Again?

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 If you haven’t, take the time … Continue reading Is It that Time Again?

Index Black Ops Part 3 – Index Usage

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 Latch, Page Latch Index Black Ops Part … Continue reading Index Black Ops Part 3 – Index Usage

SQL Saturday 50 (#sqlsat50) – A Tale

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 I should as well.  Some … Continue reading SQL Saturday 50 (#sqlsat50) – A Tale

Index Black Ops Part 2 – Page IO Latch, Page Latch

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, Page Latch Index Black Ops Part 3 … Continue reading Index Black Ops Part 2 – Page IO Latch, Page Latch

Index Black Ops Part 1 – Locks and Blocking

As I mentioned in 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 potatoes, let's first take a look at … Continue reading Index Black Ops Part 1 – Locks and Blocking

An Index on Indexing #TSQL2sDay

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 to write and have been … Continue reading An Index on Indexing #TSQL2sDay