• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

Something for the Weekend – SQL Server Links 20/04/12

April 20, 2012 by John Sansom Leave a Comment

I hope you’ve had a great week.

Make sure you get to enjoy my round-up of SQL Server Links, community news and technology banter every week by Subscribing to the Blog Feed. You can also receive posts via Email.

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

Use the SQL Server Event Calendar to keep informed of all upcoming SQL Server events, User Groups, and training opportunities here in the UK. You can also add this calendar alongside you existing Google calendar.

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

Have you read a post this week that you think deserves a mention? Be sure to let me and other readers know by leaving a comment. You can also reach me on email and find me on Twitter(@SQLBrit).

“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!

Filed Under: Link Posts

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy