2010 liner notes and my theme for 2011
Category:
job-searching-and-career-development
The MorningNews asked the following question recently:
Who you would recognize in your 2010 liner notes?
Filling in Data Potholes with Recursive CTEs
Category:
database-administration
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
Category:
indexing
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
Category:
tsql-programming
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
Category:
devops
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
Category:
tsql-programming
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
Category:
webcasts-and-conference-sessions
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.