CROSS APPLY Fundamentals: Part 1
Learn the basics of the CROSS APPLY operator with a few examples in this short piece.
2026-07-27
735 reads
T-SQL
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
This article shows how the TRY_PARSE() and TRY_CONVERT() functions can be used to handle data quality issues and ensure that your software continues to function without throwing errors.
2026-07-13
3,289 reads
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Learn about an alternative strategy for avoiding hardcoded literal values in SQL Server queries by using single-row views designed to mimic enum behavior.
2026-06-26
2,818 reads
Understanding SQL Server PARTITION BY with Examples
Introduction When developers first learn SQL aggregation, they usually start with the GROUP BY clause. It works well for summary reports because it combines multiple rows into a single result for each group. For example, you can calculate total sales per region or average salary per department. The limitation of GROUP BY appears when you […]
2026-06-05
3,935 reads
Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now
SQL Server 2022 brought powerful new T-SQL functions that eliminate long-standing workarounds. This article walks through five of the most impactful additions — GENERATE_SERIES, GREATEST/LEAST, DATE_BUCKET, the WINDOW clause, and IS NOT DISTINCT FROM — with practical code examples you can use immediately.
2026-05-29
6,559 reads
Understanding Deadlock Victim Selection in SQL Server
A short introduction to how deadlocks work and how you can affect their behavior inside your system.
2026-07-13 (first published: 2026-05-01)
2,861 reads
T-SQL Trigonometric Functions in SQL Server
Introduction SQL Server includes several built-in mathematical functions that allow developers to perform complex calculations directly within queries. Among these are trigonometric functions such as SIN(), COS(), and TAN(), which are useful in scenarios involving engineering calculations, geographic data processing, simulations, and analytics. Although these functions are straightforward to use, developers occasionally encounter unexpected results […]
2026-04-29
2,361 reads
Creating a Simple and Flexible Random Password Generator in SQL Server
Generating temporary passwords is a common requirement in many applications. Users may need to reset a forgotten password, new accounts may require an initial password, or developers may generate test credentials. While password generation is often implemented in application code, doing it directly in SQL Server provides clear advantages. It centralizes the logic, ensures consistency […]
2026-04-10
2,067 reads
Answering Questions On Dropped Columns
Answering a couple of questions from the previous posts about dropping columns.
2026-03-18
2,055 reads
Elements of the SQL Server Update Statement
Learn how to use the UPDATE statement, along with a few things to be aware of when changing data.
2025-04-11
1,787 reads
Blogs
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Forums
Alamat Kontak Bank BCA KCP Riau Telp:08218154392
WA CS (08218154392) Jl. Laks Jl. L. L. R.E. Martadinata No.92, Cihapit, Kec. Bandung...
Alamat Kontak Bank BCA KCP Banda Telp:08218154392
WA CS (08218154392) Jl. Banda No.39, Citarum, Kec. Bandung Wetan, Kota Bandung, Jawa Barat...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers