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
Don’t give up on Microsoft Connect. The process is not perfect but it can (and often does) work.
Next week I will be attending the 2012 Microsoft MVP Summit. This will be my third Summit but it feels like my first because there are going to be a lot of new faces there for the first time. That’s why I wanted to take the time to remind everyone that the MVP Summit is essentially … 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
Wanted to do a quick follow-up from my post earlier this week. If you recall, I mentioned how the Books Online entry for managing the suspect_pages table inside of the MSDB database was slightly misleading. I decided to use this as an opportunity to show you how easy it is to submit feedback to Microsoft … 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
