JSON in Microsoft SQL Server: A Comprehensive Guide
Introduction JSON (JavaScript Object Notation) has become a popular data format for storing and exchanging information. Microsoft SQL […]
Archives du mois : janvier 2025
How to rename a SQL Server database
The post How to rename a SQL Server database appeared first on SQLServerCentral.
Accessibility, and the Need for Ingenious Simplicity in Computer Scripts, ...
I’m very keen on accessibility in computer systems. Nowadays we tend to take a rather superior attitude […]
[Video] Office Hours and an AI-Generated Sweatshirt
I originally took these questions from https://pollgab.com/room/brento poolside at the Trixie Motel (really), but I forgot to use […]
SQL Endpoint Secrets you need to know
Recently I had a severe problem with SQL endpoints and I was required to build a quick […]
Index Rebuilds Make Even Less Sense with ADR & RCSI.
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works. […]
Creating a Linked Server in Amazon RDS for SQL Server: ...
A common requirement for database professionals working with SQL Server is the capability to connect seamlessly to other […]
A Practical Guide to Using Azure Key Vault in Enterprise ...
The post A Practical Guide to Using Azure Key Vault in Enterprise Deployments appeared first on SQLServerCentral.
What If You Need to Index a Lot of Duplicate ...
Let’s get a little nerdy and look at database internals. Create two tables: one with a million unique […]
Creating Time Series Collections in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Weekly Blogging
I spent a few weeks away from the office in early January, just like last year, mostly […]
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 […]
Add and Subtract Dates using DATEADD in SQL Server
The post Add and Subtract Dates using DATEADD in SQL Server appeared first on SQLServerCentral.
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). […]
Temporary Tables
There is a feature of SQL I have not seen used much and probably with good reason. […]
Boosting Data Accuracy: Resolving Common Data Quality Issues Using SQL
Project Context and Data Presentation Challenges In our projects we have seen, data quality issues manifest in various […]
[Video] Office Hours in My Vegas Backyard
I took 5 of your top-voted questions from https://pollgab.com/room/brento while hanging out in the backyard on my second […]
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 […]
Navigating the Database Landscape in 2025 Livestream on Feb 12
The post Navigating the Database Landscape in 2025 Livestream on Feb 12 appeared first on SQLServerCentral.
Can AI Rewrite Bad Queries in Seconds? Kinda.
When I see horrific code, stuff that would take a lot of manual labor to fix, I like […]
How to Install SSIS in Visual Studio 2019
The post How to Install SSIS in Visual Studio 2019 appeared first on SQLServerCentral.
Why Standards are Important
Throughout my career I have seen arguments as to which IT standard in a particular area, is the […]
SQL Server Integration Services (SSIS) Microsoft Connector for Oracle deprecation
In July 2025, Microsoft will discontinue support for the Microsoft Connector for Oracle in SQL Server Integration Services […]
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 […]
Pop Quiz, 2025 Edition: What Do These Things Cost Today?
Price check on Aisle 2025. My main consulting job is a 2-day SQL Critical Care® where I help […]
Nostalgic Memory Loss
Today’s topic pertains to 99.999% of all people, young, old, and all age ranges . I am […]
Loading Models from Source Data with dbt
The data transformation tool dbt (data build tool) has become more and more popular over the past […]
Influencing a Local AI
I set up a local AI LLM to run and then conducted some experiments. This post shows a […]
Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real ...
The post Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD appeared […]
MySQL Shell and Basic Configuration Management (Part 2 – Memory ...
Part 2 in the series: A Comprehensive Beginners Guide to Configuration with MySQL Shell. In the first […]
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 […]
Vector DB implementation using FAISS
Searching for relevant information in vast repositories of unstructured text can be a challenge. This article explains a […]
Using Snyk for CI/CD Security Scanning
Security is important regardless of your industry, whether it’s finance, retail, e-commerce, or the broader world of […]
I’m Coming to Croatia!
A few things lined up perfectly for a European trip this summer. I’m on a European cruise in […]
Fabric Copy Job: What’s new in it
At first sight, the new Copy Job may seem only one more redundancy: Why do we need […]
The year ahead for SQL Server: Ground to cloud to ...
As we begin a new year in 2025, many of you are looking at new projects, new applications, […]
Does Separating Data and Log Files Make Your Server Faster?
I’ve already explained that no, it doesn’t make your database server more reliable – and in fact, it’s […]
Announcing the 2025 Data Professional Salary Survey Results.
We’ve been running our annual Data Professional Salary Survey for almost a decade, and I was really curious […]
FinOps pour Microsoft Fabric
Version de l’article en Anglais sur LinkedIn : Le FinOps et Microsoft Fabric, deux sujets qui m’intéressent […]
VIEW Objects
A view is a virtual table, created when it’s invoked by the < view name>. The goal […]
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 […]
Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, ...
The post Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines appeared first on […]
I Wrote a Book on How You Broke Your Database ...
Preface If you are a frequent reader of Simple-Talk, it’s possible that you’ve come across blogs about […]
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 […]
Comparing Groups for Similarities in Power Query – Using Cosine ...
The post Comparing Groups for Similarities in Power Query – Using Cosine Similarity appeared first on SQLServerCentral.
[Video] Office Hours: Long Answers Edition
Today’s questions from https://pollgab.com/room/brento require a little bit longer answers: Here’s what we covered: 00:00 Start 03:20 Josef: […]
I Feel Sorry for Untrained Developers Using Entity Framework.
Most of the time, I love Entity Framework, and ORMs in general. These tools make it easier for […]
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 […]
SQL Server OPTION RECOMPILE for Simple Queries
The post SQL Server OPTION RECOMPILE for Simple Queries appeared first on SQLServerCentral.