Shortly. That's all that can be...

I don't get many emails. I may have had four in...

MCP is an older designation and was what you got after writing and passing any one exam. MCP = Microsoft Certified Professional

MCITP is a newer designation and is the 2nd...

If you're considering exams as a verification of what you've learn more than anything, then look at the ITP (Database Developer) cert. Two exams. They are not easy

SQL injection isn't actually a SQL Server vulnerability. Somewhere you have an application, most likely a web application that is using ad-hoc SQL statements to communicate with the database.

The...

Why do you want to? What is it that you are trying to do?

Visual Studio Team System Database Edition (aka Data Dude) contains a random data generator.

Very strange. As a suggestion, download one of the evaluation versions of SQL Server, install the client tools somewhere and use profiler to watch what's happening to the DB.

What's...

Without seeing any more info on this, it's hard to make a blanket statement. Generally what I would do is index for the most frequent queries. If you don't know...

Depends on the mail. Mostly on what its asking and the way its been asked.

If the mail is rude or demanding or written in half-legible english it will get...

I haven't gone over the code in detail, but one thing jumps out. This is only going to work properly when a single row is updated.

set @CHA_OID = (select APV_APT_OID...

RC1...

There are a number of us on LinkedIn. There's even a SSC group there.

Personally I prefer to keep connections and especially recommendations to friends or people that I have worked...

http://summit2008.sqlpass.org/

When using dynamic SQL, the user needs permission on the base tables. The dynamic SQL breaks the ownership chains.

You may be able to remove the dynamic SQL. I don't know...