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 [...]
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. [...]
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 [...]
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. [...]
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 [...]
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 [...]
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 [...]
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 [...]
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, [...]
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 [...]
