• 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 28/06/13

June 28, 2013 by John Sansom Leave a Comment

It’s 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….

SQL Server Links

  • WimbledonTroubleshooting: Tempdb Contention – Discussing one of the most common SQL Server performance problems and why it has nothing to do with I/O, it’s Paul Randal (Blog|Twitter).
  • Optimize for… Mediocre? – Kendra Little (Blog|Twitter) on using the OPTIMIZE FOR UNKOWN query hint to overcome the challenges of unpredictable execution plans.
  • SQL Server Partition Management Utility Part 1 – A fantastic walk-through of this freely available utility courtesy of Anthony Martin (Blog|Twitter).
  • Real World Experience with SQL Server 2014 In-Memory OLTP – A “wicked cheesy” video here but very interesting nonetheless from the SQL Server Blog (Blog).
  • Did You Know? What settings to always change – Sharing the SQL configuration settings that she always changes, it’s Kalen Delaney (Blog|Twitter).
  • The Elephant and the Mouse, or, Parameter Sniffing in SQL Server – Is Parameter Sniffing actually such a bad thing? Jes Borland (Blog|Twitter).
  • Determining a High-Availability Strategy – Jonathan Kehayias (Blog|Twitter) on why selecting a HA strategy should be an essential part of your initial server planning .
  • New DMVs in SQL Server 2014 CTP1 – Brent Ozar (Blog|Twitter) shares the list of new DMFs.
  • The Top 3 Indexing Mistakes in SQL Server (video) – Here’s this weeks video from Brent Ozar Unlimited with your host Kendra Little (Blog|Twitter).
  • TRY, CATCH, and Transactions – Jen McCown (Blog|Twitter) looks at the behavior of transactions when working with a TRY..CATCH Block.
  • Database Backup History From MSDB in a pivot table – A handy T-SQL query here shared courtesy of Steve Hindmarsh (Blog|Twitter).
  • Using OUTPUT to backup a Change – When making a change you ALWAYS need a rollback method. Kenneth Fisher (Blog) looks at using the OUTPUT clause as a backup alternative.
  • Managing Transaction Log Growth – An excellent walk-through showing how to  manage transaction log growth to support data archival, courtesy of Ted Krueger (Blog|Twitter).

SQL Community Forum

These are some of things being talked about right now by Data Professionals just like you in the Community Forum

  • Considering switching job – How do you know when it’s time to move on?
  • Third Party Tools – Do vendor products make DBAs dumber?
  • Share Your Favourite Performance Scripts – Scripts and utilities for the DBA that likes to work smarter.
  • SQL 2014 – SQL DBAs and Developers share their SQL2014 experiences so far. What yours been like?
  • You’re a Recruitment Consultant and you Suck – The stories continue…

Misc. Technology Posts

  • Amazon advances with Autorip – who can compete? – BBC News Technology
  • Obama says US won’t scramble jets or twist arms for Snowden – The Register
  • 10 New Features in Windows 8.1 Preview that saved my Surface RT – Scott Hanselmen
  • Drayson Racing electric car sets new world speed record – BBC News Technology

Have you enjoyed a blog post this week that deserves a mention? Share it in the comments and on Twitter(@SQLBrit).

If you enjoyed this weeks round-up of SQL content please show your support by sharing it. Click a share option at the top of the on site post.

Thanks for reading 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