• 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

Script SQL Server Agent Jobs Using PowerShell

February 12, 2013 by John Sansom 46 Comments

Powershell

Here’s a handy PowerShell script to script-out all SQL Server Agent jobs for a given instance.

Filed Under: Administration, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Automation, Powershell, SQL Server Agent

Overconfidence – How it Almost Cost Me and What You Can Do to Avoid It

February 5, 2013 by John Sansom 10 Comments

Overconfidence can have serious consequences for Data Professionals. Guard against overconfidence and avoid complacency by thinking defensively.

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Complacency, Overconfidence, Replication, Thinking Defensively

Are You A Technical Expert or Manager?

January 29, 2013 by John Sansom Leave a Comment

The Thinker

Effective leadership is about being mindful of how you engage those around you.

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication

How To Win Career Gold

January 22, 2013 by John Sansom 6 Comments

Team GB medal winners

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.

The value of investing in your own professional development is clear. I encourage you to take the time to devise your plan and you will achieve fantastic results.

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Career Progression, Community, Goals, Mentoring, Reading, Training

Step Up and Take More Ownership

January 8, 2013 by John Sansom Leave a Comment

TSQL Tuesday Logo

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 you that I’m resolute in my philosophy that the Best DBAs Automate Everything. So […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Leadership, Replication, Responsibility

Your Top 10 Posts of the Year

December 17, 2012 by John Sansom Leave a Comment

Stacked records

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 Primary Responsibility Performing Fast SQL Server Delete Operations 10 Character Traits of […]

Filed Under: Blogging, Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication

The Great DBA Getaway

December 12, 2012 by John Sansom 1 Comment

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 droves. Leaving their troubles and work behind them, most likely for you to […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Planning, Time Management, Work-life-balance

A Journey To SQL Authority

October 9, 2012 by John Sansom 60 Comments

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 follow. A SQL community champion, this […]

Filed Under: Blogging, Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Becoming a DBA, Guest Post

Customers Love The Way I Jiggle – SQL Server Consulting

September 18, 2012 by John Sansom 1 Comment

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 work on easy problems. They’ve got those covered already. My customers are some of the smartest […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Consulting, Problem Solving

Something for the Weekend – SQL Server Links 14/09/12

September 14, 2012 by John Sansom Leave a Comment

It’s SFTW Time, I hope you’ve had a great week! Make sure you don’t miss this weekly round-up of SQL Server Links, community news and technology banter by Subscribing to the Blog Feed.  You can also receive posts via Email. I don’t typically syndicate ( that’s share using RSS technology to you non bloggers) the weekly round-up to SQL Server Central but today […]

Filed Under: Link Posts, SQLServerCentral Syndication, SQLServerPedia Syndication

How To Simply Say You’re a DBA

September 3, 2012 by John Sansom 14 Comments

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 last week my girlfriend and I were out to dinner to […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Career, Database Administrator, Job Description

The Hollywood DBA

July 18, 2012 by John Sansom 2 Comments

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 SQL community, he is  the founder and leader of the PASS SQL […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Becoming a DBA, Guest Post

Lunch is for Wimps

July 3, 2012 by John Sansom 3 Comments

DBAs on Wall Street

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 much so that I wanted to share it with you […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Becoming a DBA, Guest Post

Guest Post – DBAvolution

June 27, 2012 by mfal 2 Comments

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 regularly on his blog but who also encourages us to get the grey matter really […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Becoming a DBA, Guest Post

Get Your Ass to PASS!

June 20, 2012 by John Sansom 7 Comments

This year there are to be no excuses, and I mean it. You know what I’m talking about. There’s always some reason why you can’t go to the PASS Summit, why you can’t make it this time around. Maybe the timing is just not quite right, you can’t get the time off work, maybe there’s […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Career, Community, Events, SQLPass

Guest Post – The Last Starfighter

June 13, 2012 by John Sansom 7 Comments

Today I am delighted to be able to share with you a guest post from one of my all time favourite bloggers in the SQL community. Their high quality, unique and creative content regularly making the cut for a place in the SFTW post roundup. I’ve been an avid reader of theirs for a number […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Becoming a DBA, Guest Post

What’s it Like to Be a DBA?

June 10, 2012 by John Sansom 7 Comments

Absolutely fantastic of course! You regular readers know that the Becoming a DBA area of the blog is one of the most visited and talked about, with the professional development posts often proving popular. All the comments, questions and emails you guys send tells me that there’s a lot of interest in the community about […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Database Administrator, Guest Post

Where Have all the DBAs and DB DEVs Gone?

April 17, 2012 by John Sansom 6 Comments

Last week the SQL community and in particular the blogosphere, was buzzing with interest noise following the Microsoft Learning site publishing details of significant changes to SQL Server Certifications. Here We Go Again You know the drill. It’s the usual dance we go through every 5 years or so, where the Microsoft marketing machine spins […]

Filed Under: Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: Career, Database Administrator, Database Developer

How To Live Blog an Event

April 11, 2012 by John Sansom 1 Comment

As the euphoria of SQLBits X sadly begins to fade, I wanted to take a moment to share with you my experience of Live Blogging the keynote of Europe’s largest SQL Server conference. To be honest this was not something that I had planned to do but when I received an email from Chris Webb […]

Filed Under: Blogging, Professional Development, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: SQLBits

Liveblog for #SQLBits X Day 1 Keynote

March 30, 2012 by John Sansom 2 Comments

Packed out at SQLBits X

Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London. There’s no need to refresh your browser folks, we’re technology savy here at SQLBrit don’t you know and using a LAMP stack ;-) Send your Tweets to @SQLBrit and keep an eye on the #SQLBits hash tag. The best Tweets at […]

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

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