SQLBits 2023
The 10 things every developer must absolutely know about Azure SQL
The engine powering Azure SQL and SQL Server databases has been around for 30 years and has evolved a lot during that time. In this session we'll see many of this "little" but yet incredibly useful features and knowledge bits, with a lot of demos and a lot of lateral thinking.
The engine powering Azure SQL and SQL Server databases has been around for 30 years and has evolved a lot during that time. From a small, simple and fast relational database, to the multi-model, scalable wonder that is today. It's a lot! This also probably means that there are some cool features that you don't know yet and that can instead make a difference for you, making your work more efficient and fun. In this session we'll see many of this "little" but yet incredibly useful features and knowledge bits, with a lot of demos and a lot of lateral thinking.
Speakers
Davide Mauri's previous sessions
The 10 things every developer must absolutely know about Azure SQL
The engine powering Azure SQL and SQL Server databases has been around for 30 years and has evolved a lot during that time. In this session we'll see many of this "little" but yet incredibly useful features and knowledge bits, with a lot of demos and a lot of lateral thinking.
My application is fully concurrent and async. What about the database?
Let's look at how concurrency works inside the database. If you want to create a truly scalable solution, this knowledge is needed as much as knowledge about threads and synchronization mechanisms in your favorite language.
Jamstack Foundations: Building Scalable API from the Ground Up
In this session, we'll see an end-to-end demo of how we can build a Jamstack site in Azure, using Azure Static Web Apps and Azure Functions, and taking advantage of well-known and less known features of Azure SQL that will make you – the developer – productive and efficient as never before. From Graph Models to JSON, from REST to GraphQL, this code-heavy demo packed session will show all you need to build end-to-end modern, scalable, solutions. CI/CD included.
Practical Azure SQL for the Modern Developer
Come learn how to take advantage of everything Azure SQL can offer to a developer
Temporal Snapshot Fact Table
Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.