SQLSaturday #607 - Calgary 2017
Event Date: 04/29/2017 00:00:00
Event Location:
- IBM Calgary Building
- 227 11 Avenue SW
- Calgary, Alberta, Canada
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Performance in 60 Seconds - SQL Tricks Everybody MUST Know
Abstract: Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
Speaker(s):
- Pinal Dave
Track and Room: Application Database Development - Room B
Title: Introduction to Unit-Testing in SQL Server
Abstract: It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.
In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.
You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.
Speaker(s):
- Sebastian Meine
Track and Room: Application Database Development - Room B
Title: Secrets of SQL Server - Database Worst Practices
Abstract: “OMG! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. In this session we will focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
Speaker(s):
- Pinal Dave
Track and Room: Application Database Development - Room A
Title: Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!
Abstract: You’ve heard about Power BI, and you’ve seen it, but you haven’t yet rolled up your sleeves and got your hands dirty. It looks like it is really easy, but sometimes it helps to have someone step you through it the first time to help you hit the ground running. We will grab various public data sources, join them together in a model and build an interactive pièce de ré·sis·tance on the visual design surface!
Speaker(s):
- Scott Stauffer
Track and Room: Analytics and Visualization - Room A
Title: Adding Power to the DBA toolkit!
Abstract: Interested in being able to manage, monitor and document your SQL Environment from a single location? Want to be able to produce modern interactive reports and dashboards that can be viewed on both desktop and mobile devices?
By adding a little “Power” to your DBA toolkit you can!
By combining PowerShell and PowerBi with the more traditional DBA tools I will show how to query and document your entire environment and produce rich interactive reports that can be consumed by all levels of your organisation.
This is a constantly evolving Presentation based around latest features in PowerBI and PowerShell
Speaker(s):
- Patrick Flynn
Track and Room: Enterprise Database Administration Deployment - Room A
Title: PowerQuery Tips and Tricks for Power BI
Abstract: In this session, we will first learn how to expose organizational data using the data management gateway to Power BI. We will then look at how to use PowerQuery to acquire and cleanse data from organizational and external sources. As part of the session, we will also look at some tips and tricks to facilitate data acquisition and cleansing.
Speaker(s):
- Rushabh Mehta
Track and Room: Other - Room B
Title: SQL Server In-Flight Recorder Deep-Dive
Abstract: How to leverage in-flight recorder (Query Data Store) to tune workloads that are performing poorly?
Speaker(s):
- Mohit Gupta
Track and Room: Enterprise Database Administration Deployment - Room B
Title: Monitoring SQL 2016 on-premise for performance and stability
Abstract: You have an on-premise instance of SQL 2016 but what-if performance sucks every now and again Have you looked in the plan cache? What to look for in saved plans Keep you plan cache trim Are your indexes being used as you expect? Do you have table/index hot-spots?
Speaker(s):
- Chris Wood
Track and Room: Enterprise Database Administration Deployment - Room A
Title: SQL Server on Linux - The How, the What and the Why?
Abstract: In this Demo Heavy Session we will explore the recently released SQL Server on Linux
Join me as we try to understand questions like? How do we install and run SQL Server on Linux? What is different, what is the same? What may be better? What might be worse? Why would it be useful? What new skills will you need?
The presentation will be based around experience gained in evaluating the Public CTP and will help introduce you into the brave new world of SQL Server on Linux
Speaker(s):
- Patrick Flynn
Track and Room: Enterprise Database Administration Deployment - Room A
Title: Using Models as the Blueprints for Enterprise Data Governance
Abstract: Data governance is becoming increasingly important to corporations who must demonstrate compliance to industry and corporate regulations. This is occurring against a backdrop of continuously evolving technology, an explosion of diverse data sources, and exponential growth in volume. Data professionals are tasked with ensuring data quality, enforcing data security, tracking model changes, and complying with audits. We will discuss a practical, model-based approach to enterprise data governance, with a focus on Master Data Management (MDM).
Speaker(s):
- Ron Huizenga
Track and Room: Strategy and Architecture - Room A
Title: SQL Server Security Enhancements
Abstract: Microsoft SQL Server 2016 introduced multiple new security enhancements that can help make your environment more secure. In this session we will cover these options and brief demo on how they are implemented.
Speaker(s):
- Mohit Gupta
Track and Room: Enterprise Database Administration Deployment - Room B
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Patrick Flynn
Twitter: - sqllensman
Contact: http://sqllensman.com/blog/
Patrick Flynn is a Senior Database Administrator with 10 years experience in large 24 x 7 enterprise environments. He is a certified master for SQL Server and a regular attendee of the PASS Summit.
Has presented at SQLSaturday events in Sydney, Melbourne, Brisbane and Auckland, Edmonton and Calgary, Oslo and Cambridge
Scott Stauffer
Twitter: - @SQLSocialite
LinkedIn: Scott Stauffer
Contact: http://scottstauffer.ca
Scott Stauffer (@SQLSocialite) is very PASSionate about data and enjoys meeting with like-minded data geeks. He started the Vancouver PASS Chapter in 2004. In 2008, Scott was recognized by Microsoft with a SQL Server MVP award. In 2009, Scott started a PASS BI Chapter in Vancouver, and was also at one time the PASS Regional Chapter Mentor for Canada. For over 10 years he has been an independent consultant working with clients to solve their data woes and extract insight from their business data.
Pinal Dave
Twitter: - pinaldave
LinkedIn: Pinal Dave
Contact: https://blog.sqlauthority.com
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
Ron Huizenga
Twitter: - @DataAviator
LinkedIn: Ron Huizenga
Ron Huizenga is the Senior Product Manager for the ER/Studio product family. Ron has over 30 years of experience as an IT executive and consultant in Enterprise Data Architecture, Governance, Business Process Re-engineering and Improvement, Program/Project Management, Software Development and Business Management. His experience spans multiple industries including manufacturing, supply chain, pipelines, natural resources, retail, health care, insurance, and transportation.
Patrick Flynn
Twitter: - sqllensman
Contact: http://sqllensman.com/blog/
Patrick Flynn is a Senior Database Administrator with 10 years experience in large 24 x 7 enterprise environments. He is a certified master for SQL Server and a regular attendee of the PASS Summit.
Has presented at SQLSaturday events in Sydney, Melbourne, Brisbane and Auckland, Edmonton and Calgary, Oslo and Cambridge
Pinal Dave
Twitter: - pinaldave
LinkedIn: Pinal Dave
Contact: https://blog.sqlauthority.com
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
Mohit Gupta
Twitter: - https://twitter.com/sqlcan
LinkedIn: Mohit Gupta
Contact: http://www.sqlcan.com
Microsoft SQL Server PFE for 6+ years; focusing primary on PTO amp; HADR.
Rushabh Mehta
Twitter: - @rushabhmehta
LinkedIn: Rushabh Mehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.
Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Sebastian Meine
Twitter: - @sqlity
LinkedIn: Sebastian Meine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
Chris Wood
Twitter: - ChrisAVWood
He has been an MS SQL DBA since 1997 starting with 6.5. Worked with 7/2000/2005/2008/2008R2/2012/2014/2016 and 2019 during those 23 years. He has attended 14 Pass Summits, 3 SQLCruises and 2 SQLConnections conferences. He has been the Communications Director for EDMPASS chapter since its inception in 2008. Spoken at 6 SQLSaturdays including the keynote at SQLSaturday 710 Edmonton in 2018. Passionate about SQL and educating himself to know more about it. He has migrated systems while always attempting to take advantage of any new features from 7.0 all the way to 2014 and 2016 and now 2019 He has learned and implemented lots of best practices from SQL Server MVPs.
Mohit Gupta
Twitter: - https://twitter.com/sqlcan
LinkedIn: Mohit Gupta
Contact: http://www.sqlcan.com
Microsoft SQL Server PFE for 6+ years; focusing primary on PTO amp; HADR.
Sponsors
The following is a list of sponsors that helped fund the event: