In my previous post, I showed how to borrow a snake draft concept from fantasy football, or a packing technique from the shipping industry, to distribute different portions of a workload to run in parallel.
2024-05-06
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the database dashboards and how you can customize them. The other articles in this series on ADS works […]
2024-05-03
3,347 reads
In this article, we look at how to setup different ways to handle pipeline failures and notifications when working with Azure and Azure Data Factory.
2024-05-03
This article explains metadata driven pipelines and shows an example in Microsoft Fabric.
2024-05-01
5,283 reads
I recently had a restore job where I needed to split the work up into multiple parallel processes (which I’ll refer to here as “threads”). I wanted to balance the work so that the duration was something significantly less than the sum of the restore times
2024-05-01
This article shows how to import and export a list of registered servers from SSMS.
2024-04-29
6,589 reads
Learn how to use different Spark SQL string functions to manipulate string data with explanations and code examples.
2024-04-29
In this article, I will discuss the history and thinking behind several types of logic that are typically associated with writing relational database code.
2024-04-26
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results:
2024-04-24
An updatable view in SQL Server is a view that allows modifications such as INSERT, UPDATE, or DELETE operations on the underlying tables through the view.
2024-04-22
6,453 reads
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
Comments posted to this topic are about the item Collecting Data Is Hard
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers