• 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

Featured Post

Automation

The Best Database Administrators Automate Everything

Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once it's gone, that's it, gone forever. As a Database Administrator (DBA) your skills, services, expertise and ultimately your time will always be in demand. You can only ever deliver on a finite amount of time, that's just … [Read More]

Latest Posts

Get Your Ass to PASS!

This year there are to be no excuses, and I mean it. You know what I’m talking about. There’s always some reason why you can’t go to the PASS Summit, why you can’t make it this time around. Maybe the timing is just not quite right, you can’t get … [Read More]

Guest Post – The Last Starfighter

Today I am delighted to be able to share with you a guest post from one of my all time favourite bloggers in the SQL community. Their high quality, unique and creative content regularly making the cut for a place in the SFTW post roundup. I’ve been … [Read More]

What’s it Like to Be a DBA?

Absolutely fantastic of course! You regular readers know that the Becoming a DBA area of the blog is one of the most visited and talked about, with the professional development posts often proving popular. All the comments, questions and emails you … [Read More]

Powershell

PowerShell Script to Configure SQL Server Storage

Following on from the popularity of my last PowerShell post Script SQL Server Agent Jobs Using PowerShell, I thought I would share another script I created to make life being a DBA that little bit easier, in the hope that you too may enjoy the … [Read More]

Where Have all the DBAs and DB DEVs Gone?

Last week the SQL community and in particular the blogosphere, was buzzing with interest noise following the Microsoft Learning site publishing details of significant changes to SQL Server Certifications. Here We Go Again You know the drill. It’s … [Read More]

How To Live Blog an Event

As the euphoria of SQLBits X sadly begins to fade, I wanted to take a moment to share with you my experience of Live Blogging the keynote of Europe’s largest SQL Server conference. To be honest this was not something that I had planned to do but … [Read More]

Packed out at SQLBits X

Liveblog for #SQLBits X Day 1 Keynote

Welcome to the show! I'll be liveblogging today's keynote here at SQLBits X in London. There's no need to refresh your browser folks, we're technology savy here at SQLBrit don't you know and using a LAMP stack ;-) Send your Tweets to @SQLBrit and … [Read More]

SQL Server Crossword #4

To mark my 31st Birthday today(gifts are of course most welcome) here's a SQL Server Crossword for you to enjoy. You can also find the previous crosswords here(#3), here(#2) and here(#1). Same as before, the answers are all SQL Server words that you … [Read More]

Help Design The New Blog Logo

Regular readers will no doubt have noticed the new look and feel to the blog. It has been a long overdue update and one that I hope will give more focus to what’s important, i.e. content by making posts more accessible, easier to locate and … [Read More]

SQL Server 2012

What SQL2012 Feature Are You Excited About the Most?

Last week the internet went crazy with the news of super cool new stuff for techies to play with. If you're having trouble viewing this post click here to see it in all it's intended glory. I'm currently experimenting with some snazzy blog authoring … [Read More]

What Does a Database Administrator Actually Do?

Most people in your organisation, never mind everyone else, have no real clue as to what it is you do. It’s not because you don’t actually do anything, at least I hope not, it’s because the domain of responsibility for a DBA is both vast and varied. … [Read More]

How To Write an Interview Winning CV

Writing a CV that rocks is not an art. It just requires some planning and an understanding of what you want your CV to achieve for you. Of course therein also lies the problem because of lot folks are not exactly sure what they want their CV to do … [Read More]

Getting Organised

Your Road to Becoming a DBA: Getting Organised

Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of you, identifying what is the best way to move forward for you is vital. This post is part three of the series Your Road to Becoming a … [Read More]

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • …
  • 21
  • Next Page »

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