For this meeting, we’ll be presenting previews of the three SQL Mastery precons from the upcoming SQLSaturday Oregon.
SQL Powershell – Episode IV: A New Hope
Aaron will be presenting the section from his precon on what’s new in SQL PowerShell 2016.
Aaron Nelson ( blog | twitter ) is a Consultant with SolidQ with over 15 years of experience in Architecture, Business Intelligence, Development, and Performance Tuning of SQL Server. He was recently awarded a 6th Microsoft MVP for SQL Server (Data Platform). Aaron holds certifications for MCITP: Business Intelligence Developer, Database Administrator, & Database Developer.
This year, the PowerShell VC of PASS set out to “Make SQL PowerShell Great Finally” and it is well on its way. Along with PowerShell MVP Chrissy LeMaire, Aaron helps organize what the community is asking for in the new SqlServer PowerShell module on the community Trello board (sqlps.io/vote). Thanks to these efforts and the countless contributions from the SQL community around the world, we have already received 25 new PowerShell cmdlets and have been told to expect even more new cmdlets every month!
T-SQL For Accuracy and Performance
In this chapter, we will be discussing both the data cache and the plan cache. I’ll demonstrate how the data cache helps performance, how the plan cache helps performance, and how the plan cache can hurt performance. Parameter sniffing can result in sub-optimal performance based on the plan currently in cache, but how do you know what plans are currently in cache? I’ll demonstrate a simple way to see what plans are currently in cache, and show one way to control those plans to eliminate the poor performance that can be caused by parameter sniffing.
Vern (LinkedIn) is an independent SQL Server consultant and contract trainer in Portland, OR. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been working with databases since 1992, and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server skills gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts.
Mastering Power BI Solutions
Paul will be joined by Rachel Dyer and Brian Grant and will present an overview of what is possible and the types of solutions that can be architected with Power BI, using various integration and deployment modes. He and his colleagues will briefly discuss how queries are constructed and managed, and how calculations are processed. He will discuss how Power BI is used in self-service and large-scale solutions.
Paul (Blog | LinkedIn | Twitter) is a Mentor with SolidQ and a Microsoft SQL Server MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to visualize and deliver critical information to make informed business decisions. He is a Director of the Oregon SQL PASS chapter & user group, the lead author of Professional SQL Server 2012 Reporting Services and 13 other titles from Wrox, Packt & Microsoft Press.
Refreshments graciously provided.
Featured Sponsor: RedGate
Visit our website for more details.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.