SQL Server Links
Bacon Gumballs
But it wasn’t my job to do the backups! – Learn this lesson from Jason Strate before you learn it the hard way, like I did. The backup guy swore our tapes were going offsite every day. Not so much.
How to find triggers using T-SQL – list all of the triggers in a database. Great idea for troubleshooting – before you scratch your head wondering why something’s not working the way you think, make sure there’s not a trigger behind the scenes.
SQL 2008 Database Compression whitepaper – best practices for configuring and using Enterprise Edition’s slick new feature.
Advanced SSIS interview questions – always hard to find good technical interview questions.
Get your learn on in June – Jeremiah Peschka lists upcoming free training events, plus I’ve got a bunch on my upcoming events page. I’m workin’ my tail off this month. As opposed to most months, where I sit by the water and drink champagne. Sorta.
DBCC with Repair_Allow_Data_Loss really does – Gail Shaw explains that yes, you can actually cut your fingers when you use scissors. Don’t point that tool around casually.
The simplest performance tuning tip ever – it’s really good, but I’d say it’s not the simplest because it requires building your queries right in the first place. The really simplest one is to drop those bazillion indexes you’re not using. Had another case this week with an OLTP table with over 40 indexes, 38 of which had never been used. Hello, McFly.
Building a SQL Server cluster for testing – Jonathan Kehayias, one of the coauthors on the book I’ve been working on, starts a series on how to build a virtual cluster to help learn SQL Server.
Your testbed needs to be as big as production – been there, done that. “But it worked on my machine!” Denis Gobo drives the point home with example code.
Why DBAs are paranoid control freaks – Mike Walsh explains it.
Cloud and Virtualization Links
What do you wanna know about virtualization? – Ken Simmons, a member of the PASS Hypervisors, wants to know what you want to know. We’re building content about virtualization, and we want to know what kinds of questions you’re looking to get answered. Take a minute to head over there and give him your comments.
Backing up your Windows Home Server to Amazon S3 – PASS VP of Marketing Bill Graziano shows how to do it. I just love Amazon Web Services – I published a video this week on datamining, and I got thousands of people watching the video in a matter of hours. My site stayed up fine because the thick content is all cached on Amazon S3 and Amazon CloudFront. Total cost to survive the Reddit effect with video on my site: around $10. Awesome.
Junk Drawer
Ken Block is a driving deity – watch this and your mouth will hang wide open for seven minutes straight. He’s that good. Jump to one minute into the film for the action. To see a man with a huge amount of testicular fortitude, jump to four minutes in and watch the senseless paintball violence. Think about being confident enough in somebody’s driving to stand there while this happens. Wow. I won’t even ride shotgun with some bozos, let alone stand in front of their car like that.
Microsoft updates install a Firefox extension – because, you know, it’s a good idea. What, you disagree? Try uninstalling it. Good luck with that.
From Finger to Bung – wherein Tom LaRock uses the Bing search engine to find someone and then says out loud, “I Banged him.”
Calvinball Projects – remember the Calvin and Hobbes comic series, and how they played Calvinball, a game where the rules kept changing?
Why joint ventures fail so often – when there’s not one person in the driver’s seat, don’t be surprised if you don’t end up at the right destination. From Rob Boek’s shared items.
Jobs at StackOverflow – StackOverflow and ServerFault are adding job boards. The thing I like about this is that the types of people who understand enough to advertise in these places are aleady a cut above typical headhunters.
