For me, the main changes in SQL 2008 clustering compared to SQL 2005 are:

1) Explicit install options for creating the first node and adding additional nodes. This stops potentially...

Unfortunately most of the information in this link is wrong applies to Windows 2008 but not to SQL 2008. The multi-subnet clustering and support for OR dependencies never made...

I would always want to tackle this by building a new cluster on new hardware. This allows me to separate the build and test of the new system from...

If SQL 2008 and above, the FTS catalogs are part of the database.

If you want to store the tables with FTS indexes and the associated FTS catalog of a separate...

I echo Phil's suggestion of RS Scripter. It is probably the best free tool for the job you want.

It looks like you are over-committing memory. Wit ha 64-bit machine ther is no performance advantage in trying to use more memory than exists on the box. Although...

As other people have said, you need to start with the RTO and RPO for your applications. If you do not understand the importance of these terms then read...

You can definitely install SQL Server while your server is in Workgroup mode and then make the necessary changes after it is put into Domain mode. You can also...

There are a number of ways to hide a parameter in SSRS, and the right method for you depends on what you want to do. Have you tried Googling...

Developer Edition includes all the features of Enterprise Edition, but is not licensed for use on a Production service. If it is all that you can afford then it...

If you are using Agile as your development methodology, then best practice is to include all the skills you need for a sprint in a single team. If you...

I do not understand what you want to achieve. Please can you give more details about what you want to do, including an example.

I got a task to do.I need to insert/update/delete 400,000 new rows into Adventure Works DB table inorder to test how Proactive caching works in different scenarios.

Need to show POC(Proof...

Remember, the only point of taking a backup is so you can do a restore. If you cannot do a restore, all the backups you have are useless.

If you are putting your own money into training, a TechNet subscription is a good use for some of that cash.

TechNet gives you all Microsoft operating systems and Server software,...