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 (@SQLBrit) is a Technology Lead with the database team at Expedia, Inc. providing consulting services and support for one of the worlds largest SQL Server environments. Awarded the Microsoft Community Contributor Award (MCC) John can be found regularly blogging about Being a DBA and Professional Development over at www.johnsansom.com.

Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

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

7 comments, 495 reads

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

Winner – Conference Pass to #SQLServerLive in Las Vegas

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

0 comments, 104 reads

Posted in John Sansom - SQL Server DBA in the UK on 12 February 2014

Win a Free Conference Pass to SQL Server Live in Las Vegas

Taking responsibility for your professional development and making it a priority is essential to being a successful Data Professional. It’s why so many of you get involved and share great advice in the Community Forum.

Courtesy of our friends at SQL Server Live! I’ve got a fantastic opportunity for… Read more

1 comments, 149 reads

Posted in John Sansom - SQL Server DBA in the UK on 21 January 2014

PowerShell – Change SQL Server Login Password

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

11 comments, 350 reads

Posted in John Sansom - SQL Server DBA in the UK on 14 January 2014

What’s the Best Path to Becoming a 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… Read more

8 comments, 662 reads

Posted in John Sansom - SQL Server DBA in the UK on 7 January 2014

DBA JumpStart – A SQL Community Ebook for DBAs

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…

Read more

5 comments, 2,383 reads

Posted in John Sansom - SQL Server DBA in the UK on 10 December 2013

Winner – Conference Pass to SQL Server Live! in 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… Read more

0 comments, 127 reads

Posted in John Sansom - SQL Server DBA in the UK on 30 October 2013

Win a Free Conference Pass to SQL Server Live! in 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… Read more

2 comments, 140 reads

Posted in John Sansom - SQL Server DBA in the UK on 21 October 2013

What’s the Age Limit for Becoming a DBA?

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…

Read more

34 comments, 227 reads

Posted in John Sansom - SQL Server DBA in the UK on 1 October 2013

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

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

4 comments, 338 reads

Posted in John Sansom - SQL Server DBA in the UK on 9 August 2013

SQL Server Crossword #5

When there’s something worth celebrating, such as a birthday or achieving the Microsoft Certified Master (MCM) SQL Server certification, I like to mark the occasion here on the blog with a SQL Server Crossword. I know, living it up right!

Same as before, the answers are all SQL Server words… Read more

0 comments, 977 reads

Posted in John Sansom - SQL Server DBA in the UK on 6 August 2013

The Secret to Keeping Your Cool Like an Experienced Production DBA

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

Things can and will go wrong in your environments. Even the greatest software contains bugs and hardware fails, often.

When an unforeseen issue arises your reaction can directly influence… Read more

2 comments, 1,939 reads

Posted in John Sansom - SQL Server DBA in the UK on 25 June 2013

Your Community, Your Voice, Your Forum

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

2 comments, 333 reads

Posted in John Sansom - SQL Server DBA in the UK on 21 May 2013

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

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

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

There are so many features in the SQL Server product that… Read more

8 comments, 667 reads

Posted in John Sansom - SQL Server DBA in the UK on 16 April 2013

Implicit Conversions and Avoiding Them With Computed Columns

I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known technique and I wanted to share it with you here.

A customer environment was suddenly receiving high CPU alarms and I was called in to take a look.

Having… Read more

6 comments, 2,426 reads

Posted in John Sansom - SQL Server DBA in the UK on 25 March 2013

How To Be An Expert At What You Do

Every successful company has them. They’re the lifeblood of their organisations. Linchpins essential to getting things done and doing them extremely well. More commonly we know them as experts.

Experts are always in popular demand and they come in all manner of different flavours.

Of course they are just everyday… Read more

2 comments, 411 reads

Posted in John Sansom - SQL Server DBA in the UK on 20 March 2013

Career Growth and How You Can Achieve Explosive Results

Continued investment in your professional development for career growth is hard. It’s also essential to being a successful Data Professional.

You’ve got a lot of competing priorities, we all do, it goes with the territory of being good at what you do. Managing the demands and responsibilities of your job… Read more

15 comments, 900 reads

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

Something for the Weekend – SQL Server Links 01/03/13

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 Get posts delivered direct to your Inbox free via Email.

I don’t… Read more

4 comments, 504 reads

Posted in John Sansom - SQL Server DBA in the UK on 1 March 2013

Restart the SQL Server Agent Service using PowerShell

Just a quick one today chaps, to show how you can restart the SQL Server Agent Service using PowerShell.

Whilst covering the Production Ops Shift in our shop over the weekend I discovered that Database Mail had not been configured for the SQL Server Agent on a number of servers.… Read more

3 comments, 901 reads

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

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, 497 reads

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

Older posts