Date Rounding Tactics and the Tiny Devil of SMALLDATETIME
With every new year I think a little bit about time and dates. This posts looks a little more at that in TSQL.
Filling in Data Potholes Redux: Tally Tables vs CTEs
In A Previous Installment… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post “Filling in Data Potholes with Recursive CTEs.”
2010 liner notes and my theme for 2011
The MorningNews asked the following question recently:
Who you would recognize in your 2010 liner notes?
Filling in Data Potholes with Recursive CTEs
Imagine that you are writing a script that looks at data grouped by the minute. You notice that there are no rows for some minutes, and you’d like to display a value when that is the case, probably showing a count of zero.
The 9th Day of SQL: Things Are Not as Simple as They Seem
The 12 days of SQL
Brent Ozar (blog | twitter) had an idea: a group of people should blog about writing which they’ve loved this year by people in the SQL community. For each “day of SQL,” someone picks a blog which they thought was great and writes about it.
Invalid metadata in views and user defined functions
This week a question on the Twitter #sqlhelp hash tag reminded me of a detail of SQL Server that I learned the hard way, but forgot to blog about.
What the Business Wants: FEATURES
This month’s #tsql2sDay is hosted by Steve Jones (blog | twitter), and the topic is “What the Business Says is Not What the Business Wants.” Steve asks the question:
What issues have you had in interacting with the business to get your job done?
Review: A day of doing many things at once with @AdamMachanic
At SQLPass this year I was fortunate to attend “A day of doing many things at once: Multitasking, Parallelism, and Process distribution” by Adam Machanic (blog | twitter). This was a day long post-conference.
The Next 24 Hours of PASS Event: Announcement and Call for Presenters
Tonight I checked in on the Twitterverse and saw that Jason Strate announced a new blog post about the next 24 Hours of PASS event.
#SQLSat61, DC Edition: Free SQL Server Training in Reston, VA on December 4
I’m Talking About Partitioning!