Torsdag den 31:a maj välkomnar vi Ronen Ariely som kommer att berätta om Azure SQL Database Elastic Pools. Om du använder Azure SQL Database eller är på väg att migrera din data dit så ska du inte missa den här chansen!

Presentationen hålls i Malmö och vi kommer streama den till Växjö och B3IT:s lokaler i Stockholm också.

Välkommen!

Azure Elastic Databases & Azure Elastic Jobs

A single Azure SQL Database gets dedicated resources within a service tier at a specific performance level. These resources are available in terms of Database Transaction Units (DTUs), which determine the CPU, Memory, and the read-write rates that are available to use. The cost of each database is predefined according to the service tier and resources we choose, even if we do not use full advantage of them.

Azure SQL Database Elastic Pool is a simple solution for managing and scaling multiple Azure SQL Databases as a group. All the Databases in a pool share a set of number resources. Resources available in terms of elastic Database Transaction Units (eDTUs). It's a powerful and a cost-effective option for databases that have varying and unpredictable usage demands.

Using elastic pool, management tasks are simplified by running scripts in elastic jobs, which enables us to execute Transact-SQL scripts across a group of databases. Elastic Database jobs allow us to aggregate data from a collection of Azure SQL Databases into a single destination table/report. It improves performance by reducing the overhead of connecting to each database separately.

During the meetup, we will review the features “Azure Elastic Pools” and “Azure Elastic Database jobs”. We will discuss cases in which can be optimized by using these features, and we will demonstrate how to create & manage Azure Elastic Pool, manage multiple databases inside a pool as individual or as a group, and a quick demonstrate of using of Elastic Database.

Join the meeting to discuss and learn how to improve performance and reduce the cost of your Azure databases.