• 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

DBA Survival Skills – Think Defensively

April 12, 2010 by John Sansom 15 Comments

No matter how much of a Super Hero DBA you consider yourself to be, I can guarantee you that there that there will come a time when you have to deal with either a disaster scenario or some form of mistake. Interestingly however, it is what happens next that separates the Pro’s from everyone else. Things Can […]

Filed Under: Disaster Recovery, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Backups, Planning, Thinking Defensively

SQL Server Essentials – Part 2: Why you should be using the FULL Recovery Model

July 27, 2009 by John Sansom 19 Comments

keep your data safe

In Part 1 of the “SQL Server Essentials” series we discussed the Database Administrator’s primary responsibility. Given that your data is so important, how can you manage and ensure it’s safekeeping? Should a data loss event occur, you want to be in a position to enable you to protect the majority, if not all, of […]

Filed Under: Disaster Recovery, SQLServerCentral Syndication, SQLServerPedia Syndication

The Database Administrator’s Primary Responsibility

July 20, 2009 by John Sansom 45 Comments

You’re busy coding away at your workstation when all of a sudden your manager walks over to you all excited and begins discussing with you, the details of this great new application your company has just aquired. It turns out that he wants you to look after and administer this newly aquired application platform, which […]

Filed Under: Administration, Disaster Recovery, Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Data Loss

Automate SQL Server Index Defragmentation,Optimisation

March 20, 2009 by John Sansom Leave a Comment

This week I came across what could quite possibly be, the best SQL Server index defrag script I have seen. This little beauty is fully customisable and is freely available courtesy of Michelle Ufford (aka SQL Fool) on her blog SQLFool.com As you know, it is just not practical to use a SQL Server Maintenance […]

Filed Under: Administration, Disaster Recovery, Index Optimisation, Performance Tuning, Tools

Disaster Recovery Planning – Getting Started

February 3, 2009 by John Sansom 1 Comment

The starting point for a rock solid disaster recovery (DR) strategy is to establish what the true cost of server/platform downtime would be to the business. The project will require you to collaborate with your key business decision makers and you will need to communicate to them what the associated costs of downtime are and […]

Filed Under: Administration, Disaster Recovery

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