I hope you’ve had a great week.
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
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
“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!