Here’s my bookmarked links for October 17th through October 23rd:

SQL Server Links

• Series of “Bad habits to kick” by Aaron Bertrand – There were a ton of great tips in this series, and I’m glad to see it getting press.
• Which Visual Studio 2010 is Team Suite? – Both Premium and Ultimate versions come with Data Dude features, and all versions come with Windows Azure access.
• How to use SP_CONFIGURE in SQL Server – Great summary by Mike Walsh of this basic tool.
• An Introduction to SQL Server System Databases – Good beginner/101 article for new database administrators.
• TIP: How to Run Programs as a Domain User from a Non-domain Computer – How to run SQL Server Management Studio as a different Windows domain user. Awesome for consultants.
• Meet the MCM’s and MCA’s! – Only 8 people outside of Microsoft have achieved the Microsoft Certified Master status in SQL Server. 8.
• MSDN Premium Subscribers and BizSpark Members to Receive Windows Azure and SQL Azure Benefits – Woohoo! Developers will have access to Microsoft’s cloud services.
• The patching game. – Test before you apply even the smallest patches to your SQL Server infrastructure.
• SQL Server Reporting Services Disaster Recovery Case Study – I often hear from folks who want to build DRP solutions for SSRS. This post lays out how to do it.
• Should I have a SNAC with my cumulative update? – When SQL Server patches and updates come out, we don’t always think to upgrade our clients, but there’s important fixes in there.
• Virtualisation for the DBA part 3 – SQL Server Performance – Andrew Fryer explains why a lot of servers work just fine under virtualization, and how to make ‘em work even better with data compression.

PASS Links

• What Direction Do You Choose? – Kevin Kline talks about how the PASS Nomination Committee works.
• PASS Update #16 – Andy Warren talks about his vision for PASS in the future. Great ideas.
• PASS Board Candidates – Andy Leonard explains why we should check managers for calluses.
• PASS Summit – My List of Tips – Andy Warren’s recommendations for a good time in Seattle.
• Transparency and PASS – Steve Jones talks about the nomination process.
• PASS Update #17 – Andy Warren talks about the ruckus around the PASS elections.
• Where Are My Cookies? – Tom keeps bringin’ the transparency to PASS.
• Another Year, Another Missed PASS Summit – K. Brian Kelly won’t be making it to Seattle this year, but he has two really good excuses: twins on the way.

Tech Links

• Windows 7 / Windows Server 2008 R2: Problem Steps Recorder – Windows 7 is awesome. Seriously, if I didn’t already have a Mac, and if I found a non-Apple laptop I liked enough, I might just roll with Windows 7. This is yet another example of why.
• Reading gets personal with Popular items and Personalized ranking – I already found a couple of interesting new feeds with this new Google Reader feature.
• Steve Ballmer’s Windows 7 pitch features MacBook Pro in the background – Yes, it does. Somebody’s gonna get fired.
• Setting up Hyper-V with a UPS – Set up your hypervisor so that it gracefully shuts down the guests first when the power goes out.
• Everyone Should Be Skeptical About Cloud Service Providers – Great post about problems with cloud providers and what questions you should ask.
• USB PC Prankster: guaranteed to freak out, enrage your cubicle mates – Turn on caps lock or garble text on someone’s PC after a timer delay. Brilliant.

The Junk Drawer

• Healthiness of food vs. cost of food – The less it costs, the worse it is.
• How to Speed Read Like Theodore Roosevelt – does what it says on the box.
• 10/16/09 PHD comic: ‘Parental Expectations vs. Time’ – Oh, man, I’ve been on the receiving end of this phone call.

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Here’s my bookmarked links for September 25th through October 2nd:

SQL Server, Cloud, and Tech Links

