Use azure Synapse Link for Dataverse to export data to Azure synapse analytics.

Here are all the session materials (slide deck and scripts) from my session in SQL Day 2022 about temporary tables and table variables...

1) EXPORT a database from an Azure Managed Instance by creating a .bacpac file using SqlPackage.exe: SqlPackage.exe /Action:Export...

This blog post is part of TSQL Tuesday. This month the host is Kenneth Fisher, and the topic is "Your First Technical Job".

Turns out there's a shortage of solutions online for easily managing partitioned tables in SQL Server. Well... That's where I come in!

(Part 3/3 of “Getting started with Azure Data Factory”) Author: Eric Rouach, DBA at Madeira Data Solutions Date: April 2022 In this demo,...

I published a very simple script to query for all the objects referenced by a specific object in the local database (e.g. a view)...

So you have an old SQL Server. It's time to make a change, but where do you start?

SQL Sentry uses a service to monitor targets. But what if this monitoring service is down? Who will alert about the alerter not alerting?

You can configure auto-scaling in two ways. The first is called Optimized Auto-Scale, and the second is called Custom Auto-Scale...