SQL Server
-
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…
-
From Warehouse To Lakehouse – ELT/ETL Design Patterns With Azure Data Services
I like a good pattern. I also like a good framework. From a data perspective, nothing lends itself better to having both of these as ETL/ELT. For those not familiar…
-
Data Virtualization With SQL Server 2019 Big Data Clusters
**NOTE** Whilst this post refers to SQL Server 2019 Big Data Clusters, which requires signing up to the private preview, for those who don’t need the HDFS features and just…
-
Migrating Your SQL Server Estate To Azure
Many customers want to move their SQL Server databases into the Azure cloud. Whilst not discussed here, moving to a PaaS (Platform As A Service) database platform provides many benefits…
-
SQL Server Options In Azure
The data platform options in Azure are vast, and they grow and change with each month. Choosing the right database platform for your workloads can be a challenge in itself.…
-
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…
