Home » 24HOP »24HOP »Beginner »Intermediate »sql server »SQLPASS »sqlserverpedia-syndication »SSC »Tips »TSQL » Currently Reading:

24 Hours of PASS Spring 2011 Code Sins

Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring 2011.  Thanks to the 750+ of you that attended, and the many who commented!!  I will be updating this blog post with links and answers to questions for a few days yet.

The 24HOP recorded sessions will be available sometime in the next few weeks. In the meantime, feel free to check out the Code Sins session I gave at SQL Saturday Houston this year (good session, crappy recording), or Code Sins 2010 from at SQL Saturday #41 Atlanta (here’s that version’s slide deck).


Here is the Code Sins 24HOP Spring 2011 zip file! The file contains the SQL files and PowerPoint deck you saw online. 


Here are some links and recommendations I promised during the session.


I cannot reccommend Itzik Ben-Gan’s books highly enough. Depending on your level and your needs, you should get at one (or more) of his T-SQL books. (Link goes to my Amazon store, but of course order from wherever you like):

T-SQL Fundamentals

T-SQL Querying

T-SQL Programming

I have a few resources out there for you, too:

To get started in T-SQL coding, check out my Beginning T-SQL session from SQL Saturday #41 Atlanta (2010). Download the slide deck.

For a step up in T-SQL coding, see my 24 Hours of PASS Fall 2010 session T-SQL Brush-up (requires PASS login). Download the demo code here.

Here’s my Petri article on string type basics: String Data Types in SQL Server: VARCHAR vs. CHAR, 6/2010

We have about a dozen T-SQL tutorials on MidnightDBA.com in the Dev Section

On UNIQUEIDENTIFIERs (GUIDs), here is one of Kimberly Tripp’s blogs: Disk Space is Cheap (THAT’S NOT THE POINT!!) One of the best quotes is from one of her comments: “There are situations where people insist that they MUST use a GUID for those, there’s the newsequentialID function.” See also (from Kimberly):

GUIDs as PRIMARY KEYs and/or the clustering key

The Clustered Index Debate Continues…

Ever-increasing clustering key – the Clustered Index Debate……….again!


If you’ve hardly heard of normal forms or design principles, check out my Petri articles How to Design and Build SQL Server Tables – Part 1 and Part 2


Here’s an absolutely brilliant editorial on cursors by Phil Factor

A SQLTeam blog confirming that WHILE isn’t better than CURSOR

My blogs on performance, views, and nested views: Proving Views Can Hurt Performance, Detangling Nested Views

I recommended the book SQL Server 2008 Query Performance Tuning Distilled by Grant Fritchey and Sajal Dam (my book review)

About Me

Aaaaaand here’s the quick About Me (sort of a summary of the About Me page):

This is my blog.  You probably know that. Leave me a comment!

Hubby Sean and I make SQL tutorials, free on MidnightDBA.com

Follow us on Twitter

Email me with horror stories, questions, comments, and suggestions at Jen@MidnightDBA.com

Join in our weekly webshow DBAs@Midnight Fridays at 11pm CST at http://bit.ly/DBAShow

Currently there are "5 comments" on this Article:

  1. What an awesome session today! High five on a great talk.

  2. [...] I was so wrong! The first session I ever attended via 24 Hours of Pass was T-SQL Code Sins by Jen McCown. And what an awesome way to get introduced to the organization! I seriously cracked up during the [...]

  3. Diana says:

    Great session. Thank you :)

  4. [...] from Your SSIS Hat@Kendra_Little 24 Hours of Rad: 24HOP Spring 2011 Recap@MidnightDBA 24 Hours of PASS Spring 2011 Code Sins@StaciaMisner Multidimensional Thinking–24 Hours of Pass: Celebrating Women in [...]

Comment on this Article:

Release Date: Minion by MidnightDBA

Just 2 days 3 hours 26 minutes 12 seconds until we release Minion Redindex: index maintenance done right!

MidnightSQL Consulting

Need help? Got an emergency? Write us at Support@MidnightDBA.com!

We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.

For more information about MidnightSQL consulting, email us or check out www.MidnightSQL.com. Happy days!

Where are We?

November 3-7: PASS Summit, Seattle, WA

PASS Summit: Jen is presenting How to Interview a DBA: A Panel Debate on Thursday 11/6 1:30pm, room 401 (along with Adam Machanic, Sean McCown, Bob Pusateri, and Michelle Ufford).

PASS Summit: Sean is presenting Performance Tuning Your Backups on Wednesday 11/5 3:00pm, room 602-604.

December 11: Presenting "Powershell Cmdlets.." at Alaska SQL Server User Group

January 30: "Become an Enterprise DBA" precon at Austin SQL Saturday

Blog Posts by Category


How to Eat Pop-tarts
Watch DBAs@Midnight live on Fridays,m 11pm Central time

The best database career advice you’ve never heard!


The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!

Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)

Become a DBA. Become a BETTER DBA. Use the Roadmap.

Visit www.DBARoadmap.com for info, forums, and more!

Add to Cart View Cart

Cunningham’s Law

"The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."
Relevant: http://xkcd.com/386/