Here are the slides and scripts from my Change Data Capture and Change Tracking Deep Dive talk that I’ve been delivering at various conferences and user groups recently. PowerPoint Presentation SQL Scripts The CT script depends on database setup steps in the CDC, by the way, so run through that one first.
A few years ago, I was working on a project where I needed to calculate the distance between pairs of points on the Earth’s surface. With a bit of research, I found an implementation of the haversine formula written in Python on John D. Cook’s Standalone Numerical Code site. Given a pair of latitude and… Continue reading Earth Surface Distance in T-SQL