SQL Developers, Data Analysts, and T-SQL enthusiasts will find it both valuable and fascinating…
You are a database developer for a factory with sensors on the production line that are supposed to report their readings every minute. However, many of them fail to do so often, and now you need to provide management with hourly graphs, and detailed stats. What do you do?
Interpolation is a method of Curve Fitting, and an extremely useful mathematical tool that allows you to “Fill In” missing data points in any series, based on different algorithms.
In this session we will briefly go over the mathematical foundations, and quickly move on to a hard core T-SQL Coding race to solve both proximal interpolations and linear interpolations using different T-SQL coding techniques. We will go through all the logical steps required to solve this, and similar challenges in the future.
This session will be 90 minutes long, and mostly code demos – embrace yourself for the ride!
Why I Want to Present This Session:
I have been speaking about T-SQL and SQL Server for more than 20 years, and found that I’m most passionate about teaching advanced techniques like this one.
I presented before at numerous events, including Tech-Eds, PASS summit, numerous user group and SQL Saturdays, and I can tell you that this is one of my best sessions yet…
The session will be based on a similar one I did for the Silicon Valley Data Platform user group, for which you can find the source files here.