• 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

The Thinker

Are You A Technical Expert or Manager?

Are you a Technical Expert or a Manager? You certainly cannot be both. At least that's the consensus that I frequently encounter. A belief that you can only be one or the other but definitely not both. This is outdated thinking. It sounds to me … [Read More]

Team GB medal winners

How To Win Career Gold

The start of a new working year is often a time for self reflection. This is a great thing, it's the first step toward you achieving growth, improvement and ultimately better results. My fellow countrymen from Team GB know all about striving for … [Read More]

Top 10 SQL Server Tools

Top 10 Free SQL Server Tools

I know you all love talking about your favorite tools and maintenance scripts. Whether your pleasure is problem diagnosis, query tuning, index analysis or performance monitoring. These sql server tools are all available absolutely free and with the … [Read More]

TSQL Tuesday Logo

Step Up and Take More Ownership

This post is part of the T-SQL Tuesday Meme, this month hosted by Jason Brimhall. His chosen theme, to come up with a story where you "stood firm" and relate it to these words: resolve, resolution, or resolute.  Regular readers will know and tell … [Read More]

Stacked records

Your Top 10 Posts of the Year

Short and sweet today, here's what you enjoyed reading the most this year on the blog. No accounting for taste then. How To Become a SQL Server DBA My Guide To Passing Exam 70-432 Top 10 Junior DBA Interview Tips The Database Administrators … [Read More]

The Great DBA Getaway

It’s holiday season which means it’s a time for you all to buy me gifts super busy time for Data Professionals! Bosses are keen to take of advantage of the opportune downtime to get maintenance done and your colleagues are abandoning the office in … [Read More]

A Journey To SQL Authority

I am delighted to welcome to the blog someone who is without a doubt one of the biggest names in our SQL community.  A name that I am sure many, if not all of you will recognise, they’re one of the very first bloggers that I myself began to … [Read More]

Customers Love The Way I Jiggle – SQL Server Consulting

It's one of the most enjoyable things about being a SQL Server consultant. I'm not talking about my suspect dance moves here. I'm actually talking about a very powerful problem solving technique. Customers don't hire SQL Server consultants to … [Read More]

How To Simply Say You’re a DBA

Have you ever looked back on a conversation where someone asked you "what do you do?" and felt disappointed with your reply? Same here. So how do you explain to someone, who is not familiar with your field, what it is exactly that you do? Just … [Read More]

Where the Magic Happens

Being a Database Administrator is only one of many careers where you can work with SQL Server and so I was thrilled when Consultant Nick Haslam(Blog|Twitter) offered to share his own unique story with us as part of the What's it Like to be DBA post … [Read More]

The Hollywood DBA

I'm delighted to welcome a fellow Brit to the blog to share their story in today's guest post. Many of you will have read and enjoyed their work before, being a prolific blogger of awesome content over on Simple-Talk. A renowned personality in the UK … [Read More]

DBAs on Wall Street

Lunch is for Wimps

A real life DBA tale from the trenches with some awesome advice. That's what one reader chose to share with the community in response to my post What's it Like to Be a DBA. I found their story compelling and their message really resonated with me, so … [Read More]

DBAvolution

Guest Post – DBAvolution

One of my favourite things about the SQL community is the exquisite diversity of talent of it's members. Today for the "What's it Like To Be a DBA" post series, we're privileged to have with us a gentleman that not only flexes his technical muscles … [Read More]

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