Creating a network graph in SQL Server

Over the holidays I have been looking to try out some new concepts in SQL Server and figured I should perform some analysis on all the emails I have received in the last 5 years. The idea started out with me just wanting to know some basic info like the list of companies and employees…

Deploying changes to In-memory OLTP tables almost seamlessly

If you’re looking to implement the in memory OLTP tables in SQL Server 2014, one of the biggest drawbacks for the same is the fact that tables need to be dropped and recreated , they cannot be altered. While the official documentation simply calls this out and stops there. A simple and effective solution is…