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.

Ronen Ariely

Ronen Ariely is a senior consultant and architect, in the fields of data platform and application development. He has more than 15 years' experience in variety programming languages and technologies, leading development teams, and software companies, SQL & BI enterprise level solutions. Ronen is active in communities (aka pituach) in the field of Programming, SQL Server, and T-SQL. He serves as Moderator at MSDN and as one of the Microsoft TechNet WIKI communities' leaders. Ronen writes technical blogs, TechNet articles and blogs, and has been awarded as a Microsoft Most Valuable Professional.

Växjö: Ronen Ariely: Azure Elastic Databases & Azure Elastic Jobs