Get well soon, Ken. We're all thinking about you, and looking forward to seeing you again!

Allen

In one of my last client engagements before I left consulting a client had a daily "sales" report that drove much of the business. (The business was a credit card...

Thanks to everyone for this award, it was completely unexpected, and I'm glad people have found value in what I've shared.

Allen

Wouldn't you have the same problem in Transact-SQL, though?

PowerShell is really a more efficient way to work with XML. Transact-SQL has never really been good at handling string data of any sort, and while XQuery is significantly better...

Bruce's suggestion is good, but even better is to set the timeout to 0, so it doesn't matter how long it runs, the script will wait for it.

Allen

OK, while I don't use the redgate restore tool, the ExecuteNonQuery method is an ADO.Net method to send a query to SQL Server. The next thing I'd do is run...

I'd modify your script to write out the query you're sending to SQL Server to the console, then run that query in a query window in SSMS to see what...

Steve, thanks for putting this together. It was more fun than I expected!

Allen

OK, I'm in. (But I better get my BUCKEYES!) 😉

The target expression defines what the policy will be evaluating (internally referred to as the Object Set). Normally you define the target when you create the policy, but this parameter...

Congratulations, Steve. (And to Brian and Andy, too!) I joined this site back in 2001 (I believe) and it led me to PASS, where I met incredible people who...

Sorry about the confusion, folks. PASS is still setting things up. I posted the site link as soon as it was available. I'll let you know as soon as...

People choose to be ignorant of the progress of tools, I guess, but removing PowerShell is akin to removing cmd.exe. It's now a part of the operating system, and...

Wow, Steve. When you load a previous version's database into SQL Server the restore process modifies all the internal metadata to conform with the new version's requirements. Backups...