Subscribe to this blog
John Sansom - SQL Server DBA in the UK
Archives: February 2013
Restart the SQL Server Agent Service using PowerShell
Powershell Magic
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… Read more
3 comments, 406 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
2 comments, 341 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
9 comments, 2,277 reads
Posted in John Sansom - SQL Server DBA in the UK on 5 February 2013