6:00PM – 6:30PM social
6:30PM – 8:30PM meeting
Proper DataType Usage = Guaranteed Better Performance and Accuracy
It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types.
In this demo-heavy presentation I will show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.
Vern (LinkedIn | Twitter) 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.
SSRS: What’s New in 2016 and Around the Corner in 2017
The 2016 product release was a big upgrade that, once again, brought SSRS into center stage as a market-leading reporting and dashboard design tool for operational and BI reporting. The big news was that SSRS reports truly run in all modern web browsers and work on mobile devices and all desktops in a new modern web portal. The introduction of Mobile Reports, formerly known as Datazen, gives mobile device users interactive, tactile and actionable dashboard style reporting on all the popular mobile smartphones and tablets. The 2017 product brings even more goodness with the integration of Power BI Report Server, on-premises Power BI report integration in a cloud-enhanced or cloud-free platform.
Join Paul for an abbreviated sneak peek of the full-day pre-conference session he will deliver on October 30st the week of PASS Summit in Seattle. You will explore new capabilities and learn to integrate modern reporting into your data platform.
This session covers:
• What’s new in Reporting Services 2017 (and 2016)?
• Reporting Services and Power BI Report Server Architecture
• Parameter improvements
• Power BI integrations
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.