5 Strategies to Refactor SQL Code

Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality code – yet somehow often gets overlooked in SQL.

How to Query JSON Data Quickly in SQL Server, Part 2: SQL Server 2025

SQL Server 2025 and .NET 10 bring several new improvements to storing JSON natively in the database and querying it quickly.

SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data

Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, GCP CloudSQL and Alibaba ApsaraDB RDS. The cloud vendor acts as the system administrator, managing the operating system, patching, and backups, while the user manages their data and databases.

Random Number Generator in SQL using Marsaglia Polar

How can we build a random number generator using Marsaglia Polar method in SQL Server without the use of external tools?

Learn T-SQL Querying

Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers

• Printed book:
  • US
• Kindle book:
  • US

How to Query JSON Data Quickly in SQL Server, Part 1: Pre-2025

Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to:

SQL Declare Variable Code Examples

This tutorial will discuss using variables with SQL DECLARE along with various examples.

The Version Store Won’t Clear If ANY Database Has Open Transactions.

Short story: what the title says.

JSON Data Extract from SQL Server 2025

JSON is a complex data type used for representing objects with various properties. With JSON you follow the key-value pattern where the key is a string and the value can be of different data types. What are some common ways to work with JSON in SQL Server?

How to Build an AI-Powered T-SQL Assistant with Python & SQL Server

If you’re a SQL Server DBA or developer looking to harness AI for your everyday scripting workflows, this article will walk you through building an AI-powered T-SQL assistant using Python and SQL Server.