Browse by Tags

• #tsql2sday
• BLOB
• CLOB
• date
• datetime
• gaps
• invitation
• islands
• learning
• LOB
• Performance
• puzzle
• reporting
• SQLCLR
• teaching
• time
• xml

• A Computer Scientist Meets T-SQL

  There I was. A freshly printed bachelor's degree in Computer Science tucked under my arm, I walked into my First Real Job. I'd never touched the technologies I was going to work with--ASP 3.0 and SQL Server--but my employer knew that, and I figured I'd Read More... Posted Tuesday, August 09, 2011 9:58 PM by Adam Machanic | 3 Comments Filed under: T-SQL Tuesday, #tsql2sday

• T-SQL Tuesday #21 - A Day Late and Totally Full of It

  “This ugly hack is only temporary,” you think. Six months later, a coworker curses your name, sacrificing a chicken to any deity that will help expedite your getting struck down by lightning, a school bus, or both. Crap code. We’ve all seen it. We’ve Read More... Posted Wednesday, August 03, 2011 3:38 PM by Adam Machanic | 40 Comments Filed under: T-SQL Tuesday, #tsql2sday

• A Year of Tuesdays: T-SQL Tuesday Meta-Roundup

  Just over a year ago I kicked off T-SQL Tuesday , "a recurring, revolving blog party." The idea was simple: Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted. Any blogger that wishes Read More... Posted Tuesday, December 07, 2010 2:07 PM by Adam Machanic | 7 Comments Filed under: T-SQL Tuesday, #tsql2sday

• Better Late Than Never: T-SQL Tuesday #008 - Gettin' Schooled

  Apologies for the late reminder; tomorrow is T-SQL Tuesday. This month's event is hosted by Robert Davis over at SQL Server Central and the theme is "Gettin' Schooled." How do you learn? Or how do you teach? Have you learned anything interesting recently Read More... Posted Monday, July 12, 2010 1:55 PM by Adam Machanic | 0 Comments Filed under: T-SQL Tuesday, #tsql2sday, learning, teaching

• T-SQL Tuesday #006: LOB Data

  Just a quick note for those of you who may not have seen Michael Coles's post (and a reminder for the rest of you): The topic of this month's T-SQL Tuesday is LOB data . Get your posts ready; next Tuesday we go big! Read More... Posted Thursday, May 06, 2010 2:31 PM by Adam Machanic | 0 Comments Filed under: T-SQL Tuesday, #tsql2sday, BLOB, LOB, CLOB

• T-SQL Tuesday #005: On Technical Reporting

  Reports. They're supposed to look nice. They're supposed to be a method by which people can get vital information into their heads. And that's obvious, right? So obvious that you're undoubtedly getting ready to close this tab and go find something better Read More... Posted Tuesday, April 13, 2010 4:13 PM by Adam Machanic | 3 Comments Filed under: T-SQL Tuesday, reporting

• T-SQL Tuesday #005: Reporting

  This month's T-SQL Tuesday is hosted by Aaron Nelson of SQLVariations . Aaron has picked a really fantastic topic: Reporting . Reporting is a lot more than just SSRS. Whether or not you realize it, you deal with all sorts of reports every day. Server Read More... Posted Monday, April 05, 2010 3:34 PM by Adam Machanic | 4 Comments Filed under: T-SQL Tuesday, #tsql2sday, reporting

• T-SQL Tuesday #004: IO, IO, It's Off to Disk We Go!

  Hey bloggers! Wake up and get your favorite editor ready. T-SQL Tuesday is back again, this time with a great topic hosted by Mike at StraightPath Solutions . Stop reading this blog and go read his. And then post! As I mentioned to a few Indian MVPs at Read More... Posted Monday, March 01, 2010 9:34 PM by Adam Machanic | 0 Comments Filed under: T-SQL Tuesday, #tsql2sday, invitation

• T-SQL Tuesday #002: The Roundup

  According to T-SQL Tuesday rules as ratified by me in the first and second T-SQL Tuesday posts, the T-SQL Tuesday host is supposed to post a roundup within two days of the end of the event. So a reasonable person should expect a roundup to be posted by Read More... Posted Monday, February 08, 2010 3:14 PM by Adam Machanic | 3 Comments Filed under: puzzle, T-SQL Tuesday, #tsql2sday

• T-SQL Tuesday #002: Is it XML, or Not?!?

  The query optimizer is a finicky thing , and sometimes it doesn't understand exactly what you're trying to do until you give it a bit more information. The situation I'm going to describe in this post is one such case. By providing the optimizer with Read More... Posted Tuesday, January 12, 2010 5:19 PM by Adam Machanic | 8 Comments Filed under: puzzle, xml, T-SQL Tuesday, #tsql2sday

• Invitation for T-SQL Tuesday #002: A Puzzling Situation

  Welcome to the second installment of T-SQL Tuesday, the monthly SQL Server blog party! Last month's kickoff event was a great success , and I'm really excited for this month's theme. I hope that we see even more bloggers, with even more great posts this Read More... Posted Monday, January 04, 2010 11:30 AM by Adam Machanic | 22 Comments Filed under: T-SQL Tuesday, #tsql2sday, invitation

• T-SQL Tuesday #001: Exploring "Fuzzy" Interval Islands Using SQLCLR

  When working with time intervals, we often want to ask a couple of basic questions: Which time periods are not covered by our intervals? These are known as "gaps". What are the time ranges that we are fully covering? These are known as "islands". If you're Read More... Posted Tuesday, December 08, 2009 3:13 PM by Adam Machanic | 2 Comments Filed under: Performance, SQLCLR, datetime, date, T-SQL Tuesday, time, gaps, islands Attachment(s): AdamMachanic_TSQLTuesday_ActiveProducts.zip

• Invitation to Participate in T-SQL Tuesday #001: Date/Time Tricks

  T-SQL Tuesday is the SQL Server blogosphere's first recurring, revolving blog party . The idea is simple: Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted. Any blogger that wishes to Read More... Posted Monday, November 30, 2009 1:47 PM by Adam Machanic | 57 Comments Filed under: datetime, date, T-SQL Tuesday, time