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.

Archives: February 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, 902 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

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

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