Changing Service Account & Service Account Password

I recently botched an answer about why one should use SQL Configuration Manager (SQLCM) over Service Control Manager (SCM) to change service accounts and/or service account passwords for SQL Server. Let me attempt to redeem myself. If your running SQL Server 2008 or later and your running on Windows Vista or later (Win7 or Win2K8)…

2

SQL Server Express: Dev or Prod?

Most people I’ve spoken to have at least heard of the Express edition. The next question I ask is where they’re running it: development or production? The answer is usually both. But when I drill into the production use it turns out that most of the time Express is running in production because of a…

1

Zero Tolerance for Ignorance, Laziness and Unprofessionalism

How many databases in the world do you think are storing your personal information? Tens? Hundreds? Thousands? I have no clue what the answer is but my guess is it’s closer to thousands than tens. Why is this an interesting question? In my line of work I speak with lots of DBAs and I’m absolutely…

2

Vendor Lock In or Ignorant Design?

I often hear people say ‘”I’m not going to use Microsoft stuff because the don’t want to become victim of vendor lock in.” They often chose “open source” alternatives for pieces of the stack (web server and database to name a few). This isn’t necessarily a bad thing so long as they’ve done their homework,…

3