Thanks for responding so quickly.

I didn't run the restore using TSQL, I'd used the Restore Database GUI / wizard via right-clicking the Databases folder in Object Explorer.

Your...

Hi again!

I've sorted out the original problem by opting for uninstalling "SQL Server (64bit)" instead of SQL Server.
Now I can see the "Select Instance" screen and the...

Hi James,

Just to chime in with how I got started...

I got hold of a SQL Server Developer edition (they're free now) and started playing and practicing...

Thanks both for the suggestions; really helpful.
The server will be a development environment, so I am expecting users to do dumb things that could cause rapid growth to the...

Thanks to you all for the great advice and guidance on this thread from the end of last week.

It's really helpful to have the reasons / rationale to back up...

Grant Fritchey (10/20/2016)

Brandie Tarvin (10/20/2016)

I think you misunderstand what Grant meant by cross-database querying.

If you separate out the data into individual databases, how many queries will have to touch these...

This is solid gold stuff from you both, thanks for helping out so quickly.

How much cross-database querying is there? If little to none, yeah, keep 'em separate. If lots,...

...our workflow goes like this:

Build in Dev

Unit Test in Dev (this is done by the developers)

Add to appropriate folder in TFS (we have monthly releases and each release folder is...

Thanks for the advice and offers of help everyone.

I've been mapping out the current situation, and the next step is to do the same for my proposed solution. My...

Hi Grant,

Thanks for your help and advice here - really appreciated.

That's a great suggestion to use a backup to create the development environment; I wouldn't have thought of that...

Hi,

Thanks everyone for your helpful suggestions. Some cool approaches that I wouldn't have thought of at all.

PB_BI: I ran your code and it works great. I found just 3 reports...