I'll look and see, but it's a good idea.

Keep in mind that most threads die in a few days, so you won't get a lot of emails over time from...

I'm nervous about having anything on my SQL Servers that might be"touching" the database files. I think it's a gamble that something in Diskkeeper or any similar product, including anti-virus,...

It doesn't sound like there is anything you are doing that's strange. Almost everyone connects to a central SQL Server database in some way with their application.

If you're unsure, it...

I'd only run this on particular objects if things were out of whack and I had very bad query plans, or if my distribution of data changed substantially.

Walk through some logic. How do you figure out what the last Sunday is? (besides looking at the calendar).

There's a skill you need to build here to examine what determines...

Nope. Nothing like this in SQL Server.

There is a power button, however. 😉

You'd have to convert things to numerics,stripping out the hyphens,for sorting purposes. Don't change the data, but extract the numbers (using CAST(SUBSTRING(CHARINDEX())) functions to get this.

It's somewhat legacy, and it's good practice since in a DR situation, you need the CREATE. If you redeploy permissions, you're ok. If not, this is bad and you need...

Code has been added to the article.

The NEWID() and RAND() will get you random, or psuedo-random, numbers. You can use that to generate random characters (combine or convert as aSCII values) or dates (add to some...

datepart will get you sundays, check BOL for the parameters.

The idea is that you want to develop an algorithm that can determine what the last Sunday is by examining various...

What is the "identity" password? sp_password, run against the virtual server, will change the password for the login.

There are many things that can happen. The best thing you can do is run a test on a test system, upgrade things, and then if you have specific errors,...

There is a compatibility mode you can set on the databases as well to have them run as SQL65 for keywords and functions.

I'm not sure what a new technology is anymore. SQL 2008 got to RC0 and it includes Powershell for SQL, which is new. I played with Hyper-V, and it's straigtforward,...