Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2010

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… Read more

1 comments, 613 reads

Posted in StrateSQL on 30 September 2010

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… Read more

0 comments, 596 reads

Posted in StrateSQL on 30 September 2010

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… Read more

1 comments, 248 reads

Posted in StrateSQL on 28 September 2010

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:

Read more

0 comments, 218 reads

Posted in StrateSQL on 23 September 2010

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:

Read more

2 comments, 643 reads

Posted in StrateSQL on 22 September 2010

September PASSMN Meeting Tonight

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

0 comments, 195 reads

Posted in StrateSQL on 21 September 2010

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… Read more

0 comments, 278 reads

Posted in StrateSQL on 21 September 2010

Share Your Experiences at #SQLSAT58

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

1 comments, 247 reads

Posted in StrateSQL on 20 September 2010

September PASSMN Meeting This Week

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

0 comments, 220 reads

Posted in StrateSQL on 20 September 2010

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:

Read more

3 comments, 1,562 reads

Posted in StrateSQL on 16 September 2010

September PASSMN Meeting Next Week

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

0 comments, 214 reads

Posted in StrateSQL on 15 September 2010

Index Black Ops Part 1 – Locks and Blocking

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

0 comments, 585 reads

Posted in StrateSQL on 15 September 2010

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… Read more

0 comments, 248 reads

Posted in StrateSQL on 14 September 2010

SQL Saturday Glory

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

3 comments, 304 reads

Posted in StrateSQL on 8 September 2010