Simple SQL: Handling Location Datatypes
How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth system based on the SQL specification of the Open Geospatial Consortium (OGC). However, this is not the only approach, as Joe Celko explains.
We Need DevOps for Performance
CosmosDB has ways to tune performance based on throttle metrics. We probably need some DevOps style feedback and adjustment for relational systems.
What to Do When You Get a “Cache is Out of Date” Error Message
Greg Larsen shows how to fix the “cache is out of date” error message when SQL Server Management Studio starts up.
A well-earned break from the database
Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.
SQL Saturday statistics – Web Scraping with R and SQL Server
Tom wants to check a simple query: How many times has a particular topic been presented and from how many different presenters.
Bones of SQL - The Calendar Table
This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.
Implied Predicate and Partition Elimination
Erik Darling's delighted to see that SQL Server does some creative partition elimination.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCU TANJUNG PRIOK CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Enggano No.22-23, RT.8/RW.16, Tj. Priok, Kec. Tj. Priok, Jkt Utara,...
BCA KCU MANGGA DUA RAYA CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5, Ancol,...
BCA KCP Kramat Jaya CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing,...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers