SSIS multi-environment configuration in a single SQL Server table
Centralize SSIS configuration for multiple environments into one table.
2009-06-03
15,156 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)
591 reads
Blogs
Daily Coping 5 June 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing
I’m working on a project where it’s useful to automate environment setup and teardown...
SQL Server Authentication
By Rohit Garg
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...
Forums
Maximum number of users that can simultaneously log in SQL 2016
Hello, By default, SQL Server allows a maximum of 32767 concurrent connections which is...
Attunity Oracle Connector Not Showing Up in SSIS Toolbox
I've just about exhausted every effort I can research and absolutely cannot get the...
Covert a string to simple sql datetime format
Can anyone help me out here. I need to convert strings in a file...
Ask SSC