Fix blocking, full logs, tempdb bloat, memory waits, and “what’s running now” in minutes with these five sp_WhoIsActive commands. Use this tool today to solve your own SQL Server issues. Need more help? We can help with our SQL Server Consulting services or our DBA services. 5 Common SQL Server Problems to Fix with sp_WhoIsActive … Read more
A monster’s worse fear is being found. – Richelle Goodrich This is part of the Two Weeks to a healthier SQL Server series. Today we’ll address SQL Server Corruption – or hopefully how to find and deal with it before it finds and deals with you. Data loss and user deletes are expensive and difficult. … Read more
The best EMTs and Medics are the ones who realize, “This isn’t my emergency,” early enough. You’ll be a better DBA or technologist the quicker you learn the freedom that comes from that line of thought. (Also, a warning – in this post, I talk about – in vague terms and no medical specificity about … Read more
So maybe you read the post title, and you already have an idea where this post is going… In the heat of the moment, I didn’t. Long story short – we had a client who was having some ugly excessive autogrowths causing a nasty cycle. Their autogrowth wouldn’t complete within the timeout period for the … Read more
I’m a big fan of bringing ideas and concept in from other industries to the world of technologists, particularly those of us in professions operating in and around data. I’ve written posts before about lessons from aviation, a string of failures at the Secret Service, some corollaries to farming or our gardens at home, some experiences … Read more
Earlier this week I ripped a headline for blog post inspiration. Looks like the week will end that way, too. Before you ask – this isn’t about the PASS organizational struggles – though I think it applies there – and looking inside I think it applies to me there. It also applies to parenting. I’m writing … Read more
Last week a man jumped the fence at the home of the President of the United States. This is a fairly routine occurrence. Except he made it to the door to the “residence” portion of the White House – where the first family lives. And made it through the unlocked front door – where he … Read more