Excellent points. In fact, VMWare would agree with you (and me too) that not everything should be virtualized. SQL Server implementations tend to be smaller, as a general rule,...

Chris,

I have 3 SMSQL articles at MSSQLTips.com. I talk about backup performance gains, configuration, and implementation best practices. SMSQL has been a challenge and has a high learning...

Brenda,

We've looked into cloning SQL Server VM's and we've done it in limited fashion. Our issue is with the fact we maintain a large number of different possible OS and...

The servers ranged in age and versions. We had some very old system that certainly needed the upgrade but we also had some newly built systems. The conversion were...

This may be caused by a version mismatch between the SQL server and your SQL client. Be sure to upgrade your client on your workstation with the latest SQL service...

The procedures aren't much different in SQL 2008 R2 as they are in other versions. Some basic things to keep in mind (I'm sure others can add to the list):

1....

If you put your code in as a t-sql job step in a scheduled sql job you can have the output written to a log file. This in the Advanced...