• 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

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 Implementation and Maintenance

Exam 70-432 – My Guide to Passing First Time

A reader wrote in to me last weekend regarding the MCTS Exam 70-432 (SQL Server 2008, Implementation and Maintenance). Hi John, I hope you are well. I am planning to take exam 70-432 and I could really use some guidance on how to go about my … [Read More]

Enough of the theme test posts already!

Some of you may have experienced a rather annoying volume of theme test posts in your RSS Reader yesterday. My apologies if that was the case. If you have no idea what I'm even talking about then you can completely ignore this post too … [Read More]

SQLRelay UK

[Update: Additional events added. See SQLRelay Just Got Bigger Folks – The King is Back] With the Olympics coming to the UK next year what better way to get into the spirit of things than with a good old fashioned race, a SQLRelay race! That's … [Read More]

Outstanding DBAs Make Relationships a Priority

In our open all hours global working world, do you ever wonder if perhaps the technology that is supposed to be bringing us closer together is inadvertently creating a world that is instead becoming more isolated? As Database Administrators (DBAs) … [Read More]

5 Ways to Be a More Effective DBA Today

Regular readers will now that I like to talk (quite a lot) about how we can be more effective as Data Professionals. Often the advice I put out there requires a consistent effort in order to really reap the greater benefits. Take my post series 5 … [Read More]

Look How Far You Have Come

A reader wrote to me over the weekend, seeking advice on behalf of their friend, who had been feeling deflated and lost on their SQL journey. Hi John, My long time friend ****** is a SQL DBA and he is feeling a bit down at the moment. He is … [Read More]

Too Many Disasters To Choose From (T-SQLTuesday)

I'm ashamed to admit that somehow this months T-SQL Tuesday has completely blindsided me, which is kind of ironic really when you consider the theme. It's a brilliant topic this month, hosted by Allen Kinsel (Blog|Twitter), who calls for … [Read More]

SQL Server Instant File Initialization (PQW)

Bluntly put, this is something that you always want to be taking advantage of. As a Database Administrator I’m always on the look out for Performance Quick Wins(PQW). Simple tweaks and changes that I can make to the SQL Server servers in my care … [Read More]

Is There Something Wrong With The Database?

I can think of no other simple phrase that has the same pent up potential to ignite the most colourful of discussions amongst technical professionals. Yes, it’s Meme Monday time. A creation brought to life by Thomas Larock (Blog|Twitter) that places … [Read More]

Start All Your Meetings in Pole Position

Let’s face it, a lot of us don't enjoy attending meetings and can often find them to be a bit of a struggle. They may even feel like a waste of time and sometimes dare I say it, they actually are! It doesn't have to be this way though and today I'm … [Read More]

Your DBA Role is Changing. Are you Ready?

Where do you see yourself in the future? Are you working at the same company, are you working in a similar role, does your current role even exist? “You must be the change you wish to see in the world.” - Mohandas K. Gandhi Change has always been a … [Read More]

What Are You Waiting For?

I know what I am waiting for. I know exactly what every SQL Server instance in my care is waiting for. Why? Because it’s my job to make SQL Server go faster. Identifying what your SQL Server Instance is waiting on will show you exactly where to look … [Read More]

Stop Asking and Start Making Decisions Today

Ever have one of those days where no matter how hard you try you just can’t seem to make any progress with your work? Sure you have. We all have days and moments like that. Sometimes it can feel impossible to get any real work done, with every task … [Read More]

  • « Previous Page
  • 1
  • …
  • 4
  • 5
  • 6
  • 7
  • 8
  • …
  • 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