I am beyond grateful for the 2 incredible speakers that SQLSaturday in Lisbon shall be hosting on 21st of September 2018 for the whole day workshops. We were absolutely privileged to have received their submissions (and we have had a good number of other incredible speakers), and their offers the org team simply was not able to refuse.
Using Query Store to Easily Troubleshoot and Stabilize Your Workload
Given the importance of the Query Store (for on-premises SQL Server and the Azure SQLDatabase & Azure SQLDatabase Managed Instances for that matter), receiving the workshop proposal by none-the-less Erin Stellato was a kind of gift for us. A gift that one simply can not ignore. Erin is a brilliant specialist and her courses (live & online) always attract very high attendance numbers.
Erin is a Principal Consultant with SQLskills. Erin discovered a passion for all things data while completing her M.S. in Motor Control at the University of Michigan. As she entered the IT field, she discovered the power of relational databases. During her IT career, Erin has worked closely with customers, users and colleagues to support business solutions across a variety of industries including healthcare, insurance, finance, and government. These experiences provided opportunities to see varied implementations, troubleshoot hardware and software-related problems, give guidance on configuration and design, and provide consultation on optimization, availability, and recoverability. As a result, Erin’s interests include Internals, Statistics, Performance Tuning, Extended Events, and developing HA/DR solutions. More than anything though, she likes to know how SQL Server works, so she can fix it when it breaks.
If you are not following her on Twitter, read her blog posts or have ever listened to one of her Pluralsight courses, or for that matter attended one of the SQLSkills trainings with her – YOU DEFINITELY SHOULD !
Here are the content’s preview for Erin’s workshop:
– Have you upgraded to SQL Server 2016 or higher, but still have databases using the old Cardinality Estimator?
– Do you know that you have queries with inconsistent performance, but you’re just not sure how to find them, or fix them, quickly?
– Are you tired of flailing around in SQL Server, querying DMV after DMV to figure out the *real* problem with performance?
Query Store can help.
We’ll cover Query Store end-to-end in this full day workshop built using real-world examples based on customer issues resolved over the last two years. You’ll understand how to configure it, what data it captures, and how to use it to analyze performance, find regressions, and force plans. The demos will teach you how to find common patterns in query performance using T-SQL, and how to understand your workload.
This class is applicable for those running SQL Server 2016 or higher (or planning to upgrade), or Azure SQL Database, and will provide practical and applicable information you can use whether you’re a
new or veteran DBA, a developer that has to troubleshoot query performance, or an application administrator just trying to keep the system afloat. You’ll learn how to find and leverage important information in Query Store to make solving common performance problems easier the moment you walk back into the office.
Sign up for the Using Query Store to Easily Troubleshoot and Stabilize Your Workload now!
Azure Analysis Services in a day
Gabi Münster needs no introduction to the regular attendees of the SQLSaturday Portugal. She has presented a number of times in Lisbon and in Oporto’s editions, and her sessions over the year has enjoyed an ever-increasing popularity. This time she is coming back with a complete hands-on workshop for the Azure Analysis Services, which is called “Azure Analysis Services in a day” and shall help everyone starts working with Azure Analysis Services right away, besides making the existing Analysis Services professionals learning how to make the best out of this cloud platform on Azure.
Gabi Münster is working as a Business Intelligence consultant and teamlead and brings in her experience with SQL Server, data warehousing, relational and multidimensional database design and implementation, report and dashboard design, Master Data Services as well as project management into the community as a regional chapter lead. She also is passionate about motivating other women to start a technical career and therefore initiates and supports “Women in Technology” events. Apart from SQL Saturdays she also spoke at SQLBits, SQL Nexus, Tuga IT and 2015’s and 2017’s PASS Summit. In October 2017 Gabi received her first Data Platform MVP award.
The content of the workshop is described below:
You are already using SSAS Tabular mode and are interested in moving into the cloud? Or Tabular Mode is on your roadmap and you are not sure if cloud or on-prem is the right strategy for you? Then this full day workshop could be useful. This hands-on day will give you a first insight into possibilities as well as challenges. We will cover the following topics:
- Overview over the current feature set
- Discussion of strengths and weaknesses from a strategic perspective (e.g. calculating a business case, comparison to Multidimensional and Power BI)
- Create your own Azure Analysis Services Instance
- Import an existing tabular model
- Install and register an on-premise gateway for a local data source
- Integrate the model into a corporate BI landscape
- Look into possibilities for maintenance and automation
While there is no blog that Gabi leads, make sure you are following her on Twitter!
Given that the number of available places is quite limited, sign up for Azure Analysis Services in a day – by Gabi Münster now! (and do not forget to bring a laptop for accompanying the hands-on labs!).
So yes, we have all-female speaker workshops lineup for this year’s SQLSaturday Portugal edition – and even though it happened by a pure chance, we are so happy to have it this way!
Sign up for those 2 amazing workshops and sign-up for our main event on Saturday, 22nd of September 2018!