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