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 […]
Archives de l’année : 2025
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 […]
[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 […]