25 Years Later: What SQLServerCentral Meant to Me
A look back at SQL Server Central after 25 years from founder Brian Knight.
2026-02-20
1,374 reads
Articles
I Just Don’t Understand Why You Don’t Update SSMS.
A long time ago in a galaxy far, far away, SQL Server Management Studio was included as part of the SQL Server installer.
2026-02-20
Azure Functions: The Serverless Powerhouse
Today’s organization are faced with multiple conflicts for their current cloud infrastructures and which approach to go with either opting for a microservice or monolith applications. However, there are numerous difficulties with standard hosting methods.
2026-02-18
Database Deployment with Terraform - Modules
Deploy resources in Azure using reusable code with Terraform modules.
2026-02-16 (first published: 2022-10-10)
12,860 reads
Securing Your Databases in 2026: Best Practices for the Evolving Threat Landscape
In 2026, your approach to both applications and databases must be focused on practical and technical real-world operations and use cases rather than just hype.
2026-02-16
Exploiting SQL Server Date Correlation Optimization: How Tampered Backups Enable Cross-Database Data Leaks
This article reveals a critical SQL Server flaw: attackers can weaponize Date Correlation Optimization (DCO) views in restored backups
2026-02-13
Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform
This next articles gives you a few quick ways to access data in remote storage.
2026-02-11
1,394 reads
Using REGEXP_COUNT to Count Strings in SQL Server 2025
We need to find out how many times certain strings appear in a column. We’ve used the LEN and REPLACE functions for years, but recently heard about REGEXP_COUNT and want to evaluate it, since we plan to upgrade to SQL Server 2025. How can we test this new feature?
2026-02-11
GPX distance and time analysis in SQL Server
In this article we do a comparative analysis of the distance covered by two athletes during a race using the data of their GPX files.
2026-02-09
1,642 reads
Common Misconceptions About Microsoft Certification Exams
An experienced exam writer explains common misconceptions about Microsoft certification exams, question design, preparation, and real-world expectations.
2026-02-09
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers