SQLBits 2020

Practical Azure SQL for the Modern Developer

Come learn how to take advantage of everything Azure SQL can offer to a developer

To steal a quote from Python that perfectly applies here, Azure SQL is “batteries included.” It’s got everything you need. Lots of things have changed from when SQL Server was released to the market decades ago, and even more from when Azure SQL was made available in the cloud. In this session we'll see what Azure SQL offers to the modern developer and how each of the following features can help in reducing application complexity and increasing development efficiency. Along with relational features, an amazing number of post-relational features like JSON and Graph support, columnar storage and in-memory lock-free structures are available to developers to leave to the database the burden to efficiently manipulate and crunch data, so that they can focus on design architectures, implementing the business logic in the most clean and elegant way possible. Having all such features all available for one scalable database is unique in the market. Come learn how to take advantage of everything Azure SQL can offer to a developer

Silvano Coriani's previous sessions

From the Classroom to the Boardroom – Azure SQL DB through Demos

Join us to learn about Azure SQL DB exciting features in form of demos, yes you heard it right, no slide only Demos.

Building SaaS solutions on Azure SQL Database

Azure SQL Database is powering some of the largest SaaS solutions on the planet sporting millions of tenants. It does that through a combination of multiple multi-tenancy models that support different requirements and use cases. from few users to millions. In this session, we'll dig deeper into some examples of real-world architectures implemented by 1st party and 3rd party solution providers like Microsoft Dynamics 365 and others, and see how these can be applied to your own scenarios.

Practical Azure SQL for the Modern Developer

Come learn how to take advantage of everything Azure SQL can offer to a developer

SQL Server in Windows Azure Infrastructure as a Service

Ewan Fairweather and Silvano Coriani from the SQL CAT team will take you on a tour of the new features that make up the Windows Azure Virtual Machines and Virtual Networks running SQL Server 2012 in a Virtual Machine.

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.