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

Archives: October 2010

SQL Saturday 58 TODAY! #sqlsat58

Don’t forget the Minnesota SQL Saturday is TODAY.  Obviously, this was written before today and I’m hoping to catch a few people that might have forgotten. 

If so, jump in your car and head over.  The spot you registered for is still waiting for you.  Hope you can join us… Read more

0 comments, 576 reads

Posted in StrateSQL on 29 October 2010

Last Call for PASSMN Board of Directors

As I mentioned a couple weeks ago, we are looking for nominations for the 2011 PASSMN Board of Directors.  PASSMN is the Minnesota Chapter for the Professional Association for SQL Server (PASS) – otherwise know as a SQL Server User Group.

The call for nominations will officially end on Saturday,… Read more

1 comments, 211 reads

Posted in StrateSQL on 28 October 2010

2-Weeks to PASS Summit 2010 Countdown

It’s getting down to brass tacks.  There is now only 2 more weeks until the PASS Summit.  There’ve been a few posts over the last few weeks on the upcoming summit (1 , 2 , 3 , 4, 5) aimed at trying to rally those without plans… Read more

0 comments, 340 reads

Posted in StrateSQL on 26 October 2010

SQL Saturday 58 This Week #sqlsat58

Don’t forget the Minnesota SQL Saturday is this Friday.  Remember, we’re DIFFERENT and out event is on a Friday instead of a Saturday.

The volunteers have been busting butts to get ready for the event and things all seem to be coming together.  There should be some great fun this… Read more

0 comments, 218 reads

Posted in StrateSQL on 25 October 2010

Return of Index Analysis Part 5

Let’s Anaylze An Index!

Alright, up to the last of the changes I’ve made to the index analysis query that I had planned.  This makes the fifth post in the series on this query. 

The previous posts in this complete series are:

  1. Analyze Your Indexes Part 1 – Combine existing…

Read more

2 comments, 729 reads

Posted in StrateSQL on 25 October 2010

3-Weeks to PASS Summit 2010 Countdown -

Only 3 more weeks until the PASS Summit and it’s time for another countdown post. I’ve done a few of these now ( 1 , 2 , 3 , 4 ) to hopefully prepare readers for the opportunities at PASS. Trying make sure that you will know as much as… Read more

0 comments, 252 reads

Posted in StrateSQL on 23 October 2010

SQL Saturday 58 Next Week

Wow!  Minnesota’s SQL Saturday event is next week already.  We still have a lot to do to be ready.  Some things, like the speaker and volunteer shirts, are coming along as smooth as we’d hoped.  But I have faith we’ll be ready to go Friday morning.

If You Are Registered

Read more

0 comments, 241 reads

Posted in StrateSQL on 22 October 2010

Return of Index Analysis Part 4

Let’s Anaylze An Index!

We’ve got through the first three parts of this continued series on the Index Analysis query last week.  The previous posts in this complete series are:

  1. Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output
  2. Analyze Your Indexes…

Read more

1 comments, 335 reads

Posted in StrateSQL on 22 October 2010

SSWUG Fall 2010 Virtual Conference Starts Today!

Conference Time!

The SSWUG Fall 2010 Virtual Conference is starting today.  It’ll go on from today through Friday – if might be getting late but you can still attend the conference.  It doesn’t matter if you are in the comforts of your living room, office, or couch.  You can still… Read more

2 comments, 221 reads

Posted in StrateSQL on 20 October 2010

SSWUG Fall 2010 Virtual Conference This Week

Conference Time!

The SSWUG Fall 2010 Virtual Conference is coming up this week.  On October 20-22, you can attend a conference from the comforts of your living room, office, or couch.  And while you are at it you’ll get to sit in on some incredible presentations, interaction with speakers, and… Read more

2 comments, 194 reads

Posted in StrateSQL on 18 October 2010

4-Weeks to PASS Summit 2010 Countdown – Lunch

There are now 4 weeks until the PASS Summit and a few times now I’ve discussed ( 1, 2, 3 ) some of my thoughts as it approaches.  The goal here is to make sure that you will know as much as possible about the summit to get… Read more

4 comments, 308 reads

Posted in StrateSQL on 14 October 2010

Finding Missing Values from an Array

Missing Numbers

Today a developer came up to me and wanted help solving a problem he was running into with a list of numbers.  He had a list of 53 numbers in a comma separated list.

Unfortunately, the 53 numbers were not all in the table that he was querying.… Read more

3 comments, 392 reads

Posted in StrateSQL on 13 October 2010

Return of Index Analysis Part 3

Let’s Anaylze An Index!

Time for part three of my continued Index Analysis query.  The previous posts in this series are:

  1. Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output
  2. Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes…

Read more

1 comments, 460 reads

Posted in StrateSQL on 13 October 2010

Project Phoenix

Project Phoenix

Sometime people need a hand up – an opportunity to rise from the ashes.  Over the last couple of years the economy and unemployment has taken its toll on many of those in the community.  Along with that the charities that have often risen to help those in… Read more

1 comments, 369 reads

Posted in StrateSQL on 9 October 2010

SQL Saturday 58 Schedule Released

We technically released it on Monday but I didn’t want to blog about it for a couple days since we were waiting for a few speaker to confirm on their sessions.  But now that I’ve heard from nearly everyone it’s time to spread the word.

After looking at the speakers… Read more

0 comments, 340 reads

Posted in StrateSQL on 6 October 2010

Return of Index Analysis Part 2

Let’s Anaylze An Index!

Time for part two of my continued Index Analysis query.  The previous posts in this series are:

  1. Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output
  2. Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes

Read more

1 comments, 450 reads

Posted in StrateSQL on 6 October 2010

5-Weeks to PASS Summit 2010 Countdown

With 5-weeks until the PASS Summit it’s time to start getting ready for the event.  As I’ve discussed a couple times before (1, 2) the upcoming PASS Summit.  Over the next few weeks I plan to write about some of the things to make sure you do… Read more

0 comments, 275 reads

Posted in StrateSQL on 6 October 2010

PASSMN Board of Directors Nominations

It’s that time of the year again.  Time to get in some nominations for the 2011 PASSMN Board of Directors.  PASSMN is the Minnesota PASS Chapter or SQL Server User Group.

The open call will go from October 1 through October 30.  This gives you plenty of time to think… Read more

4 comments, 416 reads

Posted in StrateSQL on 6 October 2010

SSWUG Fall 2010 Virtual Conference This Month

Conference Time!

The SSWUG Fall 2010 Virtual Conference is coming up.  On October 20-22, you can attend a conference from the comforts of your living room, office, or couch.  And while you are at it you’ll get to sit in on some incredible presentations, interaction with speakers, and chat with… Read more

1 comments, 257 reads

Posted in StrateSQL on 5 October 2010

Return of Index Analysis Part 1

Let’s Anaylze An Index!

Time for part two of my continued Index Analysis query.  The previous posts in this series are:

  1. Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output
  2. Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes

Read more

1 comments, 480 reads

Posted in StrateSQL on 5 October 2010

Older posts