Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices
VIEWs are an undervalued and underused feature in SQL. They basically consist of a query that has […]
Archives de l’année : 2025
Yet another Date Dimension
Evolution of code The thing with any bit of code that has been around for a while, is […]
Advanced SQL Server Page Forensics: Detecting Page Splits and Allocations ...
Introduction Page splits are one of those silent performance killers in SQL Server that many DBAs have heard […]
How to Access and Use Azure Key Vault Secrets in ...
When you run a CI/CD pipeline, you often need confidential values like passwords, authentication tokens, service principal secrets […]
How to Use the psql Command-Line Tool with Azure Database for PostgreSQL ...
A number of client tools are available for working with Azure Database for PostgreSQL flexible server. With […]
Connect Cloud Power BI to on prem SQL Server
Power BI has the versatility that you can publish your reports to the cloud (Power BI Service) and […]
Model Context Protocol (MCP): A Developer’s Guide to Long-Context LLM ...
Large Language Models (LLMs) like Anthropic’s Claude have unlocked massive context windows (up to 100k tokens in Claude […]
How to safely and surgically restore filegroups
In all my years working with SQL Server and navigating disaster recovery scenarios, I’ve come across surprisingly few […]
[Video] Office Hours: Interview Horror Stories Edition
Wanna hear about my worst job interviews? I drove up to 8,000 feet where it’s 30 degrees colder […]
MongoDB and Python in action
Overview As a part of this article, we will learn basics of connecting to MongoDB using a python […]
Best Way to Repair SQL Database: How to Restore SQL ...
Summary: SQL Server administrators frequently encounter the critical challenge of unexpected MDF file corruption. Such corruption can result […]
Poll Results: Yes, Your DBAs Can Read the Data.
Last week, I asked if your database administrators could read all of the data in all databases. The […]
MySQL Index Overviews: PRIMARY KEY Indexes
If you’re a developer who had interactions with indexes in the past, you certainly know that indexes […]
The Query Tuning Trick You Should Use More: Pagination
When I’m tuning queries, the normal answer is to make the query perform better – either via changing […]
How to Increase SQL Server Column Width Without IO (Input/Output) ...
One of the most hassle-prone changes that can be made in a SQL Server database is to […]
How to optimize queries using AI (SQL Expert)
Introduction ChatGPT can help you with your queries. However, some customized GPTs inside ChatGPT can be useful for […]
Nouveautés SSMS 21 & SQL Server 2025 : Copilot, Halloween ...
Exploration des nouveautés de SQL Server Management Studio 21 et SQL Server 2025, avec des démonstrations pratiques […]
Retour d’expérience client sur le change data capture et la ...
Clément Hugé Après une rapide présentation de la fonctionnalité et des avantages et inconvénients, nous nous attarderons […]
Verrouillage optimiste vs pessimiste… Les implémentations dans les SGBDR
Frédéric Brouard, SQL Spot Optimiste ou pessimiste ? Le vrai visage du verrouillage selon votre SGBD Oracle, […]
Les Nouveautés dans SQL Server 2025, IA ready !
Julien Pierre, Microsoft et Stéphane Scherrer, Microsoft SQL Server 2025 : l’IA s’invite au moteur SQL Server […]
Les synonymes dans SQL Server + Projet SQL Server dans ...
Sébastien Kobenan Sujet 1 : Les synonymes dans SQL Server Vous avez une ou plusieurs bases de […]
How to Measure Replication Latency in SQL Server AlwaysOn Synchronous ...
Synchronous replicas in SQL Server Availability Groups promise no data loss, but they don’t promise zero delay; […]
[Video] Building a Brand By Sharing Your Work
You’ve got a good job, and some spare time. You’re thinking about giving back to the community by […]
Connecting to PostgreSQL with Node.js
Overview In this article, we will understand how we can connect to PostgreSQL using Node.js application. We will […]
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict ...
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict User Group Consumption As a SQL Server professional, […]
Monitor SQL Server using Zabbix
Zabbix is an open-source monitoring software, like Paessler PRTG, which can monitor SQL Server performance statistics and status. […]
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, […]
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 […]