We have one here: http://www.sqlservercentral.com/articles/Administration/2960/

SQL Server releases a Cumulative Update every other month and we usually announce it here when they do. Service Packs are supposed to come one a...

Which events are you capturing? There are lots of events, down to the statement level, that you can capture. You can modify any trace to include the events.

Profiler allows you...

either of those tools can help.

One other thing to be aware of is documentation. You may not deploy all changes, so even with a third party tool, you want to...

Call Microsoft PSS and your hardware vendor. Almost all DBCC errors are hardware related and if you really need this data, work with Microsoft support to get it back.

Yikes, didn't mean to start a political debate here.

The power to seize things and protect a country's borders isn't a problem. Every country has the right to do so. My...

Charles,

The editorial wasn't meant to be offensive, and wasn't aimed any particular individual.

However if you can say that you've never worked with developers that don't want to make efforts to...

http://www.microsoft.com/learning/mcp/mcdba/mcdba.mspx

I'm on the first page of "Steve Jones" on Google. Not sure if that's good or bad.

I've never heard of this. If it's when you select the Detach menu item, I suspect that you have a corrupt installation of SSMS

School's certainly not free, though it is cheap in the US. More and more expenses are covered by parents all the time, as school systems provide less and less.

Not sure...

The scoring works correctly, however we sometimes go back and regrade questions if we determine that the question was badly worded or the wrong answers were marked correct.

You can get some statistical data from sp_who2, which can point you in the direction, but short, resource intensive queries can up the counters there, so you have to know...

If it reports no transactions, you have no open transactions in that database.

SQL Server doesn't care about insertion order. As an RDBMS, it does not order rows.

You insert the rows as you find them and then when you retrieve them, you add...

You use the client to move these. VSS doesn't talk to the SQL Server. Visual Studio has some provisions for checking things in and out of VSS and deploying against...