Featured Post

The Best Database Administrators Automate Everything
Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once it's gone, that's it, gone forever. As a Database Administrator (DBA) your skills, services, expertise and ultimately your time will always be in demand. You can only ever deliver on a finite amount of time, that's just … [Read More]
Latest Posts

How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)? Great question! Not one that is straightforward to answer via the Twitter … [Read More]

Yes! You Can be a DBA Too
I received an email from a reader the other day, asking for a spot of advice. You know, that highly sought after and dangerous free stuff. Our SQL community chum posed some rather splendid questions, some of which you have likely pondered too. … [Read More]

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 … [Read More]

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 … [Read More]

Top SQL Server Forums of 2014
There's a lot of valuable information on the internet. The astute among you will have also noticed that there's a fair amount of crap out there too. Whether you’re browsing forums, web sites or blogs, knowing what the best sources of SQL Server … [Read More]

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 … [Read More]

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 … [Read More]

The Year in Numbers 2013
All in all it was a successful year here at John Sansom dot Com. In terms of traffic, the blog had almost 400 thousand page views. I know. I don't understand why either - but I'll take it! This years page views were more than half of all the total … [Read More]

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 … [Read More]

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 … [Read More]

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 … [Read More]

10 Habits of Successful Senior DBAs You Can Use Today
Senior Database Administrators (DBAs) through experience develop and practice a variety of habits that become key contributors to their success. Here are 10 habits of successful DBAs that you can begin to put to work for you right away. Habit … [Read More]

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 … [Read More]
- 1
- 2
- 3
- …
- 21
- Next Page »