SSIS multi-environment configuration in a single SQL Server table
Centralize SSIS configuration for multiple environments into one table.
2009-06-03
15,377 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)
600 reads
Blogs
Updating my Kubernetes Raspberry Pi Cluster to containerd
There’s been a lot of conversations happening on twitter over the last couple of...
Daily Coping 3 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Homework – December 2020 – Participate in the Advent of Code.
Christmas. Depending on where you live it’s a big deal even if you aren’t...
Forums
Report based on dynamic columns
Hi all, Can anyone help please? I am trying to do the below report,...
There are no SQL Server instances or shared features that can be updated -2017
Hi Please Assist. I am trying to install SQL SERVER CU 22 on SQL...
How can I exclude records from this table?
How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...
Ask SSC