On Thursday, I’m doing a Quest Pain of the Week webcast with Michael Lato, SQLServerPedia’s T-SQL Coding Techniques Editor, to talk about handling application upgrades. When your developers and your third party vendors come to you with new apps that need database changes, you need to make sure their changes get applied smoothly, verify that [...]
Posts under ‘SQL Server’
I’m podcasting over at SQLServerPedia
I’ve recorded a bunch of SQL Server tutorial videos for SQLServerPedia, and we’re trickling them out as podcasts every Monday and Thursday. Today’s entry talks about the basics of SQL Server consolidation planning, and Thursday’s will cover how you can get bonused based off a successful consolidation project. You’re probably not going to get a [...]
SQL Server and Cloud Links for the Week
SQL Server Links
SQL Server security and roles - Jeremiah Peschka explains each of the roles (db_owner, db_securityadmin, etc) and talks about why you would use each role in the real world.
SSMS 2008 shows missing indexes - when you’re looking at a query execution plan, SSMS shows any missing indexes right in the plan viewer. This [...]
Tom LaRock and Pat Wright now on PASS Board of Directors!
Congratulations to Tom LaRock, aka SQLBatman, and Pat Wright, aka SQLAsylum, who just got into the PASS Board of Directors! Two board members had resigned, and Pat & Tom was appointed to one of those two positions. I’m excited because I believe these guys will make great board members, and I’m even more excited to [...]
New Year’s Resolutions
David Stein of Made2Mentor.com posted about his professional New Year’s resolutions (as opposed to personal ones), and Denis Gobo tagged me too, so here goes. I updated my GTD priority lists on RememberTheMilk during my vacation a couple of weeks ago and I’ve already forgotten them, hahaha, but that’s what RTM is for.
Learn SQL Server [...]
Meet my coauthors on Pro SQL Server Internals and Troubleshooting
Meet my partners in crime, the people who are going to coauthor the book on SQL Server internals:
Christian Bolton - he’s the Director and Database Architect at COEO and SQL Server MVP. Here’s Christian’s blog, and he’s ChristianBolton on Twitter.
Justin Langford - another SQL guru at COEO, a Principal Consultant, formerly a Microsoft Premier Field [...]
SQL Server and Cloud Links for the Week
Yes, it’s Monday. I’m late, blame the turkey. Happy Holidays!
SQL Server Links
Best SQL Server Blog Posts of 2008 - Jason Massie, that sneaky devil, uses that headline and then turns around to bait you into using Google Reader. He’s right, though, and I’ll post a quick explanation of how Reader works here shortly. You should [...]
New SQL Server exploit in the wild
There’s a new SQL Server exploit running around, and Denis Gobo’s done a fantastic job of covering it:
sp_replwritetovarbin Heap Overflow Code Exploit Code In The Wild, Works By Using Our Good Friend SQL Injection
SQLServerPedia Editors Chat recording now online
So you’re sitting in the office on a short holiday week and you don’t really want to do any work. Here’s what you do: pull up this webcast archive, put on the headphones, and tell people you’re in online training.
A little background about the webcast - a couple of weeks ago, I virtually sat down [...]
It was a dark and stormy night…
and I was hunched over my trusty, battered Macbook Pro, sipping whiskey by the backlit keys when the email came in. I got worried as soon I saw the sender, because Big Jimmy May is what they call a “Performance Consultant”. Before I even opened the email, I called my bookie to make [...]
