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

Archives: December 2010

2010 PASS Summit Interviews

It’s entirely fair to say that the highlight of my professional year is the PASS Summit in Seattle, and the highlight of the Summit is the recorded interviews we do each year (starting in 2009).

The way we pick interviews is, we say “Who do we like, and/or is… Read more

3 comments, 1,788 reads

Posted in SQL Awesomesauce on 30 December 2010

Quick Thoughts on Learning

I’m looking for the attribution for a quote – it’s something I first heard from Sean, and we say it all the time: You never understand a thing until you teach it. 

Along the way, I found this:

We learn more by looking for the answer to a question and…

Read more

0 comments, 499 reads

Posted in SQL Awesomesauce on 29 December 2010

T-SQL: CASE Statement

This is a companion piece to the MidnightDBA video T-SQL: CASE Statement.

In short, a CASE statement is a simplified set of IF statements. Instead of using several IF statements, you can have a single statement that evaluates several criteria against a piece of data. 

Simple CASE

Let’s take… Read more

4 comments, 2,685 reads

Posted in SQL Awesomesauce on 28 December 2010

RTFM365, Week 3

Well, my brain has increased by 12.4% in terms of SQL knowledge this week, as a direct result of my BOL readings, and according to numbers I’ve just made up. I’m sure it’s accurate.

The thing that has me preoccupied this week is how much I’m looking up and reading… Read more

2 comments, 756 reads

Posted in SQL Awesomesauce on 28 December 2010

PASS Summit Speaker Evals – THE ANALYSIS

Rule: No Sushi with Adam within 24 hours of session

I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS feedback scores and comments. But first, I’m going to tell you how I think my PASS session went: I give it a C+. 118 people attended… Read more

2 comments, 774 reads

Posted in SQL Awesomesauce on 23 December 2010

RTFM365, Week 2 (AND week in review)

Hooboy…the super-structured format of the first two RTFM365 posts just isn’t sustainable for me. I’m going to have to go casual if I’m going to keep this up for another 50 weeks…  Ditto for the week in review posts.

By the way, did you know there’s a lunar eclipse tonight Read more

1 comments, 658 reads

Posted in SQL Awesomesauce on 20 December 2010

T-SQL Tuesday #13–A Business Walks Into a Bar….

Hello and welcome to the December 2010 edition of T-SQL Tuesday. This month’s host is Steve Jones (blog|twitter) of SQLServerCentral, who poses the question: “What issues have you had in interacting with the business to get your job done”.

Oh…oh, well then.  Stop me if… Read more

0 comments, 540 reads

Posted in SQL Awesomesauce on 14 December 2010

All Things Awesome and MidnightDBA-y – 12/9/2010

Here’s the rundown of what we were up to last week

Friday night at 11pm CST we present another wildly appealing episode of DBAs at Midnight. Log on at 10:30pm 12/17/2010 for the preshow. http://www.ustream.tv/channel/dbasatmidnight


Articles: No new articles on Petri.co.il this week, but you should read Sean’s How… Read more

1 comments, 803 reads

Posted in SQL Awesomesauce on 13 December 2010

RTFM365, Week 1

Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t stop the server side trace, it stops SQL Server itself. Be warned.


For the next year (-10 days now), I will read from SQL Server… Read more

0 comments, 496 reads

Posted in SQL Awesomesauce on 10 December 2010

Spotlight: Jes Borland

It’s been a few months…time for another Spotlight!

Just to catch you up, occasionally someone in the SQL community – usually someone visible, but without celebrity status – catches my attention, and I feel like drawing attention and praise to that person. Over the last year, I’ve done Spotlights /… Read more

3 comments, 1,354 reads

Posted in SQL Awesomesauce on 9 December 2010

24HOP Needs Women!

“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”

Thus goes the announcement on the SQLPASS homepage.  This means that we’d like you – yes, YOU madam! – to consider submitting an abstract to speak. Off the top of my head,… Read more

3 comments, 804 reads

Posted in SQL Awesomesauce on 7 December 2010

Tip: Schema Qualify Objects in SPs

“Eat your broccoli.”

“Wear your gloves.”

“Schema qualify your objects.”

Your Mom wasn’t kidding, and she always gave the best advice. We’ve already seen how it would have paid off for us to end all T-SQL statements with a semicolon, even though it’s not currently required – after all, don’t… Read more

4 comments, 1,699 reads

Posted in SQL Awesomesauce on 6 December 2010

RTFM365 Week 0

For the next year, I will read from SQL Server Books Online a little every day, and blog about it weekly.  See my RTFM365 post for the full details on this project, and follow along with the series via the RTFM365 tag.

Reading this week was in SQL Server… Read more

3 comments, 708 reads

Posted in SQL Awesomesauce on 3 December 2010

All Things Awesome and MidnightDBA-y – 12/2/2010

I’ve got to figure out a good way to present a regular summary of what we do every week. Until I come up with a good idea, I’ll just post it here weekly.

Tomorrow (Friday) night at 11pm CST we present another stunning episode of DBAs at Midnight, this…

Read more

1 comments, 639 reads

Posted in SQL Awesomesauce on 2 December 2010


Physicians have primum non nocere – a Latin phrase that means “First, do no harm”. (Thank you, WikiPedia.)  I think for techies, our principal precept is primum RTFM.  (Here’s more Wikipedia, if you missed the joke.)

I don’t know as much about SQL Server as I should,… Read more

1 comments, 581 reads

Posted in SQL Awesomesauce on 1 December 2010