Demystifying PIVOT and UNPIVOT in T-SQL
There are few operators in T-SQL that cause developers to scramble for documentation more than PIVOT and […]
Database Administration
4 CVEs are affecting Valkey databases. Here’s everything you need ...
There’s now another reason an immediate patch is needed for organizations running Valkey clusters, according to Percona […]
How tampered indexed-view metadata can break cross-database isolation in SQL ...
Indexed view tampering in SQL Server backups can expose cross-database data after restore. In this article, you’ll […]
In 2026, engineering teams are quietly accepting more risk. Here’s ...
Redgate’s 2026 State of the Database Landscape report reveals that people are increasingly willing to accept more […]
PostgreSQL is removing MD5 authentication for passwords. Here’s what it ...
Upcoming versions of PostgreSQL will be phasing out the MD5 hashing method within the authentication infrastructure of […]
Why database ownership is so fragmented in 2026 – and ...
In today’s cloud-driven, multi-platform environments, answering the simple question – who owns that database? – is no […]
What is chunking, and how does it apply to vectors ...
In this article, Greg Low explains what chunking is, why it matters for embeddings, and how SQL […]
When, and when not, to use LLMs in your data ...
“Let’s add LLMs to the pipeline” has become a familiar refrain in modern data teams, but turning […]
Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL?
String splitting in T-SQL has historically been inefficient and limited. While STRING_SPLIT improved things, its constraints remained […]
How to minimize downtime in a cloud migration
Pat Wright details how to plan cloud migration with minimal downtime. Learn key cutover strategies, testing methods, […]
First Normal Form (1NF): Breaking the ‘unbreakable rule’ in database ...
First Normal Form (1NF) is the most widely known rule in database normalization. It requires that tables […]
Everything you should know about the SQL Server Resource database
Every SQL Server instance contains a database that most people never query, never back up, and never […]
Why most enterprise AI projects fail – and how to ...
Today’s AI landscape is characterized by a gap. While it is often relatively easy to reach the […]
How to migrate from on-prem to the cloud: uncovering legacy ...
In this article, Pat Wright explains how to identify hidden risks in legacy applications before moving to […]
How to determine the last value used by a sequence ...
I’ve been a fan of sequences ever since they were added in SQL Server 2012. Prior to […]
My thoughts on Redgate’s 2026 State of the Database Landscape ...
I always really look forward to reading Redgate’s annual State of the Database Landscape report, and 2026 […]
How to secure MySQL and PostgreSQL in the world of ...
Are you feeling the impact of AI in your daily work? No? Your database might say otherwise. […]
The secret life of database keys
There’s not much to database keys, right? When you build a new table, you add a column […]
Why disabling the SQL Server sa account still matters in ...
Every few years, someone asks a familiar question: do we really still need to disable the sa account in […]
How to optimize planned availability group failovers in SQL Server
We often perform planned availability group failovers in SQL Server for maintenance, patching, upgrades, and even hardware […]
How to safely use MySQL 8.0 post end-of-life (and alternatives ...
Regardless of how popular a specific software appliance is, particular versions of it are inevitably phased out […]
SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained
When SQL Server 2025 was announced, Bob Ward mentioned that there would be some new commands for […]
Securing Your Databases in 2026: Best Practices for the Evolving ...
In 2026, your approach to both applications and databases must be focused on practical and technical real-world […]
Making AI Talk to Your Database: AI-Powered Database Queries Made ...
Nowadays, artificial intelligence is everywhere. It’s so prevalent that even universities are implementing it into their curriculums. […]
Troubleshooting Common SQL Server Errors: 823, and 824
SQL Server is designed to provide high reliability and data integrity. However, like any software, it can also […]
How to Monitor and Optimize Batched Deletion Processes in SQL ...
Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, […]
5 Strategies to Refactor SQL Code
Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality […]
Find Invalid Objects in SQL Server
One of the most important responsibilities of any database administrator is to maintain the integrity of the database, […]
What is Delayed Durability in SQL Server — And Should ...
Introduction When SQL Server commits a transaction, it doesn’t just update data in memory. It also writes a […]
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 […]
MySQL Index Overviews: PRIMARY KEY Indexes
If you’re a developer who had interactions with indexes in the past, you certainly know that indexes […]
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 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; […]
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 […]
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 […]
Automating SQL Server Access Review
Tracking and reviewing user access in a SQL Server is an important tasks for any DBA. Unauthorized access […]
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 […]
Columnstore Index Improvements in SQL Server 2025
Columnstore indexes are a powerful tool for storing analytic data directly in SQL Server. This feature has […]
Retrieving SQL Server Index Properties with INDEXPROPERTY
The post Retrieving SQL Server Index Properties with INDEXPROPERTY appeared first on SQLServerCentral.
Replacing a Column in a Large Active SQL Server Table
In a previous post I showed how to use a batching strategy to remove large amounts of […]
SQL Server 2025 : Zstandard Backup Compression
This article is part of a series of posts on the forthcoming SQL Server 2025 release. Once […]
TempDB Resource Governor Space Controls in SQL Server 2025
TempDB is a system database in SQL Server that manages temporary objects for all databases on a […]
How to Safely Remove a SQL Server Data File Without ...
Introduction Removing SQL Server Data File Without Downtime is one of important activities in enterprise production scenarios. Managing […]
Recovering data in SQL Server without full backup
In more than 10 years of experience, I have dealt with cases where someone has performed incorrect […]
Using the Default Trace in SQL Server
The post Using the Default Trace in SQL Server appeared first on SQLServerCentral.
Killing a SPID and Checking Rollback progress in SQL Server
The post Killing a SPID and Checking Rollback progress in SQL Server appeared first on SQLServerCentral.
How to rename a SQL Server database
The post How to rename a SQL Server database 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). […]
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 […]
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 […]