Monthly Meeting Announcement
This Month’s Speaker : Devin Jaiswal, Microsoft
Devin is a part of a highly skilled architecture team dedicated to delivering a high return on investment for our client’s IT spend in the data platform space. Devin’s rich history in business analytics, management information reporting, IT compliance, and production environment management provides a unique cross section of experience that allows him to assess performance along the entire data delivery chain (source extract, ETL, data modeling, BI reporting, and ad hoc analytics). This ability to address all aspects of the client’s environment provides the increase in business value clients realize from their business intellectual property.
Introducing Azure SQL Database Managed Instance
SQL Database Managed Instance is an expansion of the existing SQL Database service designed to enable database migration to a fully-managed database service, without re-designing the application.
It’s important to note that Managed Instance isn’t a new service – it is a third deployment option within Azure SQL Database, sitting alongside single databases and elastic pools. As part of Azure SQL Database, Microsoft’s fully managed cloud database service, it inherits all its built-in features.
Discount Code to PASS Summit
Thanks to our Sponsors!
Speaker – Jim Donahoe (view bio)
Session – Getting started with Azure SQL Database: What You Need To Know!
Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Register for this meeting
Speaker – Tracy Boggiano (view bio)
Session – Collecting Performance Metrics
Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.
In this session, we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we’ll put it all together in an interactive dashboard for easy visualization.
Register for this meeting
Speaker – Carlos Chacon (view bio)
Session – The Easy Button for Managing Your Lower Environments
Are you tired of getting requests for lower level restores? Do you have any space issues? This session will review the concept of containers and attempt to identify ways we might benefit from this new technology as we support our users.
Speaker – Jamie Wick (view bio)
Session – SQL Restore: Optimizing Your Data Recovery
When disaster strikes, everyone’s immediate question becomes: How long until the system is back online? Whether it’s a single database or the whole SQL environment, time is essential… As everyone waits on the restore to complete.
How long will the restoration process take?
Can it run faster?
In this session, we’ll answer these questions by looking at how to establish and maintain a Restoration Baseline and the options available for performance tuning database restores.