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.

In this article, learn how SQL Server triggers can be used for business rules regardless of how the data is inserted, updated or deleted.

Learn how to quickly create a secure SQL Server API with no coding using DreamFactory, featuring automatic documentation and strong security.

When writing T-SQL, a lot of developers use either COALESCE or ISNULL in order to provide a default value in cases where the input is NULL. They have various reasons for their choice, though sometimes this choice may be based on false assumptions. Some th

Strategy Markup Language is an XML-based standard vocabulary and schema for strategic plans. Learn how you can use StratML with SQL Server.

Learn how and why to use RAISERROR in your SQL Server code to better handle errors that may occur during code execution.

In this article, we look at how to use RETURN and OUTPUT in a SQL Server stored procedure to get a return value after execution.

Learn how to Partition an existing SQL Server table with step by step instructions and see how to check the final data distribution.

Learn how to create and maintain a rolling SQL Server filtered index to improve query performance and focus on the most current data.

This article shows ways to replace a SQL WHILE loop with set-based logic to improve SQL Server performance when dealing with a lot of data.

This article describes two approaches to allow you to rank and sort data based on multiple columns in Power BI.

Learn how Melissa for Education is helping students with research projects, cyber security, GIS data, medical research, datathons and more.

Learn how you can setup and configure SQL Server Alerts on Azure SQL Managed Instance with this step by step article.

In this article, we cover SQL code for fuzzy string matching functionality in SQL Server using T-SQL along with several examples.

Learn about the DAX CASE Statement Functionality using IF, SWITCH and SWITCH True with real world code examples.

Import and export SSIS project and open ispac files in Visual Studio to migrate SSIS packages to different servers.

Learn how to create a customizable Power BI calendar date table that can be used for Power BI reports using Power Query.

SQL Server Agent job to execute a SSIS package, failed with message Non-SysAdmins have been denied permission to run DTS Execution job step.

In this article, we cover the steps you can follow to upgrade / migrate from a lower version of SQL Server to SQL Server 2022.