Shard Attack - Horizontal Scaling in Azure SQL Database with David Postlethwaite

Traditionally, when a server starts to reach its limit we have simply thrown more resources at it, either more CPU, memory or disk. However there comes a point, especially in the cloud, where it is no longer possible to add more resources to a single database. Here we need a different solution. Instead of scaling up we must scale out, sometimes called horizontal scaling or sharding. In this talk we will look at how to scale out in Microsoft Azure SQL database using the Azure Elastic Database tools We will look at the requirements and options for horizontal scaling in Azure and then we will have a go at sharding an Azure SQL database and then querying and updating the different shards. We will be using t-sql, PowerShell and c# so come prepared for some serious coding.

David Postlethwaite
David Postlethwaite has been a DBA for Liverpool Victoria in Bournemouth, England since 2008 He supports both Oracle and SQL Server from 2000 to 2017, DBMS, SSIS, SSAS and Reporting Services. In 2015 David built and deployed the company's first cloud solution using Microsoft Azure SQL Database and web services Before becoming a DBA David was a .NET developer and way back in history a Windows and Netware administrator. He is an occasional blogger on www.gethynellis.com David is a regular speaker for SQL Saturday. Most of his presentations can be found on his YouTube channel davidpostlethwaitesql

• #science_technology
• #microsoft
• #azure
• #cloud
• #sqldb
• #sql_server
• #sharding
• #scaling
• #performance