Sorry I may not have been clear in my last post.

Use the VPC image to practice disaster recovery scenarios.

Set up some replication scenarios.

Setup some linked severs

Practice What-ifs

Cheers

1. Install SQL Server on a Virtual PC.

2. Backup you VPC image.

3. Learn SQL Server

4. Deliberately blow up you VPC image and then try to recover it.

If you can't recover,...

Create Table #Temp

(

NewID int identity(1,1),

<various fields from other table>

);

Insert into #Temp

Select * from <other table>

delete from <other table>;

insert into <other table>

select coalesce(RecordID, newID) As ID, <other fields>

from #Temp;

drop...

Try aggregating the result set

Select field1, field2, count(field)

from

table

where some condition = whatever

group by field1, field2

If God had meant us to play soccer, he wouldn't have given us arms. 😛

SQLExcel is quite good. It's free.

It allows you to create queries similar to MS Access query builder, and you can save the queries in a network location for other people...

Check the following -

triggers

jobs that run stored procedures

VB code that "cleans up" data

Transactions that rollback.

Isolate when the data is changed.

To do this:

Run a trace while...

Alcohol - its not just for helping ugly people get laid.

Buy him a beer and ask him a few questions regarding major issues. Don't exactly suck up to the guy,...

Nice work!!!

I have been using this tool, xSQL Script Executor. It's freeware - so the price is right.

It allows you to batch your scripts together in projects and target multiple...

Hi,

You can create a before and after dump of the objects in the dat base and compare what has changed.

See below.

or SQLDiff does the job pretty well but I am...

Hi,

You can write code in C# or VB.Net to view retrieve data from AD via a web service.

Connect to the web service as the report datasource

Jamie