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-05-01
992 reads
T-SQL
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
1,848 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
1,673 reads
Answering Questions On Dropped Columns
Answering a couple of questions from the previous posts about dropping columns.
2026-03-18
1,984 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,682 reads
Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions
Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the key challenges in this field is determining whether a specific location falls within an area of interest. This capability is especially valuable for property and casualty (P&C) insurers, who need to assess their insured property exposure when severe weather events such as tornadoes occur.
2025-03-04 (first published: 2025-03-03)
2,699 reads
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Learn how to configure the service in this article.
2024-06-07 (first published: 2024-05-24)
1,663 reads
2024-03-29
8,884 reads
The difference between BIN2 and Case-Sensitive collations in SQL
Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.
2024-03-15
1,954 reads
Writing SQL Server code with AI using GitHub Copilot
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting plug-in that generates code using AI. The technology is from Microsoft and OpenAI. We will show how to install Copilot, and how to generate SQL Server code (T-SQL) using Copilot. First, we will answer some FAQs about Copilot […]
2024-02-12
13,508 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCU MENARA BIDAKARA Telpon/WA:08137887595
BCA KCU MENARA BIDAKARA Telpon/WA:08137887595.Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt....
BCA KCU KELAPA GADING Tlpn/Wa 0853.7373.7551
Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt. Dasar, 1, 9...
BCA KCP Menara Imperium Telpon/WA:08137887595
BCA KCP Menara Imperium Telpon/WA:08137887595.Jl. H. R. Rasuna Said No.Kav. 01, Guntur, Kecamatan Setiabudi,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers