The hits just keep comin’! Here’s our new additions today:
Grant Fritchey, the Scary DBA
Grant, aka GFritchey on Twitter, is active in PASS and wrote the e-book Dissecting SQL Server Execution Plans. I met him at the PASS Summit in Seattle, and yes, he is indeed scary. He walked up to random developers in bars and yelled, “I saw that T-SQL you wrote! It’s disgusting! Gimme your beer!” And they would. He’s like the Gordon Ramsey of SQL. Some of his recent posts have included:
- How Profiler can Bring Down a Server – when people ask you to troubleshoot a database server using Profiler, make sure you are using a screaming fast machine for the profiling, and even then, be wary. I’ve had this happen to me on a data warehouse too.
- New England Data Camp Survey Results – Grant presented sessions on Visual Studio and execution plans, and the reason I’m linking to this particular blog entry is that you need to read his eval scores. They rock. If you ever get the chance to see him in person, I’m guessing you should take advantage of that opportunity.
- Apress Alpha Program – Grant’s writing a new book, SQL Server 2008 Query Performance Tuning Distilled. You can buy a preview of it now from Apress if you’re having performance issues and you can’t wait for the dead-tree version.
Scott Herbert aka the SQLNinja Blog
Scott Herbert started blogging late last year, and some of his recent blogs have touched on Reporting Services issues, something I appreciate learning more about:
- Why you can’t rename SSRS jobs – for the record, SSRS isn’t the only product that uses cryptic names for its SQL Server Agent jobs.
- Querying the SSRS database for subscriptions – you can tell when somebody’s an engine-type DBA as opposed to a point-and-click GUI user. Eventually us engine guys get frustrated and say, “Gimme access to the tables and I’ll just figure out my own query.” And Scott did.
- Modifying your TempDB setup – I’ve got a part of this in my SQL Server Setup Checklist, too.
