Calculate Distance in Miles from Latitude and Longitude
A fast and accurate way to calculate the distance in miles between two points, based on the latitudes and longitudes.
2014-09-26 (first published: 2009-01-31)
8,594 reads
Table Information View -- No Cursors!
Row counts and storage space information for all tables in the database. (SQL Server 2005).
2013-12-26 (first published: 2008-03-16)
16,731 reads
Find all objects in Server Owned by a Login
Find every object in every database owned by a particular Login.
2011-09-27 (first published: 2008-07-07)
9,542 reads
EXECute SQL Commands over entire sets of parameters!
A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.
2010-03-16 (first published: 2010-03-04)
2,883 reads
Blogs
Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors...
SQL Server Quickie #45 – SQL Server Availability Groups
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking...
Daily Coping 21 Mar 2023
By Steve Jones
Today’s coping tip is to listen to a piece of music without doing anything...
Forums
Counterfeit Euro Bills
These are the most ordered Fake money for sale in the world. Clients interested...
How much RAM in an Azure Database on Pay As You Go
Ive been doing some benchmark testing using an application, running this on my local...
Ask SSC