IoT Smart Grid code sample
--------------------------------
This code sample demonstrates how SQL Server 2016 memory optimized databases could be used to ingest a very high input data rate and ultimately help improve the performance of applications with this scenario.
The code simulates an IoT Smart Grid scenario where multiple IoT power meters are constantly sending electricity usage measurements to the database.

-- Applies To: SQL Server 2016 (or higher) Enterprise / Developer / Evaluation Edition, Azure SQL Database
-- Key features:
    - Memory Optimized Tables and Table valued Parameters (TVPs)
    - Natively Compiled Stored Procedures
    - Clustered Columnstore Index (CCI)
    - Power BI
-- Programming Language: .NET C#, T-SQL
-- Authors: Perry Skountrianos [perrysk-msft]

To run the sample, follow these steps:
1. Create a database with the name: PowerConsumption
2. Run the script setup-or-reset-demo.sql to create the DB Objects
3. Start the DataGenerator (WindowsForms: Client.exe OR Console: ConsoleClient.exe)application DemoWorkload.exe
4. Change the connection string in the configuration settings, if needed. By default, it points to the local default SQL Server instance with integrated authentication.
5. Load the Power BI Report (WindowsForms: Click on the lower left link, Console: Type REPORT)

An alternative way to run this demo leveraging Visual Studio Database Project deployment is documented here:
https://github.com/Microsoft/sql-server-samples/tree/master/samples/applications/iot-smart-grid#run-this-sample

For any feedback on the sample, contact: sqlserversamples@microsoft.com

--------------
Source code:
https://github.com/Microsoft/sql-server-samples/tree/master/samples/applications/iot-smart-grid#sample-details
License:
https://github.com/Microsoft/sql-server-samples/blob/master/license.txt