sql server

As these things happen, I've gotten another technical article published over at SQLServerCentral.com. It's called The ABCs of Database Creation and is a free read (though it does require a...

When I come into work, I double-check all my SQL databases and jobs, fix any failures, then catch up on emails and respond to my customers. After all this, I...

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...

I haven’t posted a SQL Saturday post in a while because I’ve had a lot going on, not the least of which is working extra weekend hours. Also, Steve Jones...

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...