• 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 13/04/12

April 13, 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.

Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!

SQL Server Links

  • The 5 Database Design Process Failures You Don’t Want To Make – Even great design can fall foul of process failures. Here’s 5 failures you don’t want to make, courtesy of Thomas Larock (Blog|Twitter).
  • Analytic functions – they’re not aggregates – Taking a more detailed look at some of the considerations for working with the new analytic functions in 2012, Rob Farley (Blog|Twitter).
  • DBA Darwin Awards: T-SQL Edition Webcast – In this webcast Brent Ozar (Blog|Twitter) shares insights into the top 3 T-SQL traumas he sees out in the field.
  • How It Works: HealthCheckTimeout Interval Activities – A look at some internals for clustering and AlwaysOn in 2012, brought to you by the CSS SQL Server Engineers (Blog).
  • Hash Partitioning, SQL Server, and Scaling Writes – Another high quality and insightful read from Jeremiah Peschka (Blog|Twitter), this week looking at how and when to scale SQL Server writes.
  • Converting SQL Trace to Extended Events in SQL Server 2012 – More from “Mr Extended Events” Jonathan Kehayias (Blog|Twitter) who has put a lot of work in to this for your benefit. Go try it out and let the man know what you think.
  • Importance of how you run consistency checks – The latest survey results are in, as Paul Randal (Blog|Twitter) discusses why he’ surprised by the numbers three years on.
  • An Introduction to VLDBs Video –  When is a database considered a Very Larger Database (VLDB) and what should you be doing differently when it comes to administering it? Brent Ozar (Blog|Twitter) with the answers in his second webcast of the week.
  • 2012 Party: Dancing on the FileTable – Busting a move for T-SQL Tuesday, Mike Fal (Blog|Twitter) takes a look at this new to SQL 2012 feature.
  • Understanding the sql_text Action in Extended Events – Jonathan Kehayias (Blog|Twitter)
  • Changes to Microsoft SQL Server Certifications – This week Microsoft announced a variety changes to SQL Server Certifications, in particular there are new tracks and the old tracks for DBAs and DEVs have been merged. Here’s Kendra Little (Blog|Twitter) with what you need to know.
  • SQL Server 2012: RML, XEvent Viewer and Distributed Replay – More SQL Server 2012 goodness for you, courtesy of the CSS SQL Server Engineers (Blog).

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

  • Life after Firefox: Can Mozilla regain its mojo?
  • Death Star dinosaur aliens could rule galaxy
  • Facebook buys Instagram photo sharing network for $1bn

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