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.
Microsoft Security Changes and SQL Server
Windows is changing its security, which will affect SQL Server.
Expanding into Print
This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month. When we started SQL Server Central, our goal was to build a great resource that helped other people advance in their careers and also made some money. Our decisions in building the site were […]
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
The Power of Data and Privacy
Steve discusses privacy and data that is publicly available on the Internet.
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.
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?
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.
The DBA is Dead; Long Live the DBA
There have many many times when a company or individual has thought that DBAs aren't needed. Steve doesn't think that has ever been true, nor will it be anytime soon.
Blogs
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Forums
Alamat BCA KCP GAMA Telp:08218200233
Telp/Wa 62 8218200233 Gama Tower Lt. Dasar Unit B, Jl. H. R. Rasuna Said...
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers