sweet, thanks!

(my quick path to getting new ScriptDom.dll on my mostly locked down work computer is to install, locally, dbatools and "sqlserver" powershell modules.

This one: X\WindowsPowerShell\Modules\SqlServer\21.1.18256\Microsoft.SqlServer.TransactSql.ScriptDom.dll

...has TsqlParser160 in it.

Now if...

well in working with other stuff out there regarding using scriptdom.dll, at the very least, the "lexer" output in ScriptTokenStream gets generated regardless of if the SQL was successfully parsed....

omg. the installer for SSDT2017 sucked at various points! Highly recommended to use the SSDT that matches the newest version of Sql Server you will be deploying objects to, especially...

an aside: Azure Synapse cannot do recursive CTEs (or heirarchyid...), if you happen to be working in that realm.

I settled for a few layers of nested CTEs down to the...

Some things in Azure Synapse don't exist or work the same compared to "regular" TSQL. I usually find at some point I need to find out what distinct objects (tables,...

Speaking of adds, it'd really be nice if they just figure out a decent built-in to expose the .Net regular expression functions.

That'd save convincing the DBAs to turn on SQLCLR,...

There's also the challenges of everyone's cell phone connections, if they're calling into the meeting directly from their phone.

I get to call in daily for a team meeting, and happen...

well, we're at least in our 50s, so...

SQL Server at some point (2012? 2014?) added the datetime2 to be more compatible with Oracle and DB2's date/time data types that can have more scale in the sub-second part...

oh and a shout out to the ReportingServicesTools and dba-tools Powershell modules! if you can't (won't?) do the backup-and-restore method, life is much better with both of those modules.

this worked for me (ssrs 2008 to ssrs 2016). we do not have database encryption turned on. we do not use SharePoint integration either.

tl;Dr summary: backup current ssrs keys. copy...

Hey, Jeff, will you update this yet again to include the new split_string() function in SQL Server 2016+?

excellent! where I work recently migrated to WD. Right now we do our data exchanges via XML files. which is ok but... just today a co-worker asked about budget codes....

CozyRoc may have Workday-specific source and destination component by now.

They certainly have their own web service source and destination connectors (SalesForce, etc), as well as generic ones.

I have used the...

a good first step in my book would be to just build in a dll with a good set of the .Net regular expression engine & functions already.

are there good...