2011 April | Bob Pusateri - The Outer Join

Invitation to T-SQL Tuesday #18 - CTEs

This month marks the 18th installment of T-SQL Tuesday. T-SQL Tuesday was started in December 2009 by Adam Machanic (blog | @AdamMachanic) and is defined as “a recurring, revolving blog party”. Any blogger wishing to participate is invited to write about the given topic, chosen by whoever is hosting that particular month. [...]

Microsoft Exam 70-451 Wrap Up

20 April 2011 by Bob Pusateri in SQL Server , SQLServerPedia Syndication with 6 comments

This weekend I took and passed Microsoft Exam 70-451 (MCITP: Database Developer 2008). I’m pleased to say my score on this exam was much higher than its prerequisite, 70-433, which I wrote about a few months ago. Much like last time, I am happy to offer my thoughts for those who might be [...]

T-SQL Tuesday #17: Applying APPLY

12 April 2011 by Bob Pusateri in SQL Server , SQLServerPedia Syndication , TSQL Tuesday with 4 comments

This month’s T-SQL Tuesday is the brainchild of Matt Velic (blog | twitter) and was inspired by a quote from Adam Machanic (blog | twitter) on the importance of understanding the APPLY operator. It’s a good trick to have up your sleeve as it can do some nifty things and really save you some [...]

BETWEEN a DATE and a DATETIME Place

7 April 2011 by Bob Pusateri in SQL Server , SQLServerPedia Syndication with 4 comments

I’m not a fan of the BETWEEN operator. While the syntax is very easy to understand and requires less typing than my favorite alternative, it can lead to situations where unwanted results are returned. Because of this I’ve gotten into the habit of avoiding it all together.

If you’d like a refresher on BETWEEN, [...]