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 […]
Archives de l’année : 2025
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 […]
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 […]
[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 […]
Alerte Windows : Microsoft découvre une faille zero day qui permet ...
Microsoft colmate une faille zero day dans Windows. L’éditeur a en effet découvert et corrigé une brèche dans […]
PostgreSQL Aggregate Functions
Overview In this article we will go through the various in built aggregate functions available in PostgreSQL. Aggregate […]
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 ...
Introduction When you create a new Amazon RDS for SQL Server instance, the master user is provisioned with […]
Creating Uber-Fast Maps With 23ai Vector Tiles and H3 Indexes: ...
Oracle Database 23ai added 300+ new features like the new VECTOR datatype that get most of the […]
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 […]
Common SQL Server Problems: Network Related or Instance Specific Error ...
This is the first in a series of articles meant to provide practical solutions to common issues. […]
Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution ...
Introduction When you see high CPU and the query plan says « parallelism, » one of the first suspects is […]
Automating SQL Server Inventory Collection with SQLInventory
Managing SQL Server inventory is crucial when your organization has many SQL Server Instances. A central database that […]
[Video] Job Options: Zooming Out to See the Big Picture
One of my readers asked me to give a 30-minute talk to their company’s internal employees discussing the […]
13 Things I wish I knew about Power Query (when ...
When I first started with Power Query, it was in Excel, through the Power Pivot feature. I […]
What’s New (And Undocumented) in SQL Server 2025 CTP 2.1
As the SQL Server 2025 previews continue to come out, Microsoft is making changes that they’re not telling […]
Who’s Hiring in the Microsoft Database Community? July 2025 Edition
Is your company hiring for a database position as of July 2025? Do you wanna work with the […]
Unlocking Infor CloudSuite data: Making the most of it with ...
In my experiences building end-to-end analytics solutions, I often need to connect to a variety of different […]
Columnstore Index Improvements in SQL Server 2025
Columnstore indexes are a powerful tool for storing analytic data directly in SQL Server. This feature has […]
How to Work with RStudio and SQL Server
Introduction Sometimes, we need to connect to SQL Server using RStudio, the most common tool for programming in […]
Retrieving SQL Server Index Properties with INDEXPROPERTY
The post Retrieving SQL Server Index Properties with INDEXPROPERTY appeared first on SQLServerCentral.
Why Clone Fails: Discovering the Hardware Beneath Azure SQL MI
Microsoft describes Azure SQL Managed Instance (MI) as offering near-full SQL Server compatibility with more flexibility than typical […]
Mastering Class Updates on Resource_Semaphore, The Ascending Key Problem, and ...
I’ve posted a couple of updated videos to my Mastering courses. In Mastering Server Tuning, I updated and […]
[Video] Office Hours in My London Hotel Room
When I’m on the road, I try to take you along with me to glamorous or scenic locations […]
Poll Results: How Often You’re Running Maintenance Tasks
Last week, I asked y’all how frequently you ran your full backups, corruption checks, index maintenance, and stats […]
State Transition Constraints
About two decades ago, I introduced the concept of transition constraints to show Data Validation in a […]
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and ...
Introduction In our TB-scale production system, a few queries had MAXDOP 4 hardcoded into them. The goal was […]
Oracle ASM: Monitoring and Managing (Part 2)
In the first part of this series, we explored the fundamentals of Oracle Automatic Storage Management (ASM)—a […]
SQL Server Reporting Services is Dead. Is SSIS Next?
It’s official: SQL Server 2022 was the last release for SSRS. At SQLBits this week, Microsoft announced that […]
How to Choose the Right Tool for MS SQL to ...
This whitepaper serves as an in-depth guide for database administrators (DBAs), software engineers, data architects, and even semi-technical […]
Enhancing reporting and analytics with SQL Server 2025 tools and ...
SQL Server 2025 public preview announcement Read the blog At Microsoft Build 2025, we announced the public preview […]
Replacing a Column in a Large Active SQL Server Table
In a previous post I showed how to use a batching strategy to remove large amounts of […]
[Video] Office Hours on the Cruise Ship
I’m on a Med cruise, and I stopped the boat today in Corsica to make sure your questions […]
Getting started with Azure Database for PostgreSQL Flexible Server
Along with its many other cloud services, Microsoft now offers Azure Database for PostgreSQL Flexible Server, a […]
[Poll] How Often Do You Run Maintenance Tasks?
How often do you run backups, corruption checking, index maintenance, and statistics updates? Click here to take the […]
Inside the Walls of Azure SQL MI
Welcome to the prologue article for a three-part series where I try to infiltrate the OS layer of […]
Free Webcast Next Thursday: Tuning Indexes to Avoid Blocking
Indexing can make or break your SQL Server performance. You need just the right balance: enough indexes to […]
DevOps vs. SRE: Bridging the Gap, Not Building Walls (Part ...
Understanding the Divide — DevOps vs. SRE Explained The conversation around DevOps versus Site Reliability Engineering (SRE) […]
From code to community: The collective effort behind SQL Server ...
At Build 2025, SQL Server 2025 officially entered public preview. As one of the world’s most popular databases, this […]
How to process images and analyze charts with AI
In this article, we will see how to handle images with AI. Sometimes we need to import the […]
Replicating MySQL databases in Docker Containers
In my prior article, “Running a relational database with Docker”, I showed how to spin up a […]
Dimensional Modeling Case Study Part 3 – Dynamic Days Dimension
Background In this case study series, we’ve explored how to use age and tally tables to support various […]
Load Data into Snowflake Using Native Snowflake Connector for Python: ...
In our ongoing exploration of Snowflake data loading strategies, we’ve previously examined how to use pandas with […]
[Video] Office Hours at the Barcelona Pavilion
I’ve always wanted to see the Barcelona Pavilion by Mies van der Rohe, and by happy coincidence, I […]
Query Exercise Answers: Returning Routes in the Right Order
In your most recent Query Exercise challenge, I gave you these two tables: DROP TABLE IF EXISTS dbo.Stations; […]
SQL Server 2025 : Zstandard Backup Compression
This article is part of a series of posts on the forthcoming SQL Server 2025 release. Once […]
Guide to Decoding SQL Server Bulk Insert Error Files
Learn how to work with SQL Server’s ERRORFILE option to isolate problem records, decode cryptic error messages, and […]
TempDB Resource Governor Space Controls in SQL Server 2025
TempDB is a system database in SQL Server that manages temporary objects for all databases on a […]
SQLBits Added More Capacity to My Workshop! Move Quick.
I’m coming to London this month for SQLBits, and my Thursday workshop “Faster, Cheaper Cloud Databases” workshop sold […]
The good, the bad, and the awful taste muscle memory ...
When I was traveling a while back, I grabbed a small white metal tube out of my […]