SSIS multi-environment configuration in a single SQL Server table
Centralize SSIS configuration for multiple environments into one table.
2009-06-03
14,714 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)
534 reads
Blogs
Restoring Backups from Azure Blob with dbatools
Recently I needed to write a PowerShell script that could build a backup set...
Good to see you at Houston Tech Fest 2019!
By Will Assaf
It was awesome to see a great crowd at the triumphant return of Houston...
Using kubectl logs to read the SQL Server Error Log in Kubernetes
When working with SQL Server running containers the Error Log is written to standard...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Trying to create Nested SUM OVER Function for backwards running total.
Here is sample code from my running total, now I need to reverse it...
Copy or Move Shapshot Reports
Hi We have snapshots on an old report that we would like to move...
Ask SSC