Upgrade and Migrate SSIS Catalog and SSISDB to a New ...
The post Upgrade and Migrate SSIS Catalog and SSISDB to a New Server appeared first on SQLServerCentral.
Archives de l’année : 2025
Configuring Maintenance Plans in SQL Server
In this article, we are going to configure a maintenance place on the SQL Server 2017 instance installed […]
[Video] Office Hours: We’ve Got the (Honda) Beat
Meet my latest toy, a 1991 Honda Beat! I introduce it, then take your top-voted questions from https://pollgab.com/room/brento. […]
Fabric Databases Connection Secrets
Fabric Database was a great announcement during Ignite Conference. The announcement spread all around, a great new […]
Why I Mention My Sexuality and Gender
I certainly don’t discuss it often, and it’s been a few years since I wrote about my pansexuality. […]
Index Rebuilds Make Even Less Sense with ADR & RCSI
The post Index Rebuilds Make Even Less Sense with ADR & RCSI appeared first on SQLServerCentral.
How to Resolve SQL Server Database Stuck in Recovery Pending ...
Introduction In this article, we will learn how to restore a database which is stuck in the Recovery […]
I’m Doing Free SQL Server Spring Training Live Webcasts. Register ...
Starting next month, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: […]
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 […]
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 […]
Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL ...
Introduction SQL Server 2022 introduces powerful bit manipulation functions that allow for efficient handling of binary data. These […]
Find Text in Stored Procedure, Function, View, or Trigger
The post Find Text in Stored Procedure, Function, View, or Trigger appeared first on SQLServerCentral.
Implementing Vector Datatype with Azure SQL Server
Overview Searching for relevant information in vast repositories of unstructured text can be a challenge. This article demonstrates […]
Fun with PowerShell Asynchronous
The post Fun with PowerShell Asynchronous appeared first on SQLServerCentral.
MySQL Index Overviews: Descending B-Tree Indexes
Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly […]
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 […]
[Video] Office Hours: Hawaiian Edition
I took your top-voted questions from https://pollgab.com/room/brento and answered ’em from my balcony at Disney’s Aulani Resort in […]
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 […]
Using Group Managed Service Accounts with SQL Server
The post Using Group Managed Service Accounts with SQL Server appeared first on SQLServerCentral.
How to Develop Solutions with Fabric Data Warehouse: Data Engineering ...
The SQL endpoint of the Fabric Data Warehouse allows programs to read from and write to tables. The […]
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 Database Project in Azure Data Studio
Introduction This article teaches how to use the Azure Data Studio extension to handle SQL Database projects. It […]
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 […]
How to use @@ROWCOUNT in SQL Server
The post How to use @@ROWCOUNT in SQL Server appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Winter 2025
Every quarter, we publish adoption rate data showing how quickly people are adopting new versions of SQL Server. […]
Who’s Hiring in the Microsoft Data Platform Community? February 2025 ...
Is your company hiring for a database position as of February 2025? Do you wanna work with the […]
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 […]
An Effective Approach for High Volume Data in Azure Synapse
Introduction Azure Synapse Analytics, previously known as Azure SQL Data Warehouse, is a widely utilized platform for storing […]
SSMS Export to Excel
The post SSMS Export to Excel appeared first on SQLServerCentral.
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: […]
Frappe and Laravel: Database Management and Migrations
In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of […]
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 […]
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 […]