• Viva la Famiglia! – Brad Schulz shows how to use T-SQL to determine family relations. This is freakin’ awesome.
• PASS Board 2009 Slate of Candidates – Candidates are Brian Moran, Jeremiah Peschka, Matt Morollo and Thomas LaRock.
• PASS Elections and UStream | SQLRockstar – Tom LaRock is on the ballot again this year for the PASS Board of Directors, and you can ask him questions live in a video chat.
• Vote for Mr. LaRock – Grant Fritchey, author of SQL Server 2008 Query Performance Distilled, endorses Tom LaRock for PASS Board.
• Off-Hours Work: A Guide For Managers – If you have to rally the troops to work after hours, here’s how to do it with minimal morale loss.
• Interview with Kevin Kline – Tom LaRock interviews the former president of PASS.
• One Million Pageviews – StackOverflow hits the one-million-pageviews-per-day milestone. And yes, the back end is just one single SQL Server on relatively cheap commodity hardware with local disks, not SAN.
• HOW TO: Get Started with Google Wave – I think I’m the only guy who’s not jumping up and down clapping about Wave. I think it’s technically awesome, but it doesn’t solve challenges that I can’t solve right now with other methods. I’m going to ride this one out (get it – ride – wave – okay, maybe not) and wait a couple of months to see if it has staying power. (This from a guy who signed up for Twitter the instant he saw it years ago.)
• ROI from MCM: A look back 6 months later. – A Microsoft Certified Master talks about the changes it’s had on his billing rates and negotiations.
• YES WE CAN!!! – Jen McCown’s announcement about winning the SQLServerPedia Dream Trip contest. Very cool.
• DPM 2010 Beta is available now – Microsoft System Center Data Protection Manager is a very different way of backing up your databases (among many other things) and I’m interested to see what they brought in this new release. Says “can backup SQL servers with ~700-800 DBs” – makes me wonder what that bottleneck is.
• The ABCs of Management Studio Shortcuts – List of keyboard shortcuts for SSMS. Control+I is a neat trick.
• The old INNER JOIN syntax vs. the new INNER JOIN syntax – I got lucky – I started with the “new” syntax years ago and never looked back. It’s way better.
• Sessions for new DBAs at PASS – Bill Graziano suggests which sessions make sense for first-time attendees and new DBAs.
• Free Training in October at the Quest Connect vConference – Kevin Kline and I will be doing presentations and taking questions in our booth.
• Pre-Compiled Stored Procedures: Fact or Myth – Grant Fritchey plays Mythbuster.
• Inside Amazon’s Cloud: Just How Many Customer Projects? – An analyst estimated customers are launching 50,000 virtual servers a day on Amazon EC2.
• SQL Management Pack Survey – Live on Connect – Use Microsoft System Center Operations Manager (the artist formerly known as MOM)? Now’s your chance to influence development of the SQL Server management pack.
• Google Docs OCR – Another example of how cloud computing changes everything. The more we move services like this into the cloud, the more we can find creative uses for the data.
• Strong Password Generator – Uses T-SQL code to generate strong passwords. Interesting example.
• Consolidation Planning – Mike Hillwig is looking for feedback on his server setups.
• 10 Useful Usability Findings and Guidelines – Lots of “ah-ha” moments about how to make your web site look better and attract more permanent visitors.
• SQL Server Best Practices: Guard the Backup Files – You know the deal: the only reason we do backups is so that we can do restores. Buck Woody talks more about it.
• First Look: Zipcar app for iPhone hits the road – Find nearby Zipcars with your iPhone, then unlock them. I gotta play with this now that I’m in a city with Zipcars.
• Windows 7 coming to netbooks in all its myriad forms – YES! We won’t have to put up with the bullshit 3-app “Starter Edition” on netbooks – you can get ‘em with any version of Windows 7.
• Random Gradient Wallpaper Generator – Does just what it says on the box. Windows only though.
• Run Everything Virtualized and Deduplicated : aka Chuck Anti-FUD – Talk about cutting edge – people are talking about running their virtual servers on SANs that are being deduped. That would reduce the storage footprint required for a lot of Windows machines, for example, that all share a lot of the same binaries.
• How do checkpoints work and what gets logged – By Paul Randal.
• No, I will not do your homework for you – When posting forum & StackOverflow questions, think about phrasing them in a way to make sure nobody thinks you’re posting homework assignments.
• SQLIOSim Parser by Jens Suessmeyer & Yours Truly – SQLIOSim pushes load through your SAN storage and can simulate SQL Server IO patterns. However, like SQLIO, the problem is interpreting the results, which get dumped out to text or XML. Now there’s a utility to make it easier.
• Mississippi leads the way: 3 MCM’s a requirement in State IT RFP – Mississippi is requiring Microsoft Certified Masters if a consulting company wants to compete for a particular project. Wow. Just wow.
• Windows Server 2008 Enterprise edition and Virtualisation – When you use Enterprise Edition, you can install 4 OS guests for free. Andrew Fryer explains.
• Heard it from a friend who… heard it from a friend who… – Yet another hilarious blog posting from Colin, aka @BenchmarkIT. This guy’s on a roll. This time, he’s talking about a daisy chain of purity check info.
• Toys and Tools – Mike Hillwig’s favorite SQL Server utilities. (And yes, there’s a lot of Quest stuff in there, and no, I didn’t put him up to that.)

