May 11 2010
I love seeing good documentation in code. I really love seeing honest documentation in code. Seeing comments that basically show the developer has given up, hacked together a poor workaround to get a tasked accomplished at the cost of performance for every customer… full of Awesome. This is slightly redacted code from a stored procedure [...]
May 10 2010
#11 – Memory Settings Unless you have been working with SQL Server for a while, you may not go into the Server Properties or Facets and tweak much of anything after a successfull install. After all, there are a great deal of things out there and it can be really confusing. Let’s keep it really [...]
May 3 2010
That’s right. We’re on a boat and Autotune is forbidden. So is Auto_Growth. But SQLCruise? What is SQLCruise? Is it a SQL Saturday afterparty? Is it a Tweet-up at sea? Is it a new training event unlike anything else that you’ve ever heard of? Kind of, sort of, and oh yes indeed! SQL Saturday [...]
Apr 30 2010
#12 SELECT * Plain and simple this is a lazy habit that causes performance problems and possible code fail over the application lifecycle. That is all. “Explain myself” you say? Fine. Imagine you’re given a grocery list by your Significant Other that states: “Go to the Sunny Mart and buy everything. It’s exactly what we [...]
Apr 26 2010
#13 Being A Visible DBA At The Wrong Time I’ve given presentations where I state that one of the qualities of being a good DBA is being a visible one. The days of being a Database Administrator that sits in the smallest cubicle next to the noisy refrigerator and generally avoided by the rest of the [...]
Apr 23 2010
I give you exhibit A: The Last Straw: Yes, Third Party Software vendors out there are still trying to ruffie our SQL Servers. I encountered these instructions yesterday when reviewing a pending installation process. What you don’t see here though are items 1-11 in their instructions (one being a requirement for [...]
Apr 17 2010
I find myself sitting in the back of Jeremiah Peschka’s (web|twitter) session on Internals of The SQL Query Optimizer looking back on two presentations I conducted earlier today. Both ran long – 1 due to starting late, the other because it was just too damn big. Overall things went well. My shrinkingisbadandyoumustnotdoitorkittensaredevouredbyalligatorswhicharefedtobiggeralligatorswhicharethenrunoverbydrunkentruckers did not produce [...]
Apr 16 2010
As always seems to be the case I’m still changing up my newest presentation right up until the last minute. Yes, tomorrow I’ll be delivering two presentations here in Elk Grove, IL – where apparently the 1970′s never came to an end according to the bar I’m sitting in now surrounded by Teamsters and locals [...]
