Getting Started with MLflow in Azure Databricks
In this article we cover how to get started with MLflow using Azure Databricks which manages the end-to-end machine learning lifecycle.
2021-05-07
Articles
Finding Dependencies in SQL Server Databases using SQL Dependency Tracker
Before you alter a database object, you need to understand what other objects will be affected. This article shows how to generate a simple dependency diagram that reveals both those objects that reference the target object, and those referenced by it, and includes foreign key references, column references and all the other details you need.
2021-05-05
Insurance price prediction using Machine Learning (ML.NET)
In this article, Chandra Kudumula shows how to use ML.NET to train a model for predicting costs from an insurance dataset.
2021-05-05
Understanding CRUD Operations Against Heaps and Forwarding Pointers
In this article, we examine how data changes are made against heaps.
2021-05-03
4,826 reads
How to Generate Fake Test Data for SQL Server
How to use a SQL random data generator to fill SQL Server tables with realistic test data, to shift left database unit testing, integration testing and performance testing so that it is performed during the early stages of database development.
2021-05-03
SQL Server Memory Usage Query
Check out this SQL Server function that can return memory usage information for a SQL Server instance such as the amount of memory SQL Server is using and available memory on the machine.
2021-05-03
“Included columns” for non-clustered indexes explained
Learn about the advantages and disadvantages of using INCLUDE columns in your index.
2021-04-30 (first published: 2019-09-17)
29,009 reads
Reducing the Frequency of SQL Server Central Newsletters
We are reducing the sending of the SQL Server Central newsletter to three days a week.
2021-04-30 (first published: 2021-04-26)
1,178 reads
Power BI for Business Intelligence
Power BI is becoming widely used for reporting and data analysis. There are many different versions of Power BI and the features that are offered and this article provides an overview of what is available.
2021-04-30
Running SQL Code Analysis during Flyway Migrations
A set of PowerShell automation script tasks for running database build and migrations tasks. This article describes the SQL code analysis task, which will check the syntax of the SQL code in your databases and your migration scripts for 'code smells'.
2021-04-30
Blogs
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers