SQL Concat Operator and UNISTR Function in Azure
Explore the concat operator in T-SQL and UNISTR function for handling Unicode characters and managing strings in Azure SQL DB.
Functions
Learn SQL Server functions with practical tips, examples, and tutorials to improve querying and data analysis.
New SQL Regex Functions in SQL Server 2025 and SSMS
In this article, we cover the new SQL regex functions built into SQL Server 2025 and how these can be used in your SQL code.
Script to Create a SQL Time Dimension Table
In this article, we look at using a SQL time dimension table and how to create a time dimension table in SQL Server.
Calculate Difference Between Two SQL Dates as hh:mi:ss or hh:mi
Learn about functions to return time difference for SQL date time format in hh:mi:ss or hh:mi for two different SQL Server date values.
Evaluating the Randomness of SQL Server Random Number Functions
In this tips, we look at how randomness of values for the SQL Server random number functions rand, newid, and crypt_gen_random.
Date Truncation with DATETRUNC() function in SQL Server
Learn how to use the SQL Server DATETRUNC function to truncate date parts to get the exact date interval needed.
Gauss-Seidel Method SQL Function to Solve Linear Equations
Learn how to create a SQL Server function for the Gauss-Seidel method to solve linear equations along with samples to test the function.
Lagrange Interpolation Function for SQL Server
In this article, we look at how to create a user defined SQL Server function for Lagrange Interpolation along with examples.
Basic Regex Emulator for SQL Server
In this article, we look at how to create SQL Server functions to help emulate regex functionality within SQL Server.
SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG
In this article, we learn about two new SQL Server functions to work with JSON data JSON_OBJECTAGG and JSON_ARRAYAGG.
Convert a String to JSON with SQL Server Queries
In this article, we look at various ways to generate JSON formatted data for SQL Server queries using FOR JSON option.
SQL Convert Examples for Dates, Integers, Strings and more
In this article, we look at how to use the SQL CONVERT function to convert between data types such as date, integers, strings, and more.
NTILE SQL Function to Group and Rank Datasets
Learn how to use the NTILE SQL function to group and rank datasets along with practical examples.
SQL Server JSON_PATH_EXISTS Function
Learn how to use the new JSON_PATH_EXISTS function to determine if a specific path in a JSON document exists.
SQL Server ISJSON for valid Value, Array or Object JSON format
Learn about an enhancement to the ISJOSN function that allows you to validate whether the JSON format is valid for a value, array, or object.
Select SQL Server Data Between Two Dates
Learn different ways to select data between two dates using various techniques along with how to improve performance for very large tables.
SQL SUM Function for Aggregating and Summarizing Totals
In this article, we look at different examples of using SUM when aggregating and summarizing totals when working with SQL Server data.
Build a Time Slicer by Week using DAX
In this article, we look at how to build a time slicer by week using DAX for tables that store date data types.
Learn about SQL Date Data Types – Date, DateTime, DateTime2, Time
Learn about the different SQL Server data types to store dates and times such as date, datetime, datetime2, smalldatetime, datetimeoffset, and time.
TRY_PARSE Functionality for SQL Server 2008 to Determine Valid Dates
In this article, we look at code to simulate TRY_PARSE functionality when trying to determine valid dates for SQL Server versions 2008 and earlier.
SQL Calendar Table Simplified using a Table and a View
Learn T-SQL code to generate SQL calendar tables and to auto-create HTML code for formatted tables that could be used in web applications.
Troubleshoot Performance with User Defined Functions in SQL Server
Troubleshoot SQL Server User-Defined Function performance issues using actual execution plans, estimated execution plans, and live query statistics.
SQL Server ROW_NUMBER Ranking Function that Returns a Row Rank Value
This article covers how to use SQL Server ROW_NUMBER() which is a ranking function that returns a rank value for each row in a group or groups.
Generate Events Calendar in HTML with SQL Server and CSS
Learn how to generate HTML calendar event tables using data from SQL Server and CSS to automatically build the calendar visuals.