2020-04-20
905 reads
T-SQL
2020-04-16
632 reads
2020-04-07
740 reads
2020-03-30
585 reads
2020-03-24
571 reads
Combining many crossing intervals
This article demonstrates how the geometric functions in SQL can be use to solve the Islands and Gaps problem.
2020-03-16
2,594 reads
2020-03-10
892 reads
Gap Analysis Using Algebra
This article shows how to solve a gaps and islands problem using simple algebra.
2020-03-10
5,056 reads
Implementing Date Calculations in SQL
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
6,931 reads
Introduction to STRING_SPLIT function in SQL
This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.
2020-03-02
10,839 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers