SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2011

MCM Exam – Take 2

Yesterday, I went in for my re-take of the MCM written exam.  If you recall, I failed the exam last time.  I did a great job of failing, in fact, and only received a 522 on the exam.  I didn’t share my score previously because it was a bit… Read more

4 comments, 550 reads

Posted in StrateSQL on 29 March 2011

#SQLSat67… it’s mystery is only exceeded by it’s power.

We’ve seen a few summaries come through by now, so I’m going to throw mine into the mix.  To recap those that I’ve already read, there are:

Read more

2 comments, 659 reads

Posted in StrateSQL on 29 March 2011

Index Black Ops Series

Previously, in a TSQL2sDay index summary post, I started a series on the DMV sys.dm_db_index_operational_stats.  The series investigates how the columns in the DMV are populated and demonstrates how to aggregate values in the DMV.

The posts in this series are:

Read more

0 comments, 818 reads

Posted in StrateSQL on 26 March 2011

TechFuse Follow-Up

Last week I spoke at the TechFuse event in Minnesota – out at Mystic Lake Casino.  As I mentioned in the session, I wanted to post the content from my session – Discovering The Plan Cache.

Along with including a few links that people might find useful.  First, we… Read more

0 comments, 466 reads

Posted in StrateSQL on 24 March 2011

What Are Your Indexing Strategies?

A couple weeks ago, I got some pretty great new.  The book proposal that I had submitted to Apress was accepted.  Over the next few months, I’ll be working on a book with a focus on indexing.

As part of this, I want to find out your indexing strategies?  It’s… Read more

5 comments, 616 reads

Posted in StrateSQL on 22 March 2011

Twin City Code Camp 10 Is Coming

Twin Cities Code Camp will be hitting the University of Minnesota Campus again next month.  This is a biannual event in the Twin Cities where developers can get together and show their code.  An opportunity to see what other people are doing and to exchange ideas.

The event is on… Read more

0 comments, 566 reads

Posted in StrateSQL on 18 March 2011

There’s A New North Central Regional Mentor

What has two thumbs and just signed on to be a PASS Regional Mentor?  This guy!

Over the past couple weeks, I’ve been going back and forth with some e-mails  with PASS.  The result of which places me in the open Regional Mentor position for the North Central region.

For… Read more

0 comments, 682 reads

Posted in StrateSQL on 17 March 2011

Happy Pi Day

Here’s wishing you a Happy Pi Day…

Pi in Pie Pan

If my picture isn’t good enough, here’s a better representation of pi.


Hope you didn’t forget about Daylight Savings if you are one of the those afflicted by this change in the time zone.

Related posts:

  1. Happy Pi…
Read more

1 comments, 489 reads

Posted in StrateSQL on 14 March 2011

March PASSMN Meeting This Week

I mentioned the PASSMN meeting last week and thought a reminder might be worthwhile.  Just in case you head has been in the clouds.

This month we have:

SQL Azure – Relational Data in the Cloud
Steve Hughes, Magenic

This session will review SQL Azure capabilities and tools. We want… Read more

1 comments, 566 reads

Posted in StrateSQL on 13 March 2011

Aggregating With Correlated Sub-Queries #tsql2sday

It’s that time of the month again.  Time for T-SQL Tuesday!  This month’s event is being hosted by Jes Schultz Borland (Blog|@grrl_geek).  The topic that she chose for this month is aggregates.

The Dilemma

A few months ago, a client I was working with had a dilemma… Read more

2 comments, 683 reads

Posted in StrateSQL on 8 March 2011

SSWUG DBTechCon Coming Up

Over the last few years, I’ve blogged about and spoke at the SSWUG Virtual Conferences.  It’s that time of the year again, and the next virtual conference is coming up in a few short weeks.  The event will be on April 20-22 and you can attend from the comforts of… Read more

0 comments, 462 reads

Posted in StrateSQL on 7 March 2011

XQuery for the Non-Expert – Aggregates

Talk to the Experts

In  the last post, I discussed using functions within XQuery with the Substring() function as part of the XQuery for the Non-Expert blog series.  To continue on that… Read more

2 comments, 1,239 reads

Posted in StrateSQL on 7 March 2011

March PASSMN Meeting Announced

Come one, come all to the March PASSMN meeting – that’s the Minnesota SQL Server User Group.  This month we’re going to the cloud and hope to have you join with us on the Ides of March.  Now there won’t be any assassinations going on but we are hoping… Read more

0 comments, 649 reads

Posted in StrateSQL on 4 March 2011

TechFuse 2011 – This Month

If you’re looking for a day of training in the Twin Cities, then check out Benchmark Learning’s 2011 TechFuse event.  The event features eight tracks of sessions from infrastructure and developer topics to, of course, SQL Server topics.  The event is on March 17, 2011 at Mystic Lake Casino… Read more

0 comments, 602 reads

Posted in StrateSQL on 2 March 2011