Explore XML extraction techniques in SQL Server 2025. Understand how to work with XML elements and attributes effectively.

Learn how to roll-up multiple rows into one row and one column with concatenation in SQL Server with FOR XML, STUFF and STRING_AGG.

Learn about the JSON_CONTAINS function in SQL Server 2025 and how it simplifies checking values in JSON data.

In this article, we look at a new SQL Server Extended Event to help identify anti-patterns in SQL queries​ and improve performance.

Learn how to get SQL Server to use different indexes to improve stored procedure performance based on parameter sniffing issues.

Learn how you can use an AI image generator tool to generate images based on data stored in a SQL Server database.

Learn how to use Visual Studio Code Polyglot Notebooks to run and preserve SQL scripts as an alternative to Azure Data Studio SQL Notebooks.

Learn how Melissa Personator Consumer and Melissa Personator Identity data verification and enrichment services can achieve high-quality data.

Explore the Ziggurat algorithm for generating Gaussian random numbers efficiently in SQL Server with ease and accuracy.

Learn about different reasons why a SQL Server database can be stuck in a restoring state and how to fix this.

Learn about network ports used for SQL Server, how to find and use the correct port to connect to SQL Server using SSMS or any application.

Explore how to create and use a JSON index in SQL Server to improve query performance for tables that store JSON data.

Learn how to stop, start and restart SQL Server services with Windows Services Manager, SSMS, command line and PowerShell.

Learn about SQL Server triggers and how to use them for inserts, updates, and deletes on a table, along with step-by-step examples.

Learn about update statistics for SQL Server to get a better understanding how important statistics are for optimized query performance.

Melissa Data's Global Email Verification solution delivers valuable and accurate data in real time with an API or in batch with SSIS.

Address SQL parameter sniffing to avoid recurring performance problems using a covering index to solve the problem.

This article shows code with excessive SQL Server deadlocks and ways to fix such as Read Committed Snapshot Isolation and table hints.

Learn how Database Administrators double productivity and minimizing complexities with dbWatch: prioritization, consistency and automation.