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,...

Authors work hard on these books. Pirating them or downloading them for free when the author has not agreed is wrong. You want to get paid for your work; pay...

You should read through the physical storage architecture sections or BOL or pick up a copy of Inside SQL Server.

If you have CHAR, then the space is saved in the...

I'd script it out and then save the script. You can easily search and replace the server names or database names if needed to rebuild replication.

At TechEd this morning, they are giving away lots of DVDs with RC0 and the rumors are still a Q3 RTM, so things must be very close. I've seen the...

Most consistency errors are raced back to hardware problems. Potentially fabric or controller errors could be present.

I'd be sure that someone carefully runs diagnostics on your storage.