You are able to create custom data flow transformations in SSIS using any .Net language. MS has published the necessary documentation on the MSDN website, there is sample code...

Here is a definition of AD:

http://en.wikipedia.org/wiki/Active_Directory

As far as setting up an AD network on a test server (or group of test servers), configuring a domain controller and setting up a...

Is this for some kind of testing system, or is this for some kind of security purposes in a production database?

I assume you Right-clicked on a database in Management studio and chose the "Delete" option in the menu.

This DROPS a database - which is a single action on the entire...

If everything is being run as procedures or views, that will work, but you may benefit from just running profiler to see what people are actually running.

The obvious option is to use the SORT component after the UNION ALL.

If you only have two inputs, you could use a UNION component rather than a UNION ALL -...

There is nothing glaring, but without seeing the data and the queries being run against the table, there is little that can be done.

I find it interesting that the "Bulksort_IDX"...

It would be good practice to use the return value for errors and output parameters for returning information successfully.

MS standard is to return 0 for success and anything else is...

No, you do not need to be a domain admin.

For dates and times, it is usually best to create two dimensions:

Dates - just dates, not times

Time - I usually create one record per minute of the day

There are some...

"Snapshot Replication" makes a copy of the entire database on a scheduled basis. This may be an option if you are trying to make a second database just for...

Create default values that will work the same way blank does now or allow null.

Right-click on the Job Agent in the treeview in Management Studio and bring up it's properties.

Go to the History section and make sure your job history is not being cleared...

If you have configured defaults for all parameters, the report will execute when it first opens.

You already have a date dimension.

So, your time dimension needs to only have hours and minutes - don't include date information. This makes the time dimension finite.

You have 24...