For a very long time now I’ve preached to my various teams the value of doing your 20s. And I don’t expect most of you to know what that is, so here’s a quick explanation. I believe there’s certain syntax you [...]
I was recently asked to document some justifications around buying a load testing tool like Benchmark Factory. And for the record, while it’s not the only tool out there, I’m a huge fan of Benchmark Factory. I’ve used it for years [...]
Quite often there’s no benefit to a feature if you’re not using it, but this time that’s not the case. Even if you’re not using partitioning you can still take advantage of it in a really cool way.
Let’s say you’ve [...]
I just finished an interesting email thread with a user that’s not at all an uncommon scenario. They were just installing a CU to some of their SQL boxes, and there was evidently a new bug that was introduced into that [...]
This is gonna be a quick post, but I wanted to throw out a couple easy ways to avoid using xp_cmdshell.
Unfortunately this xp has gotten a bad rep, but only because it’s been abused. If you use it properly there’s [...]
Ok, aside from being kinda sick still, my morning has been filled with interesting issues. Ahhh– the life of a prod DBA.
It started today with space issues–again. We’re just running out of space everywhere and it’s hard to even keep [...]
The best database career advice you’ve never heard!
Become a DBA. Become a BETTER DBA. Use the Roadmap.
The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!
Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)
Visit www.DBARoadmap.com for info, forums, and more!
TagsArchitecture blunders Camtasia Career Coding Standards CPU data generator DBA Development disaster firewall Idiots Inside SQL Server Interview ITBookworm Jobs Kalen Delaney Katmai Ken Henderson LiteSpeed MidnightDBA PASS Summit 2011 Pinnacle politics Powershell Powershell Hero Query techniques Red-Gate reporting restore SQL Express 1433 SCM SQL Server SQLServerDVD.com SSIS SSRS Training troubleshooting TSQL Tuesday tuning Tutorials Video post videos Yukon
Interview: Kalen Delaney!
- Reading: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan
- Repost: “Problems with my new book” by Grant Fritchey
- Announcing SQL Server 2012 Query Performance Tuning by Grant Fritchey
- Quick Review: Logitech Trackball
- Book Review: Microsoft SQL Server 2008 Internals, by Kalen DeLaney et al