Currently viewing the tag: "Development"
When I teach powershell the question I get from DBAs most often is what is an overload. Because when we get into methods you can’t go very long at all without stating that they’re overloaded and most DBAs just don’t live [...]
As DBAs we quite often run into others who aren’t as smart as us. The dev is an idiot. The .net guy is an idiot. The users are idiots. The manager is an idiot. The VP, well don’t even get me [...]
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 [...]
Ok, so the other night I uninstalled my R2 install on my box and put on the new SQL2012. I know upgrade exists, but I just wanted the thing on there and didn’t feel like messing with anything stupid going wrong. [...]
I posted 2 new vids this week on SSRS. The first is a data-driven subscription primer that’ll get you up and running with not only what it takes to set it up, but the different methods you have for sending the [...]
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 [...]
Here’s something I wrote on SSC a few yrs ago and I thought I’d rewrite it here to make sure it’s fresh on everyone’s mind.
One of the things I hate the most about dynamic SQL is all those [...]
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 [...]
I spent about an hour last night working to solve this stupid problem with a report so I thought I’d share it with you guys. I’ve had this problem before, but for some reason I never remember it until I’ve had [...]
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!
SQL Cruise with me…
We'll be on the January 2013 cruise to the Bahamas, teaching and learning SQL and having a GRAND time after hours...all for the less money than a week of "normal" SQL training. Join us!
ITBookworm.com!- 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
