Apr 20, 2012
Something for the Weekend – SQL Server Links 20/04/12
I hope you’ve had a great week.
How safe is your Gmail account? If you’re not all that concerned because you have a super secret complicated strong password you may want to read this post from Coding Horror: Make Your Email Hacker Proof. It takes a couple of minutes to set up but it could save you a whole world of pain.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Bug: reverting from a database snapshot shrinks the transaction log to 0.5MB - Another sneaky little Snapshot related bug revealed thanks to Paul Randal (Blog|Twitter).
- Maintenance Plans and Roombas Suck – in a Good Way - Making the case FOR maintenance plans. No really. It’s Brent Ozar (Blog|Twitter).
- Modifying Tables Online – Part 1: Migration Strategy - A high quality walk through from Michael J. Swart (Blog|Twitter). How would you solve this task in your environment? I’m loving the artwork in this post too, it really captures/communicates that tense moment all DBAs go through.
- BCP Script Generator - Sharing the results of her recent BCP adventures, Michelle Ufford(Blog|Twitter) provides us with another one of her valuable scripts.
- Max server memory configuration survey results - Interesting stuff as always in the latest survey results from Paul Randal (Blog|Twitter).
- Modifying Tables Online – Part 2: Implementation Example - Continuing his excellent series, it’s Michael J. Swart (Blog|Twitter)
- I was going to call this post “Windows Azure Best Practices” but I’m not allowed to - Buck Woody (Blog|Twitter) sharing Windows Azure Best Practices. Maybe he cannot boldly say so but SQL Brit sure can !
- Allans AlwaysOn Availability Groups FAQ - In case you did not know already, Allan Hirt (Blog|Twitter) has a ridiculous amount of knowledge to share when it comes to HA solutions using SQL Server. This week Allan talks about AlwaysOn Availability Groups.
- SQL Server 2012 Certification Changes Video - Summarising what you need to know about Certification changes for 2012 in this video, courtesy of Kendra Little (Blog|Twitter). I also talked about some of the hidden changes in my post Where Have all the DBAs and DB DEVs Gone this week.
UK SQL Server Upcoming Events
Misc Technology Posts
- Apple and Samsung bury differences over iPad launch
- ‘Action needed’ to meet UK’s cookie tracking deadline
- CompSci boffins tout file encryption for Google Docs
- Make Your Email Hacker Proof
“If you enjoy this weekly post of SQL goodness the best way you can show your support is by
sending me money sharing it so that even more folks can enjoy our fantastic community. Simply click one of the share options at the top of the on site post.”
Have a great weekend!