• 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

Top 10 Free SQL Server Tools

January 15, 2013 by John Sansom 54 Comments

Top 10 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 common goal of making your life easier.

Filed Under: Tools Tagged With: Featured, Free Tools

Checkout SQLMonitor live in action right now

November 11, 2010 by John Sansom 1 Comment

Did you see the editorial post from SQLServerCentral this morning? It’s very cool and I wanted to bring it to your attention. Those clever chaps have gone and deployed the latest edition of SQLMonitor from RedGate on the SQLServerCentral website and made the dashboards available for you to interact with online, in real time. Take […]

Filed Under: Administration, SQL Server Community, Tools

Superb listing of free SQL Server tools

June 5, 2009 by John Sansom Leave a Comment

Paul Randal pointed me in the direction of an awesome resource list of FREE SQL Server tools. There is an absolute mountain of quality stuff here and I wanted to share it with you all. Free SQL Server Tools that might make your life easier Be sure to me know which resources you use and […]

Filed Under: Tools Tagged With: Free Tools

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

Performance Comparison of (SELECT TOP 1) Verses MAX()

February 26, 2009 by John Sansom 19 Comments

I recently came across a post on Stackoverflow regarding the performance of using a SELECT TOP 1 query in comparison to using the MAX() function. My initial thoughts on this were that the MAX() function would provide the best performance however, in order to be absolutely certain and prove my initial hypothesis I decided to […]

Filed Under: Administration, Index Optimisation, Performance Tuning, Tools Tagged With: MAX()

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

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

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