I've read a some articles on Table variable vs Temp Table performance and I have found them lacking good explaination. This one left me hanging at the end of the...

Nice artical. I was quite surprised that performance was not addressed.

Also, profiling the people who handed it off to you will give you a good indication of the condition of the database.

I could not resist. Humor is my only remedy for the database nightmare I inherited 5 years ago.

Before doing any of the 9 steps, I would actually consider, as the first step, if you even want to take ownership of the database. Under step 1, The...

Here are some points that are good about cursors or while loops I feel compelled to share. I've been working with SQL Server since 6.0 amongst other ware. I currently...

This is a clever article and discussion and fun to participate and read. The analogy and abstraction hits some marks and stimulates thinking. I'm want to say that nothing...

The chicken approach would not be tolerated where I work.

Wow! "SQL Server is less complex"?

What kind of production environment are you running. A lab?

Just about any working professional that's been able to survive any length of time in our profession does what this article says. Where I work now we perform it as...

This is good stuff. I'm learning. It's got me thinking how an attacker could ompromise our web servers and launch an attack against the SQL Server.

Nice trick.

Can you add some real life examples of where this was implemented? And the details of why it was absolutely necessary? And, were all other alternatives for handling security...

I would love to work for Microsoft's SQL Server development team. I've worked with the product since 6.0. Working for an Application Server Provider that serves over 3000 companies from...

I like this quote "Striving to be a the top of their profession". Its true, because it's impossible to be at the top; you're always striving. And if you did...

Interesting role "DBAA". I've been in the IT profession for years and titles like Adminstrator, Engineer, Architect, Developer at any given time seem to overlap or merge or split depending on where...