This tip introduces the reader to neural networks and shows how we can use SQL Server and R to codify data, create and train an R-based neural network, store the definition of a neural network within SQL Server for re-use, and create stored procedures whi
Learn how to build a general framework with T-SQL code based on data science practices for assessing if a set of data values conform to any of several commonly used distribution types such as uniform, normal, and exponential distributions.
In this tip we cover ways to improve scalar function performance in SQL Server. Functions are great for repeated use in queries, but there can be a performance impact, learn some ways to improve how functions perform.
This tip includes a couple of goodness-of-fit examples each for normal and uniform distributions. These examples are meant to help you to see how to implement goodness-of-fit solutions with a variety of different distributions and data types.