• 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

What is your biggest SQL Server mistake?

February 17, 2009 by John Sansom Leave a Comment

You know the one I am talking about. We have all been there at some point. You get that awful feeling of dread as a chilling realisation sets in and you ask yourself, oh my god did that actually just happen. Sure you can laugh about it now though, right. So come on and share […]

Filed Under: SQL Server Tips

New SQL Server Resources

February 12, 2009 by John Sansom Leave a Comment

    One of the joys of working with SQL Server technologies is that there are some truly great knowledge resources available for use. You just have to know where to look. With the volume of information available it can be difficult to sift out the really good stuff. I know throughout my time as […]

Filed Under: 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

Stackoverflow addiction

January 31, 2009 by John Sansom 3 Comments

Well I suppose it was both inevitable and only a matter of time before I became the next victim of Stackoverflow addiction! I hold BrentO fully responsible for this devourer of my valuable free time. For it was he who introduced me to what is quite possibly one of the best technology forums on the […]

Filed Under: SQL Server Community Tagged With: Forums

Here is a Wordle for this site

January 29, 2009 by John Sansom Leave a Comment

Wordle seems to be doing the rounds on the SQL Server blogs and community resources at the moment so I thought I would knock one up for this site.

Filed Under: SQL Server Community

TempDB configuration, optimal number of data files to use

January 18, 2009 by John Sansom Leave a Comment

Have you ever wondered what is the optimal configuration for your tempdb database within SQL Server? There is often significant debate surrounding this subject and so Paul S. Randal, discusses using multiple files for a user DB on a multi-core box in an effort to set the record straight. I have been doing some very […]

Filed Under: Administration

Hidden RBAR: Triangular Joins

January 16, 2009 by John Sansom 1 Comment

No matter how good a T-SQL programmer you think you are, it is always good to revisit the basics every once in a while and to ensure that you keep your high quality coding standards in check. One of my favourite series of articles regarding good T-SQL coding practices is by Jeff Moden over at […]

Filed Under: Performance Tuning Tagged With: Query Optimisation

Performance Dashboard Report – Datatype Overflow Error

January 14, 2009 by John Sansom Leave a Comment

When you try to execute the Performance Dashboard Reports for the first time, you may be presented with an error of the form: “the difference of two datetime columns caused overflow at runtime” This is because the DATEDIFF function returns an int value and once you have a connection that is more than 24 days […]

Filed Under: Reporting Services, SQL Server Tips

What makes an exceptional DBA?

January 13, 2009 by John Sansom Leave a Comment

When attempting to define what makes a good Database Administrator, understandably the focus is often placed on the technical skills that are deemed to be required. There are plenty of great resources available on the net that can be used to research this aspect. For instance, Brent Ozar has some excellent material on his site. […]

Filed Under: Professional Development Tagged With: Database Administrator

Being Organised

January 13, 2009 by John Sansom

An essential skill trait for a good DBA in my view is being organised. With the responsibility of administering and managing vast numbers of servers/jobs/processes simultaneously across the globe, it goes without saying that being organised can come in handy. What with so much going on at any given time, it can be tricky to […]

Filed Under: Tools

  • « Previous Page
  • 1
  • …
  • 19
  • 20
  • 21

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
  • Script SQL Server Agent Jobs Using PowerShell
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • 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 © 2022 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy