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

Database Schema Help

I’m testing out some new stuff and I need your help.Do you have a schema that has a bunch of complex dependencies between objects such that it’s a real pain when you need to alter it – you have to figure out the dependencies, unhook them, make your change, and then wire everything back together?…

2

SQL PASS Summit Focus Groups

This year during the PASS Summit we (Microsoft) will be conducting a bunch of focus groups. This is a great opportunity to meet face-to-face with folks from the SQL Server team and impart your knowledge on them. You can find a list of Focus Groups here along with a description of each and instructions for…

0

Project “Houston” Grows up to become Database manager for SQL Azure

I’ve blogged before on Project “Houston” (here and here). at PDC this past week we announced that as part of the Developer Portal refresh Project “Houston” will be known as “Database manager for SQL Azure”. Database manager is a Silverlight client (running in the browser) for schema design and editing, entering data in to tables,…

0

SQL Server MVPs–Thank you for what you do!

I follow the blog and/or Twitter of many of the SQL Server MVPs and to be blunt this is a truly amazing group of professionals. Their passion for SQL Server is undeniable. Their desire to expand their already deep knowledge of the product is unsurpassed. And their unselfish generosity to share their knowledge with others…

5

Central Management Servers => Shared Connection Favorites

Back in SQL Server 2008 my team implemented the Central Management Server (CMS) feature. If you work as part of a DBA team and you haven’t tried it out I encourage you to do so. It’s available on all editions, even Express. In short, the CMS allows you to share entries in registered servers with…

3

Moving Databases Between SQL Azure Servers

This week I had to move a couple of databases between two SQL Azure accounts. I needed to decommission one account and thus get the important stuff out before nuking it. My goal was straight forward: move two databases from one SQL Azure server (and account) to another SQL Azure server (and account). The applications…

5