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

Archives: March 2013

Reblog: March 22 to March 28

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 369 reads

Posted in StrateSQL on 29 March 2013

Chicago SQL Saturday (#SQLSat211) Coming Up


We’re less than three weeks away from the Chicago SQL Saturday.  This will be my fourth time heading to Chicago for their SQL Saturday and I’m looking forward to that and a stop at Portillo’s (which I probably shouldn’t mention since Sarah isn’t able to come along).  The… Read more

0 comments, 271 reads

Posted in StrateSQL on 26 March 2013

Pragmatic Works Webcasts This Week #passwit

Every week, Pragmatic Works offers up its “Training on the Ts” webcast series and this month, in honor of Women’s History Month, the series is showcasing all of its sessions with women speakers.  Doing this offers all of us a chance highlight some of the female voices in… Read more

0 comments, 350 reads

Posted in StrateSQL on 25 March 2013

Last Weeks Top “Reading” Links #25

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  These tweets include “Reading” in the message and are items I’ve read over the past few days, usually after hours when sharing would be… Read more

0 comments, 382 reads

Posted in StrateSQL on 25 March 2013

Fargo SQL Saturday (#SQLSat175) Schedule Is Up


It’s just coming up in just a few more weeks… this is the first SQL Saturday in Fargo.  North Dakota is one of the few states that hasn’t had a SQL Saturday.  With the help of my fellow PASS Regional Mentor Ted Krueger (Blog | @Onpnt), my… Read more

0 comments, 294 reads

Posted in StrateSQL on 22 March 2013

Reblog: March 15 to March 21

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 288 reads

Posted in StrateSQL on 22 March 2013

A Second March ‘Index Analysis’ Update

After this month’s Index Analysis update, I was contacted by a reader about the index analysis script.  Reader Dick Baker let me know that he found and had a fix for an issue with the missing_index_impact column.  Thanks to Dick for this fix.

If you find issues or have suggestions… Read more

0 comments, 303 reads

Posted in StrateSQL on 21 March 2013

Madison SQL Saturday (#SQLSat206) Coming Up


It’s coming up in just a couple weeks… the SQL Saturday in Madison, Wisconsin.  On April 6th, a couple hundred of your closest SQL Server peers will be meeting in the state of beer and cheese to do a little learning and networking around SQL Server.  I’ll be there,… Read more

0 comments, 414 reads

Posted in StrateSQL on 20 March 2013

Pragmatic Works Webcasts This Week #passwit

Every week, Pragmatic Works offers up its “Training on the Ts” webcast series and this month, in honor of Women’s History Month, the series is showcasing all of its sessions with women speakers.  Doing this offers all of us a chance highlight some of the female voices in… Read more

0 comments, 333 reads

Posted in StrateSQL on 18 March 2013

Last Weeks Top “Reading” Links #24

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  These tweets include “Reading” in the message and are items I’ve read over the past few days, usually after hours when sharing would be… Read more

0 comments, 288 reads

Posted in StrateSQL on 18 March 2013

Reblog: March 8 to March 14

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 339 reads

Posted in StrateSQL on 15 March 2013

Pragmatic Works Webcasts This Week #passwit

Every week, Pragmatic Works offers up its “Training on the Ts” webcast series and this month, in honor of Women’s History Month, the series is showcasing all of its sessions with women speakers.  Doing this offers all of us a chance highlight some of the female voices in… Read more

1 comments, 273 reads

Posted in StrateSQL on 11 March 2013

Last Weeks Top 20 “Reading” Links #23

Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet.  Here are the top twenty of the items that I linked out last week.  Typically, these are the tweets from things I read in the evenings and then share throughout… Read more

1 comments, 256 reads

Posted in StrateSQL on 11 March 2013

Reblog: March 1 to March 7

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Here is a… Read more

0 comments, 259 reads

Posted in StrateSQL on 8 March 2013

Index Analysis March Update

In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure today.  Without further ado, you can jump to the bottom and download it.  There are a few things I’ve fixed from comments from people using the script and then… Read more

5 comments, 313 reads

Posted in StrateSQL on 7 March 2013

That’s Actually A Duplicate Index

As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with them are duplicate indexes.  The problem with duplicate indexes is that they are pointless and redundant.  All they provide is an additional physical copy of the index and all you… Read more

10 comments, 1,661 reads

Posted in StrateSQL on 6 March 2013

March 2013 – Monthly SQL Server Checklist

It’s the first Monday of the month, do you know where your servers are?

Hopefully, they are still in your data center.  If not, I’m not sure this post will help you out, so you better just call the police.  But if they are in your data center, then do… Read more

0 comments, 352 reads

Posted in StrateSQL on 4 March 2013

Last Weeks Top 10 “Reading” Links #22

Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet.  Here are the top ten of the items that I linked out last week.  Typically, these are the tweets from things I read in the evenings and then share throughout… Read more

0 comments, 272 reads

Posted in StrateSQL on 4 March 2013

Reblog: February 22 to February 28

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 365 reads

Posted in StrateSQL on 1 March 2013