It’s been a while since I’ve done one of these, but not due to a lack of good content, that’s for sure. There’s been a ton of great info out lately, so much so that I haven’t had time to compress it all into a linkpost. I won’t do one again for the next couple of weeks since I’ll be on vacation, but while I’m gone (and indeed, afterwards) you should subscribe to Jeremiah Peschka’s blog and Rhonda Tipton’s blog, both of which do a great job on linkposts.
Wanna know what I’m reading in real time? Subscribe to my Google Reader shared items RSS feed or my Delicious bookmarks feed. Whenever I like an item, it’ll show up immediately in these feeds. Now, on to the links….
SQL Server Links
Understanding MemToLeave – For years, I thought the only SQL Server memory settings that mattered were the minimum memory, maximum memory, AWE/PAE and locking pages in memory. MemToLeave matters if you’re using third party backup utilities (like LiteSpeed) and it’s been really hard to find good info about it – until now, thanks to Jonathan Kehayias.
Why the DMVS Can’t Replace Traces – Profiler and traces have a bad reputation because they impact performance, and DMVs have a good reputation because they don’t. Gail Shaw explains why DMVs still aren’t a silver bullet.
Top 10 Connect Items by Votes – Michael Swart talks about the most requested enhancements for SQL Server. Note that you too can vote on items like this – SQL Server’s features are determined in part by users just like you. Not you specifically, though, because you haven’t voted yet. No pressure.
How to Configure TempDB on a Multi-Core Server – Stuart Ainsworth passes on lessons he learned from Microsoft’s support team. He updated the blog post a couple of times as he got more info from more sources, and this is one of those topics with a lot of room for interpretation.
What Happened to My Fabulous Beverage? – Jason Strate brings kegs and sample T-SQL code together in wonderful harmony.
Tim Ford’s First Contest – he ran a contest asking readers to guess what stunt a vendor tried to pull. He’s since posted the answer, but first read the comments on the contest post. I got a huge laugh out of these.
How to Create a Server-Side Trace – Jorge Segarra shows how these run faster than Profiler traces.
Cloud and Virtualization Links
Benchmarking SQL Server 2008 on VMware – wanna know how much of a performance penalty you pay by running SQL Server inside VMware? The short story is around 14%, and the long story is in the PDF report from VMware.
Amazon Web Services Start-Up Challenge – Amazon’s giving away cash and AWS credits to the best startup ideas.
SQL Azure name change – the artist formerly known as SQL Data Services is now SQL Azure. I hope the technical team is doing better long-term planning than the marketing guys. That is all.
How to Configure EMC PowerPath/VE – this gets you active/active multipathing for VMware vSphere. (I’m horrified to admit that I still don’t have vSphere 4.0 in my lab yet, and my upcoming vacation isn’t going to help things any.)
The Junk Drawer
How to Build a Successful Blog – if you only watch one hour-long video on blogging this week, it should be this one by Tim Ferriss, author of The 4-Hour Workweek. If you watch more than one hour-long video on blogging, you need to go get a job.
Seattle datacenter fire knocks out lots of sites – I’ll be using this as an example in my disaster recovery presentations. The photo of sysadmins carrying their servers out of the colo facility tells an awesome story.
NNTP is Dead – Jason Massie shows statistics about the rise and fall of Usenet.
The way Matt Mullenweg works – the founder of WordPress talks about his habits.