The PASS Application Development VG is a developer community with free training and information for developers working with data.

Welcome & Updates

Welcome to the Application Development Virtual Group!
We are delighted to share expert teachings and knowledge with our community. Please join us! There is no cost to join. We offer free training at your fingertips.

Please subscribe to our YouTube channel, connect with us on LinkedIn, follow us on Twitter or reach out to us via email.

View past recordings to brush up on a skill or to learn new skills. Our presenters typically share their presentation content and code examples after the presentation. Presentations are demo heavy for our technical audience of mostly developers.  We welcome novice, expert and no-code developers.  We encourage you to get hands-on with the code examples and share your findings.

Upcoming Events

Lower expenses and improve daily work using Azure Elastic Pools & Azure Elastic Jobs

Wed, Jul 11 2018 19:00 UTC

Lower expenses and improve daily work using Azure Elastic Pools & Azure Elastic Jobs

Let’s assume that you already decided to use Azure SQL Database As A Service, you still have to choose from two pricing models available and three deployment options: (1) Managing each database separately as a single Azure SQL Database with dedicated resources. (2) Managing multiple databases under Azure Elastic Pool. (3) Managing Azure SQL Database Managed Instance. 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 the resources allocated to the pool. Resources available in terms of elastic Database Transaction Units (eDTU) based on DTU pricing model or using vCore pricing model. It can be a powerful and a cost-effective option for databases that have varying or 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 this session, we will review the services "Azure Elastic Pool" and "Azure Elastic Database job". We will demonstrate how to create, manage, and monitor Elastic Pools and multiple databases inside a pool as individual or as a group, using Elastic Job. We will discuss cases in which can be optimized by using these services, and we'll show a Real-life Case Scenario in which using a small trick in design we succeeded to reduce the amount of Resource Units by 90%! Join the meeting to discuss and learn how to improve performance, lower expenses, and improve daily work using Azure Elastic Pools & Azure Elastic Jobs.


Ronen Ariely

Ronen Ariely is a senior consultant, an applications & data architect. He has more than 15 years' experience in variety programming languages and technologies, leading development teams and software companies in enterprise level solutions in the fields of Data Platforms, BI, and developing. Ronen is active in communities (aka pituach) in the fields of Microsoft Azure, SQL Server, T-SQL, and Dot.Net programming. He serves as Moderator at MSDN and as one of the Microsoft TechNet WIKI communities' leaders. Ronen writes technical blogs, TechNet articles and blogs, he is co-admin of Microsoft's blogs "TechNet WIki" and "MSDN Forum", and has been awarded as Microsoft Most Valuable Professional.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids