2014-09-29 (first published: 2010-02-04)
9,505 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,249 reads
2014-09-25 (first published: 2010-12-23)
26,159 reads
2014-09-23 (first published: 2010-02-17)
11,509 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,793 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,113 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,014 reads
2014-09-12 (first published: 2011-12-22)
3,345 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,067 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,504 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Alamat BCA KCP Tanah Abang 2 Telp:08218520154
WhatsApp CS 628218520154 Jl. Tanah Abang II No.49 & 51, RT.1/RW.4, Petojo Sel., Kecamatan...
ALAMAT BCA KCU GUNSA 45 Telp:08218520154
WhatsApp CS 628218520154 Jl. Gn. Sahari No.45, RT.7/RW.5, Gn. Sahari Utara, Kecamatan Sawah Besar,...
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers