• 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

How Does Disabling an Index Affect the Index Usage DMV Counters

May 28, 2014 by John Sansom 6 Comments

IndexLetters

A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)? Great question! Not one that is straightforward to answer via the Twitter medium though, so I wanted to share some more detail here. Consider that the action of disabling a SQL Server Index […]

Filed Under: Administration, DMVs, SQLServerCentral Syndication, SQLServerPedia Syndication

Yes! You Can be a DBA Too

March 4, 2014 by John Sansom 1 Comment

Start Engine Button

I received an email from a reader the other day, asking for a spot of advice. You know, that highly sought after and dangerous free stuff. Our SQL community chum posed some rather splendid questions, some of which you have likely pondered too. Since a chap only has so many keystrokes in life, I’m sharing my thoughts […]

Filed Under: Professional Development, SQLServerPedia Syndication

(SFTW) SQL Server Links 28/02/14

February 28, 2014 by John Sansom Leave a Comment

Smart Coffee

Good reads from around the Web. It’s the final day of February today meaning that 2 whole months of 2014 are already behind us. How about those New Year resolutions and goals then folks, still going strong? I’m delighted to report that the gym is no longer as busy as it was a month ago […]

Filed Under: Link Posts, SQLServerPedia Syndication

Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

February 19, 2014 by John Sansom 16 Comments

Connectivity

I encountered an interesting question over on the MSDN forums concerning a poster that was reporting experiencing an issue whereby the “sa” account kept being locked out. In scenarios such as this the SQL Server Error Log is your friend, as it can be configured to record failed login attempts for an instance. Of course […]

Filed Under: Administration, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: connectivity, DMV, DMV Queries

Winner – Conference Pass to #SQLServerLive in Las Vegas

February 12, 2014 by John Sansom Leave a Comment

This is a quick post to announce the winner of my blog giveaway for a free conference pass to SQL Server Live! in Las Vegas. Those rather nice folks at SQL Server Live are also offering SQL Brit readers (that’s you lot) an exclusive discount of $500 for their upcoming event in Las Vegas in March. All you have to do to take advantage […]

Filed Under: SQL Server Community, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Competition

(SFTW) SQL Server Links 07/02/14

February 7, 2014 by John Sansom Leave a Comment

Smart Coffee

Good reads from around the Web. It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week. This week I’ve been playing (read as, pulling my hair out) with Extended Events. Without a doubt a powerful feature but it is a bit of a hard graft to work with in SQL Server 2008, […]

Filed Under: Link Posts, SQLServerPedia Syndication

(SFTW) SQL Server Links 17/01/14

January 17, 2014 by John Sansom 2 Comments

Smart Coffee

Good reads from around the Web.  It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week. Those rather nice chaps over on the Toad World Community have only gone and made yours truly their SQL Pro of the Month. Far too generous an accolade. Here’s your weekly roundup of SQL Server Blog […]

Filed Under: Link Posts, SQLServerPedia Syndication

PowerShell – Change SQL Server Login Password

January 14, 2014 by John Sansom 12 Comments

Powershell

Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server Login. Regular readers know that I practice the philosophy of Automate Everything and DBA administrative tasks are no exception. I don’t want to be doing the same task by hand twice, if I can help […]

Filed Under: Administration, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Powershell

What’s the Best Path to Becoming a DBA?

January 7, 2014 by John Sansom 9 Comments

Best-Direction-For-A-New-DBA

