Denver SQL User Group Meeting – January 2019
Please join us for the Denver SQL Server User Group meeting!!
January 17, 2019
5:30 – 8:30
7595 Technology Way Suite 400
Denver, CO 80237
5:30 – 6:00 Food / Socializing
6:00 – 6:15 User Group Business
6:15 – 6:30 Open panel/Questions & Answers
6:30 – 7:00 Warmup presentation
7:00 – 8:30 Main presentation
30 minute presentation:
Learning Resources and Accountability Group for 2019
Presented by Todd Kleinhans
Did you make some learning goals for 2019? What are they? Did you know there are a plethora of free, low-cost, and paid ways to learn new SQL Server related technologies? Maybe it is time to learn something new like SQL Server on Linux, Python, PowerShell, a certification or a professional program you are working towards. We will look at several on-line resources. To help you keep on track, Todd will offer to meet with people (up to 25) using his GoToMeeting account once a week. Either remotely as a group or one-on-one to help you stay on track for your learning progress. Todd has started working on the Microsoft Professional Program using Python for both Data Science and Artificial Intelligence.
Todd has been using SQL Server since the last millennium. He has served in different roles across many industries but he’s mainly been a DBA. When not in virtual reality, he likes to speak at PASS sponsored events and volunteers in various groups like PASS, DSSUG as Treasurer, Colorado Virtual Reality and is the President of Denver/Boulder Unreal Engine group.
Why Should I Care About … Partitioned Views?
Presented by Rick Lowe
Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition users who aren’t on MSSQL 2016 yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It’s possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away … and possibly even after 2016 SP1.
Rick is a Microsoft Certified Master with more than 15 years of experience working with SQL Server. He currently works as an independent performance DBA/Developer for clients across the USA and Canada. He started his career as a database developer, but over time became more and more interested in how the database engine operated … eventually becoming more focused on operational and performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.