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

February 8, 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 Techie Stuff. Enjoy.

SQL Server Links

scones

“Performance problems all scone”

  • DBCC WRITEPAGE: an introduction – Essential reading here from Paul Randal (Blog|Twitter). Have fun breaking learning things.
  • The Fastest Query is the One You Never Make – This post from Brent Ozar (Blog|Twitter) is worth a visit for game changing graphic alone, never-mind the great content.
  • HOW SAFE IS YOUR DATA FROM THEFT? – A history lesson couple with some great advice from Thomas Larock (Blog|Twitter), imploring you to get off your ass and check your security is up to scratch.
  • DBAs and the Dark Closet – Grant Fritchey (Blog|Twitter) on coming out of the closet.
  • Incorrect Results with Indexed Views – If you use MERGE, indexed views and foreign keys, your queries can return incorrect results. Paul White (Blog|Twitter) with the lowdown.
  • Building a Larger Capacity SQL Server 2012 Workstation – Because bigger is better, it’s Glenn Berry (Blog|Twitter).
  • WHERE to JOIN? – Getting a bit nostalgic on us this week it’s Mike Fal (Blog|Twitter), looking at join performance based on positioning within query syntax. Also an interesting look at an online SQL comparison tool.
  • How Does the Cloud Change a Database Administrator’s Job? – More career wisdom from Mr Buck Woody (Blog|Twitter).
  • Don’t change value of that parameter – A parameter sniffing case with a difference from the CSS SQL Server Engineers (Blog).
  • “UPSERT” Race Condition With MERGE – An insightful look at the the locking behaviour of the MERGE statement from Dan Guzman (Blog|Twitter).

SQLBrit Community Forum

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

  • Unit Testing in SQL Server
  • Backups with Blocksize Option
  • There’s Just Never Enough Time

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
  • Apple sued as activist demands it share out more cash – BBC News Technology
  • In pictures: The household gadgets of yesterday – BBC News Technology
  • LibreOffice 4.0 ships with new features, better looks – TheRegister

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