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

Archives: April 2011

Learn T-SQL in 5 Minutes

I will be giving a five minute Lightning Talk at SQLRally in May that aims to do the impossible: Teach a n00b T-SQL in 5 minutes. I can guarantee that after my five minute talk, you’ll be an expert in T-SQL to rival the best of the best, or your… Read more

0 comments, 2,156 reads

Posted in SQL Awesomesauce on 29 April 2011

Drop the Noise

I’m reading Tim Ferriss’ “The Four Hour Work Week” (FHWW) right now, and it’s got me thinking about (among other things) clearing a lot of the “noise” out of my day.

I don’t need to work for 8 hours solid.  None of us can do that, anyway…we need… Read more

0 comments, 1,423 reads

Posted in SQL Awesomesauce on 28 April 2011

Fail-Win Balance

It’s a busy week for me, and a slow one technically. But I know that you, Constant Reader, thirst for knowledge and tips, and therefore I blog today.

Most of us are pretty busy. The very fact that you read blogs means you’re probably busy (I suppose it could mean… Read more

0 comments, 508 reads

Posted in SQL Awesomesauce on 20 April 2011

PASS Women in Technology

The Professional Association for SQL Server (PASS) Women in Technology group first caught my attention at the PASS Summit in 2009 when I was asked to live blog the WIT Luncheon. As it turns out, I had a lot to think about, and a lot to say.  Since then,… Read more

1 comments, 951 reads

Posted in SQL Awesomesauce on 12 April 2011

For Your Friday Enrichment: Get Alifeatoll

I have made something for your pleasure and entertainment, and placed it on the MidnightDBA YouTube Channel. Please to enjoy Get Alifeatoll.

Read more

0 comments, 508 reads

Posted in SQL Awesomesauce on 8 April 2011

Me Me Me, Event Event Event

Dear Readers,

Today’s blog shall be entirely stream-of-consciousness, which is to say, I don’t know exactly what I’m going to talk about. Call it an experiment in midweek blogging (when I’m not hyped about any particular topic).

Right now at work, I have some queries to put together for an… Read more

0 comments, 794 reads

Posted in SQL Awesomesauce on 7 April 2011

Meme Monday

Meme Monday story:

They’d never heard of indexes. Man, I was SUCH a rockstar!

-Jen McCown, MidnightDBA.com/Jen

Read more

0 comments, 584 reads

Posted in SQL Awesomesauce on 4 April 2011

Varying Results with Subquery, ORDER BY, MAXDOP

In the speaker rooms of SQL events everywhere, there is wondrous blog material to be had, free for the picking up (as long as you attribute properly).  Speaking of which…

Saturday in the SQL Saturday #63 Dallas speaker room, Erin Welker (blog) asked about a problem with a query… Read more

1 comments, 1,163 reads

Posted in SQL Awesomesauce on 4 April 2011

SQL Saturday 63 Dallas: EPICITY

SQL Saturday 63 Dallas. Will. Be. Epic.

Here are my proofs:

The Schedule. Note the gelato breaks. It is impossible to get more epic than gelato breaks.

The speaker lineup.  Reference The Schedule, please.

David Stein’s 11am session, which is entitled “T-SQL Programming to… Read more

2 comments, 500 reads

Posted in SQL Awesomesauce on 1 April 2011