DPS Recordings

/DPS Recordings

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 data other than the current row. This means that somethings that may – at first – seem like they need [...]

By |December 6th, 2021|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 for these services, the T-SQL language, is somehow obsolete and not capable enough for the need of the modern analytics. [...]

By |December 4th, 2021|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 analysis. This is a demo-only session where we will take you from 1. Setting up the sensors 2. Streaming the [...]

By |December 4th, 2021|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 simply drag files into a folder and then be able to access their meta-data and contents through SQL Server, seamlessly. [...]

By |December 4th, 2021|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 from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based [...]

By |December 2nd, 2021|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 the Charticulator app Mike Carlo will guide you through how to use and build visuals within the Charticulator app. Learn [...]

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

Reinforcement Learning in gaming by Eva Pardi & Alan Smith

Session Title: Reinforcement Learning in gaming Speaker: Eva Pardi & Alan Smith Abstract: Microsoft uses reinforcement learning in many ways to improve our products and services. AI and machine learning can help accelerate game development by providing more realistic worlds and challenges as well as support automation and live operations. At Game Stack Live, Microsoft [...]

By |November 30th, 2021|DPS Recordings|Comments Off on Reinforcement Learning in gaming by Eva Pardi & Alan Smith

The Data Talks Back: Speech & Language AI for the Data Professional by Matt Gordon

Session Title: The Data Talks Back: Speech & Language AI for the Data Professional Speaker: Matt Gordon Abstract: AI is, was, and will be a part of our world for a long time to come. The Speech and Language areas of Azure Cognitive Services provide powerful opportunities for data professionals to enable richer reporting, create [...]

By |November 30th, 2021|DPS Recordings|Comments Off on The Data Talks Back: Speech & Language AI for the Data Professional by Matt Gordon

Cosmos DB: Jack of All Trades, Master of Many by Daron Yondem

Session Title: Cosmos DB: Jack of All Trades, Master of Many Speaker: Daron Yondem Abstract: How would it look like if you were building a wishlist for an imaginary database; turnkey global distribution, 5 well-defined consistency levels, SLAs across 4 dimensions (High Availability, Performance Latency, Performance Throughput, and Data Consistency), Schema-agnostic automatic indexing, Key-Value, Tabular, [...]

By |November 26th, 2021|DPS Recordings|Comments Off on Cosmos DB: Jack of All Trades, Master of Many by Daron Yondem

NoSQL For The SQL DBAs & Developers by Jean Joseph

Session Title: NoSQL For The SQL DBAs & Developers Speaker: Jean Joseph Abstract: Businesses are quickly moving to NoSQL databases to power their modern applications. Reason is that they are looking for a way to host a relatively unmodified RDBMS schema on a NoSQL database, then optimize it over time. This presentation will show DBAs [...]

By |November 26th, 2021|DPS Recordings|Comments Off on NoSQL For The SQL DBAs & Developers by Jean Joseph