Shawn Melton

Are you referring to these external tables @ca6dsm ? https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-external-tables#create-an-external-table-on-protected-data ```sql USE [mydbname]; GO CREATE EXTERNAL TABLE populationExternalTable ( [country_code] VARCHAR (5) COLLATE Latin1_General_BIN2, [country_name] VARCHAR (100) COLLATE Latin1_General_BIN2, [year]...

Yeah scripting those tables out from Azure SQL won't run on SQL Server because of syntax. I'm not sure of mix of our other commands could be used for your...

Yes, that is true but getting the definition of an external table will require using lookups and regex to create the same table in SQL Server for Copy command to...

It is the same consideration as the build reference and the data we keep on that, or the wait type information we include in commands (links to SQLSkills site). However,...

Excellent info in this one: https://dba.stackexchange.com/q/141092/507 Check out the links that Paul White shares, that PDF download is stinking awesome.

Only thing in `Compare-Object` is cases with null values it does not handle well from my understanding. So in cases if you are comparing an operator and making sure junior...

I would caution against filtering out explicit file extensions. SQL Server nor Azure have anything to do with those files being named `bak.part` (nothing documented that I could find). SQL...

I like something `Test-DbaRecoveryTimeObjective`...you can alias it as `Test-DbaRto`. I don't see a need to use the code area for creating a job, just let this be done in a...

Why don't you just sync permissions from prod to lower environments?

Being able to deal with filtering based on what was granted I would see being problematic to maintain because those change in both what you assign and syntax by version....