Blogs

/Blogs

T-SQL Window Functions by Martin Catherall

Session Title: T-SQL Window Functions Speaker: Martin Catherall Abstract: Window Functions first emerged with the 2005 release and were enhanced in 2012. They provide a window over the result set and the ability to access [...]

By |December 6th, 2021|Categories: DPS Recordings|Comments Off on T-SQL Window Functions by Martin Catherall

Business Analysis with T-SQL by Dejan Sarka

Session Title: Business Analysis with T-SQL Speaker: Dejan Sarka Abstract: No matter if you use SQL Server on premises, Azure SQL Database, or Azure Synapse Analytics, you might have a feeling that the main language [...]

By |December 4th, 2021|Categories: DPS Recordings|Comments Off on Business Analysis with T-SQL by Dejan Sarka

Azure SQL Edge : Real-time analysis of IoT Data by Sourabh Agarwal and Vasiya Krishnan

Session Title: Azure SQL Edge : Real-time analysis of IoT Data Speaker: Sourabh Agarwal & Vasiya Krishnan Abstract: In this session, we will be designing an end to end IoT solution for real time data [...]

By |December 4th, 2021|Categories: DPS Recordings|Comments Off on Azure SQL Edge : Real-time analysis of IoT Data by Sourabh Agarwal and Vasiya Krishnan

Storing and Searching Files in SQL Server FileTables by Sam Nasr

Session Title: Storing and Searching Files in SQL Server FileTables Speaker: Sam Nasr Abstract: FileTables is a SQL Server features that allows easy storage and access to documents dynamically. After some initial setup, users can [...]

By |December 4th, 2021|Categories: DPS Recordings|Comments Off on Storing and Searching Files in SQL Server FileTables by Sam Nasr

Matters Of Concurrency by Louis Davidson

Session Title: Matters Of Concurrency Speaker: Louis Davidson Abstract: OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated [...]

By |December 2nd, 2021|Categories: DPS Recordings|Comments Off on Matters Of Concurrency by Louis Davidson

No Code Custom Visuals in Charticulator by Mike Carlo

Session Title: No Code Custom Visuals in Charticulator Speaker: Mike Carlo Abstract: Learn how to use the most advanced custom visual from the Microsoft team – Charticulator. A Long time fan and massive advocate for [...]

By |November 30th, 2021|Categories: DPS Recordings|Comments Off on No Code Custom Visuals in Charticulator by Mike Carlo