Snake draft sorting in SQL Server, part 2
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.
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.
The world seems to be proceeding through some stuff at the moment. IT and our industry as a whole, equally seems to be going through some stuff. As such, allow this oldster to offer some advice: Take care of yourself. I know, I'm the same, you may have responsibilities for others. You need to take […]
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 […]
Today Steve asks about on-call responsibility for you and how you view this as part of your job, or in your job search.
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.
A big part of success is making an effort. Steve discusses the need to do things and not passively let life pass you by.
This article explains metadata driven pipelines and shows an example in Microsoft Fabric.
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
This article shows how to import and export a list of registered servers from SSMS.
Today, Kendra Little talks about code reviews and why they should be done early.
In today’s data-driven world, having the right tools to manage and process large datasets...
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
In a previous post we went through how to use Docker Build Cloud to...
I took a backup with the CHECKSUM option, which was successful and showed no...
Comments posted to this topic are about the item Realities of Predictive Analysis
Just came across something weird. Was wondering if anyone else has ever seen this....
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers