Greg Low in SQL Server

Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL?

Learn how to split strings efficiently in T-SQL using STRING_SPLIT and the REGEXP_SPLIT_TO_TABLE function in SQL Server 2025. Discover limitations,...

15 April 2026 5 min read

Fabiano Amorim in SQL Server

Cross-database ownership chaining in SQL Server: security risks, behavior, and privilege escalation explained

Learn how cross-database ownership chaining works in SQL Server, how permissions are evaluated, and why it can introduce security risks...

13 April 2026 12 min read

Greg Low in SQL Server

Everything you should know about the SQL Server Resource database

Learn what the SQL Server Resource database is, why it exists, how it affects patching/ upgrades, and what to do...

25 March 2026 5 min read

Greg Low in SQL Server

How to determine the last value used by a sequence in SQL Server

Learn how SQL Server sequences work, how they differ from IDENTITY columns, and how to track the last value with...

17 March 2026 6 min read

Greg Low in SQL Server

IDENTITY vs SEQUENCE in SQL Server – which should you use?

A practical guide to IDENTITY vs SEQUENCE in SQL Server - what’s different, what matters, and which to use.…

09 March 2026 6 min read

Greg Low in SQL Server

Why disabling the SQL Server sa account still matters in 2026

Disabling the SQL Server sa account isn’t outdated advice. Learn why attackers still target sa and what modern SQL Server...

26 February 2026 5 min read

Aaron Bertrand in SQL Server

How to optimize planned availability group failovers in SQL Server

Learn how to perform fast and predictable SQL Server planned Availability Group (AG) failovers. Discover tips to reduce downtime, optimize...

20 February 2026 15 min read

Edward Pollack in SQL Server

How to Find and Monitor Slow/Long-Running Queries in SQL Server

Learn how to detect long-running queries in SQL Server using dynamic management views and T-SQL scripts to monitor performance in...

16 February 2026 19 min read

Rodrigo Ribeiro Gomes in SQL Server

SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained

Learn about the new CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS commands in SQL Server 2025.…

09 February 2026 29 min read

Lukas Vileikis in Security

How to keep your databases secure in 2026: a complete guide

Learn top strategies for securing your databases against emerging security threats. Discover best practices for access control, encryption, monitoring and...

27 January 2026 10 min read

Aaron Bertrand in SQL Server

How to fix the Invalid Length error in SQL Server

Learn why SQL Server throws the invalid length error in functions like LEFT, SUBSTRING, and RIGHT, and discover practical fixes...

12 January 2026 5 min read

Fabiano Amorim in SQL Server

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 to...

07 January 2026 19 min read

Greg Low in Databases

How to Create a SQL Server Linked Server to Oracle 26ai Free

Easily move data from SQL Server to Oracle 26ai Free with this step-by-step guide. Learn how to set up a...

05 January 2026 4 min read

Rodrigo Ribeiro Gomes in SQL Server

How to View SQL Server Object Code Easily with sp_showcode

Discover how sp_showcode improves SQL Server code viewing compared to sp_helptext, with better formatting, search, and decryption.…

29 December 2025 11 min read

Fabiano Amorim in Databases

SQL Server Privilege Escalation via Replication Jobs

Learn how attackers can exploit SQL Server replication cleanup jobs to escalate privileges from db_owner to sysadmin, and discover practical...

22 December 2025 5 min read

Aaron Bertrand in SQL Server

How to fix the Invalid Object Name error in SQL Server

Learn why SQL Server shows ‘Invalid object name’ errors and how to fix them. Common causes include typos, missing objects...

18 December 2025 6 min read

Steve Jones in Editorials

Evolving SQL Saturday

Steve Jones explains the exciting rebranding of the SQL Saturday events, beginning in 2026 with plans for full integration in...

10 December 2025 4 min read

Greg Low in SQL Server

10 Key Concepts Developers Should Know About the SQL Server model Database

Learn how SQL Server’s model database serves as a template for new databases, including file settings, recovery model, and deployment...

08 December 2025 5 min read

Lukas Vileikis in Databases

Making AI Talk to Your Database: AI-Powered Database Queries Made Simple

Learn how AI-driven tools bridge the gap between human language and databases, making data access faster, easier, and more intuitive.…

04 December 2025 9 min read

Greg Low in SQL Server

15 Practical Tips for Securing SQL Server

15 practical, high-impact steps for securing your SQL Server environment.…

28 November 2025 5 min read