MinIO : sauvegarde et tables externes SQL Server
À la suite de mon dernier article en lien avec l’externalisation des données SQL Server sur un stockage […]
SQL Server
AI in SQL Server 2025: Embeddings
One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for […]
SQL Server 2022 CU Updates and Error Code 0x851A0043
I’ve been working in the Azure space for the last few years and less with full server […]
SQL Server External Tables : archivage et externalisation
L’archivage des données devrait être prévu dès le début des projets. Mais, il faut bien avouer que c’est […]
I’m coming to Jacksonville and Raleigh for SQL Saturday! Register ...
I’m coming to Jacksonville, FL on May 2-3 and Raleigh, NC on May 16-17 for SQL Saturdays! In […]
Exploring Scalar Solutions to Complex Data Math
There are many functions and tools available to database professionals that can solve data math challenges, regardless […]
The 8 Worst Things Microsoft Ever Did to SQL Server
Last week I wrote about the 6 best things Microsoft ever did to SQL Server, but now we […]
SQL Server BIT_COUNT and an Alternative
I was editing an article the other day that uses the BIT_COUNT function that was added to […]
Understanding Data Type Conversion Functions in SQL Server with PARSE, ...
Introduction SQL Server provides robust tools for data type conversion, such as PARSE, TRY_PARSE, and TRY_CONVERT. These functions […]
The 6 Best Things Microsoft Ever Did to SQL Server
This entire blog post is driven by the #1 feature in this list. I think about the #1 […]
Dark Mode in SSMS 21 and overall first impressions
Let me cut to the chase. If you are like me, you may have been searching for: […]
Paires Clé-Valeur dans un contexte de sessions SQL Server
Il est des cas d’usage où pourvoir garder en mémoire des informations (des variables globales en somme) serait […]
Attaching Multiple SQL Server Databases with DBCC CHECKPRIMARYFILE
Introduction Attaching databases in SQL Server can be a routine yet sometimes time-consuming task for Database Administrators (DBAs). […]
Azure SQL Serverless: Discover What’s new and Increase Your Savings
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]
Un GREP pour les bases de données MS SQL Server
Comment rechercher dans toutes les tables et toutes les colonnes une valeur précise ? C’est ce que propose […]
Chiffrement des sauvegardes via clés extensible Azure Key Vault
Il est des situations où utiliser une clé de chiffrement asymétrique stockée dans un module de gestion de […]
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions ...
Introduction When working with T-SQL trigonometric functions in SQL Server, it’s important to be aware of potential pitfalls […]
Customizing the Export and import of Parquet Files in SQL ...
Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an […]
Resolving Access Denied Errors During SQL Server Database Attachment
Introduction Database administrators regularly detach and attach databases as part of their daily tasks. During this process, they […]
A Use Case for Memory-Optimized Tempdb Metadata
I recently had an interesting production SQL Server issue that turned out to be very easy to […]
Five changes to SQL Server I’d love to see
I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very […]
How to Attach and Detach Databases in SQL Server
Introduction Managing databases in SQL Server requires a solid understanding of various methods for transferring and maintaining data. […]
Attaching an SQL Server database without Transaction Log Files through ...
Introduction In SQL Server, the transaction log file is essential for keeping your database reliable and durable. It […]
How to Explain What We Do
One of my favorite uses for AI is to ask it to explain a concept using wildly unusual […]
Announcing the Holiday Sale
Our annual Black Friday sale is over, but we’ve got a simple sale for folks who couldn’t get […]
3 Legit Signs It’s Time for Enterprise Edition
Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re […]
Reading and Writing Parquet Files in SQL Server
When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place […]
How to Develop Custom T-SQL Code Snippets in Azure Data ...
To get started, follow these steps to find and use the default snippets in Azure Data Studio. In […]
Office Hours at the PASS Summit in Seattle
I’m in Seattle this week for the PASS Data Community Summit. Before the pre-conference sessions started, I sat […]
SQL Server Performances – CHAPITRE 3 – Estimateur de Cardinalité, ...
Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]
Enhancing SQL Server Searches with Elasticsearch and Python
As a seasoned SQL developer and tech enthusiast, I often encounter scenarios where traditional SQL Server searches struggle […]
The 2024 Black Friday Sale is Coming Next Month.
Your accounting office Every year during November, we run a big sale all month long. And every year, […]
SQL Server Performances – CHAPITRE 2 – Faut-il paramétrer, régler, ...
Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]
Effective Strategies for Storing and Parsing JSON in SQL Server
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or […]
Days of the Week, Bitwise Edition
I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this […]
Thoughts About Stack Overflow’s Annual Developer Survey
Every year, Stack Overflow runs a developer survey about technology, work, community, and more. This year’s results include […]
Index cleanup : Harder than it looks
I’m not the first person to write about cleaning up unused or redundant indexes. You can read […]
Auditing SQL Server – Part 2 – Hardware Audit
This is the second part of my series on auditing SQL Server. In the first part, I […]
SQL Server, gestion de la performance… et la VM dans ...
Voici une série d’article comportant 10 chapitres destinés à tout ceux qui veulent obtenir de meilleurs performances avec […]
Haute disponibilité – SQL Server vs PostGreSQL
La haute disponibilité des données est un facteur fondamental dans l’élaboration d’une architecture de bases de données, notamment […]
It’s a recovery strategy, not a backup strategy
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. […]
Set up a Windows Server Fail-over Clusters (As a Precursor ...
In this walkthrough, we will be setting up WSFC (Windows Server Failover Cluster) in Windows Server. An WSFC […]
XML Performance Tuning and Added Options
SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes […]
Auditing SQL Server – Part 1 – Discovery and Documentation
Inheriting a server, whether as an inexperienced user or an experienced DBA, has many challenges. It’s very […]
Snake draft sorting in SQL Server, part 4
In the previous posts in this series (part 1, part 2, part 3), I described how I […]
Détecter les blocages dans MS SQL Server
Un blocage est un phénomène normal dans tous SGBD Relationnels pour éviter les conflits d’accès en écriture qui, […]
Snake draft sorting in SQL Server, part 3
In part 2 of this series, I showed an example implementation of distributing a long-running workload in […]
Snake draft sorting in SQL Server, part 2
In my previous post, I showed how to borrow a snake draft concept from fantasy football, or […]
Snake draft sorting in SQL Server, part 1
I recently had a restore job where I needed to split the work up into multiple parallel […]