Hi Steve -- thanks so much for the assistance.

You are correct, I could get the version from the master backup, install SQL instances and get them up to the specific...

Can this script be used to copy from a newer version of SQL Server to an older version (assuming there are no newer T-SQL features in the source)? I...

I see I posted this under the wrong forum -- the solution only need apply to SQL Server 2008 R2 or higher.

As for the "why", this is a data collection/troubleshooting...

Nice article.

Isn't sys.dm_exec_query_profiles new in SQL Server 2014? I don't see it mentioned in the article and the spreadsheet indicates "no changes."

http://technet.microsoft.com/en-us/library/dn223301%28v=sql.120%29.aspx

Nice article

I would add that OPENXML is not currently supported in an Azure SQL database, so if you're planning on migrating any time soon you'll want to stick with the...

I agree -- looks like the answers should enable compression and limit the CPU

In its implementation of recursive CTEs, DB2 has a "Search Depth First" option that can be specified to return rows in this "drill down" fashion. I've been looking for...