macro shot of stainless steel padlock

Picking up the pieces after the DBA has left: taking ownership of a SQL Server instance

WARNING: This post contains information that can get you fired if you use it without express written permission. In some jurisdictions it might get you jail time as well. Let’s assume you are a consultant, and a customer has called you in a panic because they have lost access to their production environment. Let’s assume
-> Continue reading Picking up the pieces after the DBA has left: taking ownership of a SQL Server instance

sql2xls goes cross-platform

Last year I released sql2xls, a free open-source tool which lets you throw a bunch of scripts into a folder, run them automatically against SQL Server and get the results back in a nicely-formatted Excel file, one tab per script. A year later, I am happy to announce that the tool now runs cross-platform. You
-> Continue reading sql2xls goes cross-platform

person driving car during night

On the continuity of business

With entire countries shutting their borders, and people being forced to stay home and isolate themselves for as long as possible while health departments ramp up to handle this pandemic, the question of business continuity has been raised. This is where our training as data professionals comes in. The classic DBA must make sure that
-> Continue reading On the continuity of business

Join me in Victoria this Saturday

I will be presenting a new session, “Database administration through the ages,” at SQL Saturday #950 in Victoria this coming weekend. This is one of my favourite SQL Saturdays of the year because I love Vancouver Island (even when it rains, and despite breaking my foot there). In this session I look at what it
-> Continue reading Join me in Victoria this Saturday

turned off vintage black television

Deprecated and discontinued features in SQL Server

My co-authors and I recently wrapped up the book SQL Server 2019 Administration Inside Out, which should be hitting the shelves in the next week or two. At the end of Chapter 1 I have a small note about deprecated and discontinued features, and this post expands on that section. The following statements are true:
-> Continue reading Deprecated and discontinued features in SQL Server

A desktop computer destroyed by fire

Disaster recovery, tools edition

I just completed a chapter for another book where I spoke about the Recovery Point Objective (how much data you are prepared to lose) and Recovery Time Objective (how long you have to bring your environment up again) after a disaster, and while I never get tired of repeating myself, that’s SQL Server. What happens
-> Continue reading Disaster recovery, tools edition

Kubernetes logo

I’m a DBA. Do I really need to know Kubernetes?

Welcome to February 2020. It’s the second month of the year 2020! I remember sitting at a server with SQL Server 6.5 installed on it, worrying about the Y2K bug. It feels like yesterday. While I haven’t been a database administrator for all that time between then and now, I have been exposed to broad
-> Continue reading I’m a DBA. Do I really need to know Kubernetes?

red LED signage

What is a strong password anyway?

Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website¬†Have I Been Pwned (HIBP) for a number of years now. For the record, “pwned” is pronounced like “owned” but with a “p” in front of it. Don’t use the term in public unless you’re in a room full of information security
-> Continue reading What is a strong password anyway?