• 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 15/02/13

February 15, 2013 by John Sansom Leave a Comment

It’s SFTW Time, I hope you’ve had a great week!

Did you get a chance to see SQLBrit on SQL Server Central this week?

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

SQL Server Links

  • Rose

    An English rose….Valentines

    DBCC SHOW_STATISTICS Works With SELECT Permission – SQL 2012 SP1 improvement when working with Linked Server queries shared by Benjamin Nevarez (Blog|Twitter).

  • A new Q & A site, with plan uploads directly from Plan Explorer! – A post on SQLPerformance.com via those clever folks at SQLSentry(@SQL_Sentry).
  • Behind the scenes of PowerShell and SQL – This weeks standout T-SQL Tuesday piece for me is from Rob Farley (Blog|Twitter), where he looks at the bigger picture of PowerShell and our use of it.
  • Buffer pool disfavoring – An interesting look at why some operations (DBCC CHECKDB for example) do not flush the buffer pool. Paul Randal (Blog|Twitter) explains.
  • Graphically Viewing Extended Events Deadlock Graphs – Jonathan Kehayias (Blog|Twitter) demonstrates another great update to Plan Explorer.
  • SQL Server Naming Standards – Grant Fritchey (Blog|Twitter) has his say on this highly personal topic. As you can imagine, the comments are quite passionate.
  • Day 28 of 31 Days of Disaster Recovery: Recovering SQL if the Tempdb Drive Dies – Continuing his monster sized series, it’s Robert L. Davis(Blog|Twitter).
  • Tracking page splits using the transaction log – An excellent dose of SQL Internals from Paul Randal (Blog|Twitter), demonstrating how you can read the transaction log to identify page splits.
  • Under rare conditions, using IN clause can cause unexpected SQL behavior – More real world customer support cases from the CSS SQL Server Engineers (Blog).
  • T-SQL Tuesday #39 – Powershell Sorts! – You can never have too much PowerShell magic, Jim McLeod (Blog|Twitter) shares.

Community Forum Conversations

These are some of the discussions going on right now in the SQLBrit Community Forum

  • SSIS: Passing a variable to a table
  • Studying to take MCTS 70-432 for First Time. I am Nervous!
  • Best Practices SSIS
  • Select * Syndrome

UK SQL Server Upcoming Events

Use the SQL Server Event Calendar to keep informed of all upcoming SQL Server events, User Groups, and training opportunities here in the UK. You can also add this calendar alongside you existing Google calendar.

Misc. Technology Posts

  • Why you need a home lab to keep your job – TheRegister
  • How I Cleanup Up My Desk Cabling – Inspiring cable management from Brent Ozar
  • iOS 6.x hack allows personal data export, free calls – TheRegister
  • Meteor strike injures hundreds in central Russia – BBC News Technology

What was your favourite post? Read a blog this week that you think deserves a mention? Share your thoughts in the comments and find me on Twitter(@SQLBrit).

Make sure you don’t miss this weekly round-up of SQL Server Links, community news and technology banter by Subscribing to the Blog Feed.

Subscribe to the blog via RSS

Get SFTW posts delivered direct to your Inbox free via Email.

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