SQL Clone
SQLServerCentral is supported by Redgate
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.

Archives: February 2014

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

16 comments, 2,312 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, 664 reads

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