Just as your Power BI table visualizations. I often want to build a dashboard with sleek elegant visualizations and at the same time show...

Are you using CSV files as a primary file format for your data? CSV is a very useful file format if you want to open the file in Excel...

Does your query sometimes run fast and sometimes slow – even when nothing’s changed? Learn how to fix it...

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)...