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

January 10, 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.

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

From the Blogs

  • Seven Foods Developers Love – Surprised to see that humble pie is not on the menu, it’s Pinal Dave (Blog|Twitter) serving up a treat.
  • Reliably Dropping a Database in a T-SQL Script is Too Hard – Dropping a database is not always as easy as you think, it’s Greg Low (Blog|Twitter).
  • SQL Simplicity Methods – Michael J. Swart (Blog|Twitter) on why it’s important to try to lead a simple life as a Data Professional.
  • Divide and Conquer – The final part to an exceptionally well written series by Mike Fal (Blog|Twitter) on NoSQL technology architecture. Good stuff sir.
  • What’s the Smallest SQL Server You Should Build? – Get your head around SQL Server 2012 licensing(or at least make a start) courtesy of Brent Ozar (Blog|Twitter).
  • Why Are You Still Using SQL Server 2005? – Helping us to accept that it really is time to move on, it’s Jes Borland (Blog|Twitter).
  • Our Favorite Links of 2013 [Video] – Sharing their favorite selection of links and resources for 2013 it’s Brent Ozar (Blog|Twitter) and co. I even got a mention, no accounting for taste.
  • Sausage Making – Grant Fritchey (Blog|Twitter) on paying down your technical debt this week.
  • Survey: restoring and rebuilding master – Be sure to take part in the latest survey from Paul Randal (Blog|Twitter). The more folks that get involved the more valuable the insights we all get to learn from.
  • Hekaton In-Memory Tables: HASH Indexes – Kicking off a post series on SQL 2014 In-Memory feature a.k.a HEKATON, it’s Tony Rogerson (Blog|Twitter).
  • Throughput improvement from SQL Server 2014 – An interesting look at the DELAYED_DURABILITY option in SQL 2014, with Tony Rogerson (Blog|Twitter).
  • Unwinding Table Spools – SQL Server internals with Dmitri Korotkevitch (Blog).
  • Anyone, Everyone, Someone and No-One is “On Call” – We’ve all had the short-straw at one time or another but there are actually advantages to having a rota. Chris Shaw(Blog) discusses.
  • Dynamic Sorting – A rather ingenious T-SQL design pattern courtesy of Jeremiah Peschka (Blog|Twitter).

Book of the week: Start with Why: How Great Leaders Inspire Everyone to Take Action – Being a successful Data Professional is about so much more than technology. Do you really understand why you are responsible for the data assets within your organisation, why your customers come to you first with their technology needs? It’s NOT because you solve their problems, that’s WHAT you do. Once you understand the real WHY of things, getting others to take action is easy because they will want to.

Other Stuff Worth Reading

  • The 15 Most Valuable Cloud Computing Companies – Business Insider
  • CES 2014: Samsung shows off its Bendable TV – BBc News Technology
  • Is Your Boss Warming Up The Bus – Brent Ozar
  • CES 2014: PlayStation games go console-free – BBc News Technology
  • ‘Leaked’ iPhone 6 pics – TheRegister

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