Additional Articles

SQL Server Change Tracking to Optimize Data Refreshes for Reporting

by Additional Articles

MSSQLTips.com

Change Data Capture (CDC)

You’re a developer responsible for maintaining a SQL Server database used to feed data to Power BI. You realize that some tables don’t have a modifiedDate column and some do. Also, you know the data is updated by the application as well as other processes which makes the modifiedDate unreliable. This is because it may not always be updated when data changes. You need a way to track data changes to ensure only changed rows are updated on reports in Power BI.

2025-12-24

Get ChatGPT’s Advice On Your Queries with sp_BlitzCache.

by Additional Articles

Brent Ozar Blog

First off, I understand if you read the headline and you have a knee-jerk reaction. I totally understand that there are a lot of people out there who hate AI, and believe me, I hate most uses of it. Lots of its advice can be misleading at best, and absolute garbage at worst.

2025-12-22

SQL Server 2025 Product() Function Examples

by Additional Articles

MSSQLTips.com

SQL Server 2025 includes new features and enhancements. In the previous SQL Server 2025 tips, we have explored many new features. Have you explored the new Product() function? If not, this will walk you through the Product() function with several examples.

2025-12-19

15 Practical Tips for Securing SQL Server

by Additional Articles

SimpleTalk

SQL Server security

Securing SQL Server isn’t complicated, but it does require consistent attention to the areas where real risks arise, such as privileges, configuration, encryption, patching, and monitoring. This article outlines 15 practical, high-impact steps you can take to harden your SQL Server environment.

2025-12-17

Query Exercise Answer: Generating Big TempDB Spills

by Additional Articles

Brent Ozar Blog

T-SQL

In last week’s Query Exercise, I challenged you to play some code golf to generate big spills with tiny T-SQL.

2025-12-15

How to Monitor and Optimize Batched Deletion Processes in SQL Server

by Additional Articles

SimpleTalk

Performance and Tuning

Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, but poorly tuned deletes can cause blocking, long-running transactions, and heavy log usage. Learn how to monitor and optimize these processes for smooth, efficient database performance.

2025-12-12

Running SQL Server in Local Containers with VSCode MSSQL Extension

by Additional Articles

MSSQLTips.com

You are a developer using SQL Server for your applications, and you need to quickly setup a local development environment. How can you make sure the environment is OS agnostic, so it can run on any operating system? Let’s see how we can quickly create a local container to run SQL Server using the VSCode MSSQL Extension.

2025-12-10

5 Strategies to Refactor SQL Code

by Additional Articles

SimpleTalk

T-SQL

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.

2025-12-08

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

by Additional Articles

Brent Ozar Blog

Uncategorized

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

2025-12-05

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

by Additional Articles

SimpleTalk

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.

2025-12-03

All authors

Additional Articles

SQL Server Change Tracking to Optimize Data Refreshes for Reporting

Get ChatGPT’s Advice On Your Queries with sp_BlitzCache.

SQL Server 2025 Product() Function Examples

15 Practical Tips for Securing SQL Server

Query Exercise Answer: Generating Big TempDB Spills

How to Monitor and Optimize Batched Deletion Processes in SQL Server

Running SQL Server in Local Containers with VSCode MSSQL Extension

5 Strategies to Refactor SQL Code

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

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

Blogs

Self-Hosting a Photo Server the Whole Family Can Use

Start with the FabricTools PowerShell module

Enterprise AI Operating Rhythm – Top 5 practices for 2026

Forums

Celebrating Tomorrow

SQL Art: I Made a Christmas Card In SSMS

lookup error

Question of the Day

Celebrating Tomorrow