• 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 17/01/14

January 17, 2014 by John Sansom 2 Comments

Good reads from around the Web. Smart Coffee

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

Those rather nice chaps over on the Toad World Community have only gone and made yours truly their SQL Pro of the Month. Far too generous an accolade.

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

From the SQL Server blogs

  • 5 Ways To Verify What Your Big Data is Telling You – Are you seeing the big picture of your Big data – it’s Thomas Larock (Blog|Twitter).
  • Understanding the Row Chains of Hash Indexes – More SQL 2014 insights with Tony Rogerson (Blog|Twitter).
  • Curious Partition Function Behaviour – Curious partitioning behavior caught in action by Thomas Kejser (Blog).
  • Why I Work With SQL Server – Mike Fal (Blog|Twitter) on why he’s sticking to his guns, for now.
  • What Would a SQL Server Experience Index Look Like? – Exploring the idea of giving your SQL Server instances a performance score, it’s Brent Ozar (Blog|Twitter).
  • Who Owns SQL Backups? – Robert L. Davis(Blog|Twitter) shares his thoughts.
  • SSMS Trick: Edit Large Procedures with the Splitter Bar – A super quick tip from Kendra Little (Blog|Twitter). Why did I not know about this!
  • SQL Server Diagnostic Information Queries for January 2014 – Glenn Berry (Blog|Twitter)
  • Database in Source Control – Flying the DevOps flag high, it’s Grant Fritchey (Blog|Twitter). Make sure you read the comments.
  • A row with no fixed length columns – Classic SQL internals, using DBCC Page, with Kalen Delaney (Blog|Twitter).
  • How To: Restore the Master Database in SQL Server 2012 – An essential DBA walk-through courtesy of Thomas Larock (Blog|Twitter).
  • Doing More With Less – A novel approach to solving an ETL requirement, shared by Robert L. Davis(Blog|Twitter).
  • What Does a Good Mentor Do for You? – A closer look at the desirable qualities of a good mentor, it’s Kevin Kline(Blog|Twitter). Great advice for both being and finding a good mentor.
  • Inside Hekaton Natively Compiled Stored Procedures – SQL Server 2014 – A look at native code compilation.

Book of the week: The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win – This week Grant Fritchey was waxing on about the benefit of DevOps and he’s right! His post reminded me of a fantastic book I read last year that really helped me to understand the business angle for adopting a DevOps philosophy, never-mind the technical/implementation details. It’s not the Development team you need to convince of the benefits. This a great book for you senior Data Professionals to consider.

SQL Community Forum

Being discussed right now in the SQLBrit Community Forum

  • Low Cost + Great Return
  • SQL MCSA – Help my chances for a dba position
  • Second Verification Deployment Process

Other Stuff Worth Reading

  • The Database Administrator is Dead – TheNextWeb
  • Apple to refund $32.5m to parents –  BBC News Technology
  • Oracle spoils your day with NEARLY 150 patches – TheRegister
  • Where next for ‘new’ Google? –  BBC News Technology
  • Senior managers are the worst information security offenders – (In)Secure

Like these links? Subscribe to get them every week! Thanks and have a great weekend.

Filed Under: Link Posts, SQLServerPedia Syndication

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