SSIS multi-environment configuration in a single SQL Server table
Centralize SSIS configuration for multiple environments into one table.
2009-06-03
15,489 reads
Scott Coleman
Calculate distance between two points
The calculation of distance between two points using standard spherical geometry can be inaccurate for short distances (ten miles or less) because the sine function of very small angles approaches zero. The haversine approach (http://en.wikipedia.org/wiki/Haversine_formula) turns this around, so it is very accurate at small distances but has larger errors (about ten miles) for points […]
2006-05-18 (first published: 2006-04-25)
606 reads
Blogs
Daily Coping 4 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from...
Daily Coping 3 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Installing missed items in SQL Server
Hi, Someone, prior to me, installed SQL Server 2019. and missed a few things...
Redesign of old Table
Hi, I am working on an old database table which stores emails, including From,...
Deploy SSIS Package Error: "The selected folder does not contain package..."
Hi All It seems TFS is not behaving itself! When I deploy a package...
Ask SSC