I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. I only have a finite number of keystrokes left in me after all, so I’m blogging my thoughts and replying to the comment with a link to this post. Hi John, […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication

DBA JumpStart – A SQL Community Ebook for DBAs

December 10, 2013 by John Sansom 8 Comments

DBA JumpStart Ebook

If you could give a DBA just one piece of advice, what would it be? I asked 20 successful and experienced SQL Server professionals this exact question. You can find their answers inside DBA JumpStart, a unique collection of inspiring content just for SQL Server DBAs. Just Another Blog Post It’s hard to believe that […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: ebook

Winner – Conference Pass to SQL Server Live! in Orlando

October 30, 2013 by John Sansom Leave a Comment

SQL Server Live Orlando

This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando. Those rather nice folks at SQL Server Live are also offering SQL Brit readers (that’s you lot) an exclusive discount of $500 for their upcoming event in Orlando this November. All you have to do to take advantage of this offer […]

Filed Under: Link Posts, SQL Server Community, SQLServerCentral Syndication, SQLServerPedia Syndication

Win a Free Conference Pass to SQL Server Live! in Orlando

October 21, 2013 by John Sansom 2 Comments

SQL Server Live Orlando

Taking responsibility for your own Professional Development and making it a priority is essential to being a successful Data Professional. Courtesy SQL Server Live! I’ve got an outstanding opportunity for you to do exactly that. Together we’re giving you the chance to Win a FREE conference pass to SQL Server Live! in Orlando. SQL Server Live! […]

Filed Under: SQL Server Community, SQLServerCentral Syndication, SQLServerPedia Syndication

What’s the Age Limit for Becoming a DBA?

October 1, 2013 by John Sansom 52 Comments

Sunset on the Bosphorus

I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. Since I only have so many keystrokes left in my life, I am blogging my thoughts and emailing a link. Dear Sir, I am 37 years old. I’ve never worked in […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Featured

10 Habits of Successful Senior DBAs You Can Use Today

August 27, 2013 by John Sansom 17 Comments

Senior Database Administrators (DBAs) through experience develop and practice a variety of habits that become key contributors to their success. Here are 10 habits of successful DBAs that you can begin to put to work for you right away. Habit #1: Use Free SQL Server Tools What if I told you that you can get […]

Filed Under: Professional Development, SQLServerPedia Syndication Tagged With: Featured

Something for the Weekend – SQL Server Links 09/08/13

August 9, 2013 by John Sansom 4 Comments

Microsoft Certified Master: Microsoft SQL Server 2008

It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week! Some of you may have noticed that I’ve been a tad quieter in the SQL community of late. No not because I’ve been slacking off dear reader but because I needed to focus my efforts in on a single goal in order […]

Filed Under: Link Posts, SQLServerCentral Syndication, SQLServerPedia Syndication

SQL Server Crossword #5

August 6, 2013 by John Sansom 1 Comment

Test your SQL Server knowledge in a fun and unique way with this exclusive crossword.

Filed Under: SQL Server Community, SQLServerCentral Syndication, SQLServerPedia Syndication

The Secret to Keeping Your Cool Like an Experienced Production DBA

June 25, 2013 by John Sansom 2 Comments

Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.

In this post I share with you what I have learned about keeping your cool in a crisis and what I believe is the most vital component to effective incident response.

Filed Under: Administration, SQLServerCentral Syndication, SQLServerPedia Syndication

The World’s Leaking Data

May 29, 2013 by John Sansom 2 Comments

I’m becoming increasingly concerned that security has fallen from the forefront of peoples minds. Data Professionals just don’t seem to be giving security the attention that it deserves. The threat to you, your company and your customers is very real.

Filed Under: Administration, SQLServerPedia Syndication Tagged With: Data Loss, Security

Your Community, Your Voice, Your Forum

May 21, 2013 by John Sansom 2 Comments

Lion Roaring

For me, one of the most rewarding things about blogging are the conversations we have together. The opportunity to connect, share and grow with passionate people from all over the world is a great privilege. I’ve met so many wonderful people through our community, learning something from each of you about technology and even life.

That’s why I started the SQL Brit Community Forum.

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication

SQL Server Management Data Warehouse (MDW) – Why it Rocks

April 16, 2013 by John Sansom 17 Comments

MDW Dashboard Report

Ensuring excellent performance for users and customers is a high priority for Database Administrators.

Here I share a free and easy way for you to get valuable insight into the performance of your Microsoft SQL Server instances.

Filed Under: Administration, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Management Data Warehouse

  • 1
  • 2
  • 3
  • …
  • 6
  • 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