
Getting In: Running External Code in a Locked-Down PaaS
In Part 1, I explored how to bend SQL Server Agent to our will and peek under the hood of Azure SQL Managed Instance (SQL MI), gaining full OS access to the container (all without relying on xp_cmdshell). But once I realized what kind of door I’d opene …

How to Script Dimensions with data build tool (dbt) Macros
In previous articles we introduced the popular data engineering tool dbt (data build tool). We showed you how you can transform data in a Microsoft Fabric warehouse and how you can create tables with dbt models. We also demonstrated how you can use mac …

SQL ConstantCare® Population Report: Summer 2025
In this quarter’s update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server, the data is very similar to last quarter. SQL Server 2019 still rules the market: SQL Server 2022: 24%, up from …
Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration Dimension
Background In the first parts of this series (part 1, part 2, part 3), we explored dimension tables for age groups, calendar days, and dynamic banding at the day level. These covered time aspects that align with calendar structures—birthdates, admissio …

Updated First Responder Kit and Consultant Toolkit for July 2025: Independence Release
I’mma wax philosophical for a second: I love the open source nature of the First Responder Kit because it lets anybody, anywhere, diagnose database problems faster. If you’re a full time employee somewhere today, you owe it to yourself to use the FRK s …

SQL Server 2022 Clusterless Distributed Availability Group
One customer had a very specific scenario: They had an Always On Availability Group with Windows Server Failover Cluster Each node had its own storage, so the witness was not disk-based but network-based One node was in the cloud and the other was a ph …
Revolutionizing Efficiency: The Power of Custom Automation Software Development
With the ever-increasing pace of the digital era, companies are continuously looking for opportunities to enhance efficiency, cut costs, and optimize operations. The most viable way to accomplish these is through Custom Automation Software Development. …
SQL Server and AI: Integrating Machine Learning Services
Have you ever wished you could run your data science experiments right where your data lives, without the hassle of moving huge files around? That’s exactly what Microsoft set out to solve with SQL Server Machine Learning Services (MLS). Starting with …
[Video] Office Hours: Finally Back in the Home Office
I’m finally back in the home office after running around Europe for a month. Let’s talk through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:52 World Peace: Hey Brent, I am working in AZURE curre …

PostgreSQL Aggregate Functions
Overview In this article we will go through the various in built aggregate functions available in PostgreSQL. Aggregate functions perform a calculation on a set of rows and return a single value. COUNT Function The COUNT function is a simple and very u …
Zero-Trust Architecture for Cloud-Based AI Systems
The post Zero-Trust Architecture for Cloud-Based AI Systems appeared first on SQLServerCentral.

Cloning Master Admin User Permissions in Amazon RDS for SQL Server with Fine-Grained Control
Introduction When you create a new Amazon RDS for SQL Server instance, the master user is provisioned with elevated privileges, allowing them to perform most administrative operations permitted within the confines of the RDS managed environment. Howeve …

Creating Uber-Fast Maps With 23ai Vector Tiles and H3 Indexes: Part 1
Oracle Database 23ai added 300+ new features like the new VECTOR datatype that get most of the attention, but often overlooked are two new features that dramatically expand support for complex geospatial problem-solving. In this article we’ll take a cl …

Microsoft Introduced AI Integrations for SQL Server.
You know how you put “https://” at the beginning of web site addresses, and your browser can magically talk to all kinds of web servers, all over the world? Well, the Model Context Protocol (MCP) is a standard for AI stuff to talk to other things. It’s …
Common SQL Server Problems: Network Related or Instance Specific Error Occurred
This is the first in a series of articles meant to provide practical solutions to common issues. In this post, we’ll talk about one of the most pervasive error messages out there: A network-related or instance-specific error occurred while establishing …