Archives: December 2010
It’s entirely fair to say that the highlight of my professional year is the PASS Summit in Seattle, and the highlight of the Summit is the recorded interviews we do each year (starting in 2009).
The way we pick interviews is, we say “Who do we like, and/or is… Read more
I’m looking for the attribution for a quote – it’s something I first heard from Sean, and we say it all the time: You never understand a thing until you teach it.
Along the way, I found this:
We learn more by looking for the answer to a question and…
This is a companion piece to the MidnightDBA video T-SQL: CASE Statement.
In short, a CASE statement is a simplified set of IF statements. Instead of using several IF statements, you can have a single statement that evaluates several criteria against a piece of data.
Let’s take… Read more
Well, my brain has increased by 12.4% in terms of SQL knowledge this week, as a direct result of my BOL readings, and according to numbers I’ve just made up. I’m sure it’s accurate.
The thing that has me preoccupied this week is how much I’m looking up and reading… Read more
I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS feedback scores and comments. But first, I’m going to tell you how I think my PASS session went: I give it a C+. 118 people attended… Read more
Hooboy…the super-structured format of the first two RTFM365 posts just isn’t sustainable for me. I’m going to have to go casual if I’m going to keep this up for another 50 weeks… Ditto for the week in review posts.
Hello and welcome to the December 2010 edition of T-SQL Tuesday. This month’s host is Steve Jones (blog|twitter) of SQLServerCentral, who poses the question: “What issues have you had in interacting with the business to get your job done”.
Oh…oh, well then. Stop me if… Read more
Here’s the rundown of what we were up to last week
Friday night at 11pm CST we present another wildly appealing episode of DBAs at Midnight. Log on at 10:30pm 12/17/2010 for the preshow. http://www.ustream.tv/channel/dbasatmidnight
Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t stop the server side trace, it stops SQL Server itself. Be warned.
It’s been a few months…time for another Spotlight!
Just to catch you up, occasionally someone in the SQL community – usually someone visible, but without celebrity status – catches my attention, and I feel like drawing attention and praise to that person. Over the last year, I’ve done Spotlights /… Read more
“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”
“Eat your broccoli.”
“Wear your gloves.”
“Schema qualify your objects.”
Your Mom wasn’t kidding, and she always gave the best advice. We’ve already seen how it would have paid off for us to end all T-SQL statements with a semicolon, even though it’s not currently required – after all, don’t… Read more
For the next year, I will read from SQL Server Books Online a little every day, and blog about it weekly. See my RTFM365 post for the full details on this project, and follow along with the series via the RTFM365 tag.
Reading this week was in SQL Server… Read more
I’ve got to figure out a good way to present a regular summary of what we do every week. Until I come up with a good idea, I’ll just post it here weekly.
Tomorrow (Friday) night at 11pm CST we present another stunning episode of DBAs at Midnight, this…
Physicians have primum non nocere – a Latin phrase that means “First, do no harm”. (Thank you, WikiPedia.) I think for techies, our principal precept is primum RTFM. (Here’s more Wikipedia, if you missed the joke.)
I don’t know as much about SQL Server as I should,… Read more