T-SQL

SQLServerCentral Article

Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions

  • Article

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.

5 (2)

You rated this post out of 5. Change rating

2025-03-04 (first published: )

2,611 reads

SQLServerCentral Article

Manage Elastic jobs in Azure using Azure Elastic Jobs Manager

  • Article

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.

5 (2)

You rated this post out of 5. Change rating

2024-06-07 (first published: )

1,502 reads

SQLServerCentral Article

The difference between BIN2 and Case-Sensitive collations in SQL

  • Article

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.

5 (2)

You rated this post out of 5. Change rating

2024-03-15

1,711 reads

SQLServerCentral Article

Writing SQL Server code with AI using GitHub Copilot

  • Article

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 […]

5 (2)

You rated this post out of 5. Change rating

2024-02-12

12,849 reads

SQLServerCentral Article

SQL Window Functions Series: LAG() and LEAD()

  • Article

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

5 (3)

You rated this post out of 5. Change rating

2023-12-11

8,463 reads

SQLServerCentral Article

GENERATE_SERIES() Breaks Minimal Logging

  • Article

tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]

5 (9)

You rated this post out of 5. Change rating

2023-09-18

3,881 reads

Blogs

Back in the EU

By

I flew to Amsterdam last night and hopefully by the time this publishes I’ll...

The Feedback Multiplier: How Leaders Can Turn Input into Innovation

By

In every organization there is a hidden currency more valuable than capital, more enduring...

SQL Saturday Boston Slides and Code

By

Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...

Read the latest Blogs

Forums

how to use a variable in a CASE statement?

By water490

hi everyone I am getting an error when I add a variable to a...

How to Use SQL Server Features to Cut Web App Latency in Half

By Muhammad Adnan

Comments posted to this topic are about the item How to Use SQL Server...

Choosing an AI in Sept 2025

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Choosing an AI in Sept...

Visit the forum

Question of the Day

The New SQL Server 2025 Data type

In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?

See possible answers