SQL
-

Transforming T-SQL (or any dialect) to Databricks with AI_QUERY: A Step-by-Step Guide
Hey folks, long time no speak – it’s been a crazy amount of time since my last blog, so it’s great to get back into it again. I won’t update…
-
Getting Started with SQL Operations Studio
I’m a fan of new shiny things, and as a former SQL Server DBA the release of SQL Operations Studio definitely peaked my interest. So, in the words of the…
-
Optimizing SSIS Data Loads with Azure SQL Data Warehouse & PolyBase
To gain the best loading performance with Azure SQL Data Warehouse, you want to leverage the power of PolyBase, which allows for massively parallel data loading into the underlying storage.…
