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!
SQLPASS Day 1 and 2: Please Focus Your Attention on the Command Prompt
A sign will be henceforth posted on my office door which reads: “PLEASE FOCUS YOUR ATTENTION ON THE COMMAND PROMPT.”
And I will always make sure to remember to be careful when working with the Engine of the Devil.
TSQL Tuesday #12: Why Are DBA Skills Necessary? Fido, Please Turn Your Head And Cough.
It’s sort of like Daylight Savings time for #TSQL2sday. Since PASS is next week and we’ll all be busy tweeting from the convention center instead of talking to one another face to face (or the opposite, take your pick), we’re blogging a week early.
This month’s topic is hosted by Paul Randal (blog | twitter), and the topic is “Why are DBA skills necessary?”