• 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

(SFTW) SQL Server Links 31/01/14

January 31, 2014 by John Sansom Leave a Comment

Good reads from around the Web.Smart Coffee

It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week.

Regular readers know that I’m a big believer of using any available opportunity during the busy day to get my learn on. I find audiobooksare a splendid way to achieve this. Each day I commute roughly for two hours, a perfect opportunity to turn otherwise wasted downtime into a productive and enjoyable experience. I use Audible.com and right now they’re offering 50% off of subscriptions for a limited time only. An opportunity I encourage you take advantage of.

Listen to a bestseller for $7.49 at audible.com!

This week I’m listening to Chris Hadfield’s amazing: An Astronaut’s Guide to Life on Earth: What Going to Space Taught Me About Ingenuity, Determination, and Being Prepared for Anything. Who knew that being an astronaut has so much in common with being a DBA!

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

From the SQL Server blogs

  • Reporting in Production: SQL Server (video) –  Jeremiah Peschka (Blog|Twitter) is your host, discussing methods to provision support for reporting workloads against your production environment. Brent is also offering up a hat-tip (unintentional?) to Mr Bigglesworth.
  • Building Concurrency Tests – Michael J. Swart (Blog|Twitter) continues his excellent series on building a framework for testing concurrent activity in SQL Server. I think I’ll be borrowing this.
  • Disaster recovery 101: restore master or rebuild master – The results are in! Here’s Paul Randal (Blog|Twitter) on why every DBA should be familiar with this administration task.
  • Using Powershell with SQL Server Clusters – Getting Information – PowerShell, it’s magic. Go learn some. Here’s Sean Gallardy(Blog|Twitter) on how you can simplify working with SQL Server Clusters.
  • Exploring the Magic of the Plan Cache – Identifying optimization opportunities via the Plan Cache, with Jeremiah Peschka (Blog|Twitter).
  • SQL Server Hekaton (XTP) in-memory tables: Choosing the correct BUCKET_COUNT for a Hash Index – Continuing his insightful series on Hekaton, it’s Tony Rogerson (Blog|Twitter).
  • UPDATE STATISTICS: the Secret IO Explosion – Making the case for keeping a closer handle on your SQL Server Statistics management with Kendra Little (Blog|Twitter).
  • Final Service Packs for SQL Server 2008 and SQL Server 2008 R2 – Glenn Berry (Blog|Twitter) on whether we can expect to see SP 3.
  • What Do You Ask the Leaving DBA? – How much? Brent Ozar (Blog|Twitter) ran a Twitter discussion to find out and here he shares the community’s wisdom. Some jolly good stuff here.
  • Watch Brent Tune Queries  – Ever wonder how someone else does it? Peer over the shoulder of Brent Ozar (Blog|Twitter).
  • Inside the Statistics Histogram & Density Vector – A very well presented walk-through, courtesy of Klaus Aschenbrenner (Blog|Twitter).

Other Stuff Worth Reading

  • Apple’s iPod: is the end nigh? – BBC News
  • What does “challenging” really mean? – Colleen Morrow
  • Experience Comes from Mistakes – Chris Shaw
  • Oracle releases ‘lite’ virtual Big Data appliance – TheRegister
  • Amazon stock slides 10% on earnings miss – BBC News
  • 10 Reasons to Stop Working So Hard – Inc.com

SQL Community Forum

Conversations happening right now in the SQLBrit Community Forum

  • Help with Plan Guides
  • Stranded on a desert island
  • Professional Development and Proactive Tuning

Like these links? Subscribe to get them every week! Thanks and 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