Poll: Can Your DBAs Read the Data?
It’s a simple question: can your database administrators read all of the data in all databases? Yes Yes, […]
Archives de l’année : 2025
How to use pgAdmin with Azure Database for PostgreSQL flexible ...
Multiple tools are available for working with Azure Database for PostgreSQL flexible server. One of these is […]
Database Architecture Considerations for Implementing Content Moderation Services
Fellow SQL Server professionals, I wanted to share some insights and start a discussion about the database design […]
Migrate from Linux to Windows with Availability Groups
We have an SQL Server 2019 server running on Linux Ubuntu, and we want to migrate to Windows […]
Want Me to Train You & Your Coworkers Privately?
Your company doesn’t want to send you off to conferences or training classes in other cities. You’ve looked […]
Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL ...
Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS As a database […]
Microsoft Fabric Has a New Service Status Page.
I’ve been pretty vocal here on the blog and on social media about the reliability problems with Microsoft […]
How to Use the New PRODUCT() Function in SQL Server ...
With each version of SQL Server, there are always a few new features introduced that we applaud […]
An Introduction To Database Diagrams
A database diagram clearly details the structure, relationships, and data rules in a database. It makes storing, retrieving […]
When INCLUDE Columns Quietly Inflate Your Transaction Logs
Introduction As DBAs, we often think of INCLUDE columns as a harmless way to cover queries.They aren’t part […]
Automating SQL Server Access Review
Tracking and reviewing user access in a SQL Server is an important tasks for any DBA. Unauthorized access […]
Accelerate SQL Server Migration to Azure with Azure Arc
We’re excited to announce a new migration experience in Azure Arc to simplify and accelerate SQL Server migration. […]
Incrementally Loading Data into Parquet with Python
Parquet is a column-oriented open-source storage format increasingly used for “big data” analytics. Yet despite its growing […]
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 […]
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 […]
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 […]
Dimensional Modeling Case Study, Part 4 – Dynamic Time Duration ...
Background In the first parts of this series (part 1, part 2, part 3), we explored dimension tables […]
Protect and modernize SQL Server 2016 workloads with Microsoft
We take pride in delivering innovation with each new version of Microsoft SQL Server. However, there comes a […]
Updated First Responder Kit and Consultant Toolkit for July 2025: ...
I’mma wax philosophical for a second: I love the open source nature of the First Responder Kit because […]
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 […]
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 […]