Writing, Blogging and Networking Links

• Books or Blogs: My Perspective – Scott Lowe, a published author, talks about whether or not writing books still make sense. I’d add that books force you to a higher level of technical accuracy due to the number of editors you have to get through.
• Tips for Networking at PASS – Great tips on how to meet fellow database administrators and why it can pay off.
• Shirts for Speakers? – Of everything in my closet, my very favorite shirt is my PASSCamp Germany polo with my name monogrammed on it. You could have knocked me over with a feather when Christoph and Oliver gave that to me. It made a huge impression, and I’m still really proud to wear it.
• 9 Ways to Make Your Writing More Compelling – Does what it says on the label.
• Tweet 2001: A Social Media Odyssey – OCDQ – Obsessive-Compulsive Data Quality – A ton of links about how LinkedIn, Twitter, and other social networks can work for data people.

The Junk Drawer

• The 50 most interesting articles on Wikipedia « Copybot – Good way to blow an hour and learn stuff.
• Nine Workspaces Where Famous Folks Get Stuff Done [Workspaces] – Most of these are publicity shots, but they’re still useful to see how people like Steve Ballmer set up their offices.
• Penny Arcade! – The Distinction – What if football was an RPG? Wait – it is! Final Fantasy Football….
• Tokyo Preview: Honda EV-N concept is retro-adorable, has unicycle storage – Please, please build this car. Let the world have an electric car that has some semblance of personality.
• 9 Secrets of Truly Happy People – You don’t become happy by saying “Yes” to people in an effort to make them happy. You have to pay attention to yourself and your own needs too.
• Me, Darth Vader’s brother, Guy Kawasaki and the hijacker from The Usual Suspects. Just, you know, hanging out. – In which The Bloggess comes up with alternate versions of The Little Engine That Could, like “The little engine that can’t take a hint.”
• Eff You, Penguin – Not safe for work – uses funny animal photos with NSFW captions.
• Penny Arcade! – Love Bombs From On High – Jesus loves me, this I know, because he gave me Gyromancer and…

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Posting this one a little early since I’ll be doing presentations all day tomorrow for a Quest Day with the Experts in Boston, MA.  You can watch online too.

SQL Server & Tech Links

• Query plans webcast next week with Kevin Kline – Simon Sabin is doing a free webcast with Kevin Kline on SQL Server query execution plans.
• Dates can easily be the hardest datatype to work with. – Good post by Denny Cherry about indexing date fields.
• Lessons Learned: When the Lights Go Out – Mike Hillwig shares notes after a disaster. Read stuff like this before it happens to you.
• More Free Training – Grant Fritchey talks about the QuestConnect webcast next month.
• Imitation Isn’t Always Flattery: Microsoft Previews Google Apps Killer To Beta Testers – Screenshots & explanations of the new online Microsoft Office.
• Deriving a list of tables in dependency order – When you need to empty out all of your tables but they’ve got foreign keys, you have to delete them in order. Jamie’s script gives you that order. (This beats my method of scripting out “truncate tables” for every table in alphabetical order, and then repeatedly hitting F5 until they’re all empty.)

The Junk Drawer

• Blur Tripod – iPhone tripod adapter and an app that has a built-in delay after you click to take a photo – that way the phone stops moving and the photo will be crisp.
• Professional Development: Internet Image – When someone tells you that you should have a nice, clean, sanitized blog that’s free of any personal details, send them this blog by Jason Massie. I’m right there with him – I would rather see someone’s personality. People are likable – Books Online is not.
• Trackin’ Away – Ping.fm now lets you track statistics on your broadcasted links. Yet another reason to use the PingPressFM plugin for WordPress.
• Training Benefits – When you stop training, your career comes to a grinding halt.
• Your Own Personal Development Plan – End-of-year reviews are coming up – time to start working on your Personal Development Plan.
• Recording a webcast for Quest Connect 2009 – Colin Stasiuk talks about the upcoming free QuestConnect webcast.
• Your company? There’s an app for that. – Many companies are going to be competing with dirt-cheap iPhone applications sooner or later.

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts