2014-09-29 (first published: 2010-02-04)
9,512 reads
Scripts
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)
9,261 reads
2014-09-25 (first published: 2010-12-23)
26,199 reads
2014-09-23 (first published: 2010-02-17)
11,520 reads
List all permissions in all databases
This script will allow you get all the users and roles with permission on objects on all databases.
2014-09-18 (first published: 2009-03-05)
35,835 reads
Calendar Table by Month
Populate a calendar table with user set interval start and end datetime values.
2014-09-16 (first published: 2014-02-21)
2,123 reads
Calendar Table by Day
Populate a calendar table with user set interval start and end datetime values.
2014-09-15 (first published: 2014-02-21)
2,029 reads
2014-09-12 (first published: 2011-12-22)
3,354 reads
usp_TransposeNRows v2.0
Transpose N rows of a table (v2.0 allows user to specify the table's schema)
2014-09-10 (first published: 2010-01-29)
2,079 reads
Simple Crosstab Procedure with Power
Create crosstab queries as easily as MS Access with a lot more power.
2014-09-09 (first published: 2009-04-02)
4,528 reads
Blogs
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
Forums
Alamat Telp BCA KCP Telepon Kota +62 838-4945-0961
Wa:083849450961 Jl. Ps. Pagi Raya No.9, RT.2/RW.2, Roa Malaka, Kec. Tambora, Kota Jakarta Barat,...
Alamat Telp BCA KCP Semanggi +62 838-4945-0961
Wa:083849450961 Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend. Hilir, Kecamatan...
Alamat BCA KCP Rangkasbitung Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Sunan Kalijaga No.21, RT.2/RW.7, Muara Ciujung Bar., Kec. Rangkasbitung, Kabupaten Lebak,...
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers