Hi Dan,

I think that although log-shipping isn't available in SQL Express per se, you could set this up manually yourself.

You will just need a scheduled job to regularly perform...

Hi giulianocardoso,

I think that SSRS 2000,2005 and 2008 reports all use different versions of the Report Definition Language.

Whilst Visual Studio 2008 \ BIDS 2008 will happily upgrade reports written in...

I think that Trace flag 1807 is the creature that will inhibit the usual criteria that SQL Server applies to storage locations.

Very bad idea though, as the esteemed posters above...

I think that historically, certainly some of the earlier clustering solutions required identical hardware on each node of a cluster.

When using the old Vinca Standby Server product for example, identical...

Hi, glad that was useful.

Not sure that there is any documentation for the reports per se, although someone else may be better at Googling than I.

Here though is a link...

@like2innovate: Just send you a private message since I'm in danger of going off topic in this thread.

@like2innovate: Thanks for the reply, glad you like the book. Yes it is surprisingly easy to read especially considering the nature of the subject.

I must admit I'm slightly biased since...

To learn about relational databases I think you could do a lot worse than to read this book:-

http://www.amazon.co.uk/Inside-Relational-Databases-Examples-Access/dp/1846283949/ref=sr_1_fkmr0_1?ie=UTF8&qid=1265794460&sr=8-1-fkmr0

Don't let the "with examples in Access" in the title put...

Been using Idera SQL DM for a long time now and I'm pretty happy with it.

The "History Browser" feature (available from version 5.5 onwards) is really useful for answering those...

Andrew Gothard-467944 (10/1/2009)

SQL Logins. Plural? Thought most TPA's just...

Yes that is...

SQL Server authentication has one huge advantage over AD authentication as far as I am concerned.

If your AD is administered by a separate group of folks (as you find in...

So what will be your planned carve up?

If you have 8GB to play with how about starting off with 3GB for each instance and then 2GB for the OS?

Yup appreciate that, but thought it important to establish which is the case.

I get my head around clustered vs. non-clustered indexes by thinking of a clustered index as being like a phone book.

In a phone book data is sorted in the order...