Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

John Sansom - SQL Server DBA in the UK

John Sansom (Blog | Twitter) is a Microsoft Certified Master (MCM) of SQL Server and publisher of the free SQL community ebook DBA JumpStart, an inspiring collection of advice for Data Professionals, written by 20 SQL Server experts. Awarded the Microsoft Community Contributor(MCC) award, John is a prolific blogger and can be found regularly writing about SQL Server and Professional Development over at www.johnsansom.com.

Multitasking A Ridiculous Workload – How I Do It

I don’t! There’s no such thing as multitasking. At least, not how most of us think about it……

Being successful as a Data Professional is hard. When you’re good at what you do, you are in demand.

If you’re like most data professionals then there’s always something else that needs… Read more

4 comments, 590 reads

Posted in John Sansom - SQL Server DBA in the UK on 19 February 2013

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

It was early one morning and I was working on a production deployment to add a new Subscriber to an existing Publication. A routine task and one that I had performed many times before.

With SSMS open in front of me, I highlighted the relevant portion of my deployment script… Read more

10 comments, 2,745 reads

Posted in John Sansom - SQL Server DBA in the UK on 5 February 2013

Are You A Technical Expert or Manager?

Expert or Manager? Why not both.

Are you a Technical Expert or a Manager? You certainly cannot be both.

At least that’s the consensus that I frequently encounter. A belief that you can only be one or the other but definitely not both.

This is outdated thinking. It sounds to… Read more

0 comments, 604 reads

Posted in John Sansom - SQL Server DBA in the UK on 29 January 2013

How To Win Career Gold

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.

My fellow countrymen from Team GB know all about striving for growth and improvement to achieve outstanding results.… Read more

6 comments, 546 reads

Posted in John Sansom - SQL Server DBA in the UK on 22 January 2013

Top 10 Free SQL Server Tools

What better way to kick off a new year than with a look back at some of the top free SQL Server tools of 2012.

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… Read more

15 comments, 10,037 reads

Posted in John Sansom - SQL Server DBA in the UK on 15 January 2013

Step Up and Take More Ownership

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… Read more

0 comments, 1,004 reads

Posted in John Sansom - SQL Server DBA in the UK on 8 January 2013

Your Top 10 Posts of the Year

Top of the Flops

Short and sweet today, here’s what you enjoyed reading the most this year on the blog. No accounting for taste then.

  1. How To Become a SQL Server DBA
  2. My Guide To Passing Exam 70-432
  3. Top 10 Junior DBA Interview Tips
  4. The Database Administrators Primary Responsibility
  5. Performing…

Read more

0 comments, 592 reads

Posted in John Sansom - SQL Server DBA in the UK on 17 December 2012

The Great DBA Getaway

Free, at last!

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… Read more

1 comments, 705 reads

Posted in John Sansom - SQL Server DBA in the UK on 12 December 2012

A Journey To SQL Authority

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… Read more

15 comments, 664 reads

Posted in John Sansom - SQL Server DBA in the UK on 9 October 2012

Clients Love The Way I Jiggle

It’s one of the most enjoyable things about being a 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 consultants to work on easy problems. They’ve got those covered already. My customers are some of the… Read more

1 comments, 682 reads

Posted in John Sansom - SQL Server DBA in the UK on 18 September 2012

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

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… Read more

0 comments, 904 reads

Posted in John Sansom - SQL Server DBA in the UK on 14 September 2012

How To Simply Say You’re a DBA

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… Read more

14 comments, 705 reads

Posted in John Sansom - SQL Server DBA in the UK on 3 September 2012

The Hollywood DBA

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… Read more

1 comments, 615 reads

Posted in John Sansom - SQL Server DBA in the UK on 18 July 2012

Lunch is for Wimps

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… Read more

2 comments, 755 reads

Posted in John Sansom - SQL Server DBA in the UK on 3 July 2012

Guest Post – 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… Read more

2 comments, 1,115 reads

Posted in John Sansom - SQL Server DBA in the UK on 27 June 2012

Get Your Ass to PASS!

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… Read more

7 comments, 574 reads

Posted in John Sansom - SQL Server DBA in the UK on 20 June 2012

Guest Post – The Last Starfighter

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… Read more

7 comments, 721 reads

Posted in John Sansom - SQL Server DBA in the UK on 13 June 2012

What’s it Like to Be a DBA?

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… Read more

7 comments, 448 reads

Posted in John Sansom - SQL Server DBA in the UK on 10 June 2012

Where Have all the DBAs and DB DEVs Gone?

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… Read more

6 comments, 508 reads

Posted in John Sansom - SQL Server DBA in the UK on 17 April 2012

How To Live Blog an Event

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… Read more

1 comments, 515 reads

Posted in John Sansom - SQL Server DBA in the UK on 11 April 2012

Newer posts

Older posts