database administration

In today’s economy, job hunting is difficult at best. Things are so bad that people unable to find employment after a year plus of searching have stopped looking. This behavior,...

It’s early in the morning (or late at night) when Vital Process A fails. Maybe it errors out. Maybe it didn’t start in the first place. Regardless of the reason,...

Occasionally I make little notes, fun SQL facts, for myself about things I recently learned about SQL Server. Here are the most recent, mostly restore related. A stored procedure cannot...

So I’m basking the laurels of solving a performance issue, transforming a 2 day+ ETL process into a 15 minute process, when the next Big Thing comes down the pipes...

Today I want to talk about my job, the day job. As a Jack-of-All-Trades DBA, I am responsible for backups, security, production releases, data fixes, architecture, schema approvals, development (both...

You know you’ve made an impact when people start coming up to you asking where you’ve found your full time writing gigs. It’s been an interesting roller coaster ride for...

To me, my SQL Saturdays posts aren’t just a method of information sharing or a way to teach new SQL Server database administrators. I also use it as a repository...

Today’s SQL Saturdays post discusses a cute little trend we have going on SQLServerCentral.com, SQL Spackle articles. SQL Spackle articles are short and simple articles meant to spackle, or patch,...

Database administrators would be more overworked if it weren’t for the ONE principal that universally governs all database activities (regardless of software brand): ACID. I don’t usually worry about having...

As I prepare to speak at SQL Saturday 197 (Omaha Nebraska), I’m listening to Matthew Brimer speak about Database Security & Shrinking Your Attack Surface. It’s an interesting lecture. But...