I'll typically place a few unit test examples in the comment block of each stored procedure I write. Sometimes I'll use SQLProfiler to cature sample procedure calls while the QA...

If linked server doesnt work, then try pass through batch via EXEC() AT <SERVER>.

A large scale website is like an interstate highway, especially when it's being construted at tax payer expense. Cool features are nice to have (just like rest stops and trees...

Ask 100 people how they would envision a "perfect" solution, and you'll get 100 different answers, only 10 of which are even remotely feasible. Implementing and deploying IT projects is...

tdietrich (11/4/2013)

---

At our company, we have thousands of SQL instances (with more databases than I can think about without some Advil). We have some core/centralized DBA groups, but...

I believe that the client or customer should own their data and the basic means to access the data. They should have a sysadmin account. If your application has some...

I occasionally read posts where someone critiques T-SQL's "limitations" on the basis that: it doesn't support input dialogs, doesn't support ORM, or why doesn't it have better syntax for processing...

This article was published back in 2009, and four years down the road, and SQL Server is still going strong. The arguments sound similar to what some folks were saying...

Miles Neale (10/25/2013)

---

Eric M Russell (10/25/2013)

---

Excellent article. It's funny ... You can blow through thousands of dollars worth of billable time and broken service level agreements just discussing the issue...

Excellent article. It's funny (in a bad way) that many people say "disk is cheap" until the day that tempdb or transaction log starts filling up and you actually put...

Even if automation pushes an IT professional out of one job, it will open the door for another job, wether within the same organization or another. I'm sure there are...

David.Poole (10/15/2013)

---

Lets suppose you are launching a new line of business. It's a bit of a punt. You hope it will be wildly successful but equally it might...

Today, in the fall of 2013, how may of us are using SQL Server Azure or EC2 in a production environment?

I don't mean a database feeding your personal blog, but...

I believe unionization makes more sense in an industry where workers tend to be less educated and marginally paid and there can be workplace hazards.

However, most of us...

Andrew-H (10/11/2013)

---

If I don't like my job, I can change employers, there are tons of them.

If we are unionized and I don't like my union, how easy would it...