Pet Peeves

DBA Questions To Ask A Vendor

Questions for a DBA To Ask a Software Vendor

Do you buy software from independent software vendors? Does it run on SQL Server? Are you responsible for supporting that software? Here are some questions that you can ask a software vendor about the way they use SQL Server. It’s best to ask these questions before you are a customer, too, you’ll have a bit … Read more

You Keep Using That Word – T-SQL Tuesday Entry

Steve Jones is in the control room for this month’s T-SQL Tuesday challenge. His topic is a good one. I won’t repeat it here, just look at his post announcing this month’s topic. His topic is discussing challenges we’ve faced when dealing with “customers” (I use that to include clients, managers, colleagues, the business, etc.). … Read more

Bill Clinton Wasn’t Impeached For…

Yes, he was impeached, by the house and acquitted by the Senate. Not the point of my post today, forget the politics. He wasn’t impeached for all of that business with Monica Lewinski. Was it unethical? Yes. Was it immoral? Well to me it is. Was that activity an impeachable offense? No. Why was he … Read more

SQL Server Implicit Conversion: You Could Be Suffering Right Now

Implicit Conversion In SQL Server – A Silent Perf Killer I recently had the opportunity to work with a developer at the day job. He was using a loop (for what he was doing it actually makes sense 🙂 ) and he had a query that ran great when he stripped the query out of … Read more

Documentation

Documentation (…Or how I learned to stop procrastinating and love tolerate a chore necessary task) Do you document? Do you document well? As I told Paul Randal (twitter, blog) today on twitter, this blog post was inspired by an observation in the shower and a recent question by Brent Ozar (twitter, blog). You didn’t need … Read more