GPX distance and time analysis in SQL Server
In this article we do a comparative analysis of the distance covered by two athletes during a race using the data of their GPX files.
2026-02-09
1,760 reads
Articles
Common Misconceptions About Microsoft Certification Exams
An experienced exam writer explains common misconceptions about Microsoft certification exams, question design, preparation, and real-world expectations.
2026-02-09
How Database Professionals Sent a Million Emails a Day from SQL Server
This is part of a look back at the history of SQL Server Central as a part of our 25-year celebration in Feb 2026. "They want how much?" That was a question I got from Andy one afternoon as we discussed how we were going to manage the growth of SQL Server Central. I had […]
2026-02-06
2,352 reads
How Filters and Sorting can Derail SQL Pagination Performance
In my previous tip, Pagination Performance in SQL Server, I showed how to make SQL pagination more predictable – turning O(n) into O(1). I materialized and cached row numbers to page through instead of calculating them on every request. It wasn’t the whole story, though; real pagination queries rarely get to sort without filtering. Users always want more control, and filtering can threaten that predictability.
2026-02-06
Tame Those Strings Part 6 - Bending Results
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
2026-02-05 (first published: 2001-07-04)
8,965 reads
Tame Those Strings Part 8 - Quoting
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
2026-02-05 (first published: 2004-03-25)
9,115 reads
Tame Those Strings Part 9 - Dynamic SQL
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
2026-02-05 (first published: 2002-04-04)
7,712 reads
2026-02-04 (first published: 2026-02-03)
107 reads
Tame Those Strings Part 1 - Using SUBSTRING
In this article by Steve Jones, he shows you how to manipulate strings.
2026-02-04 (first published: 2004-04-05)
17,851 reads
Tame Those Strings! Part 10 - Finding Carriage Returns
Expanding on his series of string manipulation in T-SQL, Steve Jones takes a look at how you go about removing those unseen characters from your strings.
2026-02-04 (first published: 2007-02-13)
12,972 reads
Blogs
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
T-SQL Tuesday #200 - I Bet It's Bad if I See...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Developer edition cannot connect from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
ALAMAT BCA KCU PONTIANAK TLP/WA 08218200174
Telp Cs:(0821)8200174 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota...
ALAMAT BCA KCU TANJUNG PANDAN TLP/WA 08218200174
Telp Cs: (0821)8200174 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten...
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers