It’s Sunday evening. You are sitting down to have dinner with your family. Suddenly your phone rings. You want to ignore it because, let’s face it, your phone rings a lot. But you see the person calling and knowing they don’t call very often you decide to answer. On the other end of the line … Read more
Looking for a good book on SQL 2012? Only a handful are available right now, you can see a list of books available for pre-order over at Amazon. No, you won’t find my name as an author to any of them. I’ve been asked to write a chapter or two a few times but nothing … Read more
I know three areas of SQL 2012 that have bright future, and learning these three will serve you well for years to come. I am at the MVP Summit this week and I am soaking up as much information about these three items as I possibly can. 2012 is a release year. That means it … Read more
I came across an interesting scenario last week, someone needed to trace statements and they didn’t have SQL Profiler installed. Turns out they don’t actually need SQL Profiler in order to trace the statements hitting the instance. There is a trace flag (4032) that can be used to trace statements. When used with 3605, you … Read more
If your DBA is still adding Windows logins to your database servers then they are doing it wrong. Using logins (versus Windows groups) is an inefficient method that hasn’t been considered a favorable practice for almost ten years. Oh…sure…it works. I won’t argue that point. But if you are administering hundreds of database servers and you are using … Read more
Last year I wrote a book review about The Cult of the Amateur: How Today’s Internet is Killing Our Culture. The short of it is this: there is a shortage of fact checkers. And no, having facts checked by a community of users (AKA: Wikipedia) doesn’t work because those are the same amateurs that are running … Read more
