THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » T-SQL Tuesday   (RSS)
Showing page 2 of 3 (23 total posts)
  • T-SQL Tuesday #25 Followup - Just in Time for the Holidays

    T-SQL Tuesday #25 fell on the same day I brought my mother home from a 3-day emergency trip to the hospital. She's much better, now, but it was a bit crazy there for a little bit. Thanks for everyone's best wishes. Rob Farley kicked off the official start of the event with a post titled A T-SQL Tip: Working calculations. He showed us how to use ...
    Posted to Allen White (Weblog) by AllenMWhite on December 17, 2011
  • T-SQL Tuesday #025 - Invitation to Share Your Tricks

    It doesn't seem that long ago that having cool little tidbits of information about SQL Server made a huge difference in how effective you could be. Well, that's still true, but let me give you an example. SELECT name FROM sysobjects WHERE sysstat & 4 > 0 In the early days of SQL Server, this was the way to pull a list of the names of all ...
    Posted to Allen White (Weblog) by AllenMWhite on December 5, 2011
  • T-SQL Tuesday 24: Ode to Composable Code

    I love the T-SQL Tuesday tradition, started by Adam Machanic and hosted this month by Brad Shulz. I am a little pressed for time this month, so today’s post is a short ode to how I love saving time with Composable Code in SQL. Composability is one of the very best features of SQL, but sometimes gets picked on due to both real and imaginary ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on November 8, 2011
  • [T-SQL Tuesday] Some code is born crap, some code achieves crapness and some code has crapness thrust upon it!

    I recently returned to a client at which I last worked back in 2006 and, as you might imagine, that gives me ample material for a blog post dedicated to Crap Code; conveniently the subject of the latest T-SQL Tuesday. I first worked for this client back in 2004 and that is significant because back then we were writing code on SQL Server 2000. Ah, ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 10, 2011
  • T-SQL Tuesday #19: Blind Spots

    A while ago I wrote a post, Visualize Disaster, prompted by a real incident we had at my office. Fortunately we came through it OK from a business point of view, but I took away an important lesson: it’s very easy, whether your organization and your team is savvy about disaster recovery or not, to have significant blind spots with regard to ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on June 14, 2011
  • TSQL Tuesday #11:Rolling Back TRUNCATE TABLE

    “It ain't what people don't know that hurts them it's what they know that ain't so”  -- commonly attributed to Mark Twain SQL Server has been around for a long time now, and people who learn one version well sometimes have  monumental task when a new version comes out. They need to figure out what changed. The ''What's New'' ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 12, 2010
  • TSQL Tuesday #8: Those who can, do, and those who want to learn more, teach!

    It's time for the eighth T-SQL Tuesday, managed this time by Robert Davis at SQL Server Central. This time, the topic was announced very late, and I was just starting to write a blog post of my own when I saw it. Fortunately, my topic easily fits into this month's topic of ''Gettin' Schooled'', which is supposed to have something to do with either ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 13, 2010
  • T-SQL Tuesday #5: My First Cube

    It's time for the fifth T-SQL Tuesday, managed this time by Aaron Nelson of SQLVariations. Once again, the deadline came up just too quickly, and I'm on the road this week, so my entry will not be too long. Aaron's topic is reporting and in keeping with my past posts, this contribution will include a history lesson.  Since I first learned ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 13, 2010
  • T-SQL Tuesday #4: I/O, You Know

    It's time for the fourth T-SQL Tuesday, managed this time by Mike Walsh. I almost missed this deadline completely, since I didn't see the announcement at all. I wrote to Adam to ask if there even was an event this month, since I wasn't able to get into my own blog site ( for a week, and he pointed me to Mike's site. I'm wondering ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 9, 2010
  • T-SQL Tuesday #3: SQL Server Relationships

    It's time for the third T-SQL Tuesday, managed this time by Rob Farley. I thought I wasn't going to make this deadline, since I have been swamped since the end of last week, and over the entire weekend. However, I've got a break with nothing urgent for the next hour or so, so I thought I could just write something short. My first two T-SQL ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 9, 2010
Privacy Statement