SQLSaturday #507 - Edmonton 2016
Event Date: 04/09/2016 00:00:00
Event Location:
- Canadian Western Bank
- 10303 Jasper Avenue NW
- Edmonton, 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: How do I create an automated ETL test suite ??
Abstract: There are many automated test frameworks available for different types of applications, but Extract, Transform, and Load (ETL) data movement applications seem to lack an efficient and easy to use automated test framework. We will review how to create automated tests with a data driven approach by showing how the tests self-generate based upon the data in the Information-Model schema in SQL Server and 4 slender custom tables that define the field data mapping between the source and target. The last half of the session will be a demonstration of the tests to illustrate how they execute. To do this we will quickly review the functionality of the tSQLt test framework and the stored procedure code we created that generates the tests. We will review the considerable functionality in tSQLt that makes ETL testing and database testing easy and efficient. We will execute hundreds of tests in the short time during the presentation.
Speaker(s):
- Terry Bunio
Track and Room: Application Database Development - Western Room
Title: Performance Tuning - Analyzing Execution Plans
Abstract: Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations. In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation
Speaker(s):
- Konstantin Melamud
Track and Room: Enterprise Database Administration Deployment - Western Room
Title: Visualization Reporting Options on Microsoft’s Data Platform
Abstract: A lot have changed in terms of Visualization and Reporting on the Microsoft Data Platform in the last year. With the imminent release of SQL Server 2016 product and various Azure offerings innovating on a weekly basis, its hard to keep up with all of the options available to your organization. Let’s step through these options and look at the strengths of each to help you make a more informed choice. This session will be a balance of looking at the product and discussion of the offerings. We will look at features of SQL Server Reporting Services (SSRS) Paginate Reports, SSRS Mobile Reports, Power BI Desktop and the Power BI Services.
Speaker(s):
- Scott Stauffer
Track and Room: BI Information Delivery - Canadian Room
Title: SQL Server Performance Tuning Starter Kit
Abstract: Let me take you on a fast-paced journey through basic database internals, hardware and operating system setup, and how to configure SQL Server, to avoid hearing this most painful sentence for any DBA: “the database is slow”.
I talk quickly, and cover a lot of ground, but don’t let that scare you.
Speaker(s):
- Randolph West
Track and Room: Information Delivery - Canadian Room
Title: T-SQL from Basics to
Abstract: Just getting started with SQL. Want to know more about how to write a select statement ? Ever wondered what a join statement does or how to get your results in a particular order or even how to group them. Then this session is for you. This session covers the basics to advanced of T-SQL query writing.
Speaker(s):
- Craig Millang
Track and Room: Application Database Development - Western Room
Title: Common Coding Mistakes and how to Mitigate them
Abstract: Let the Big Bad Wolf huff, puff and blow your bad queries away.
There are several programming design patterns that work great in object orientated code that do not scale well inside of SQL Server.
In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
After this session, you can go back to your office Monday morning and be the code tuning rock star!
Speaker(s):
- William Wolf
Track and Room: Application Database Development - Canadian Room
Title: Getting Started with Azure Machine Learning (AML)
Abstract: Ever wondered with Azure Machine Learning was and what it can do for you? This introduction to AML that will get you on your way to great analytical models.
Speaker(s):
- Melody Zacharias
Track and Room: BI Platform Architecture, Development Administration - Western Room
Title: Key Note
Abstract: Keynote on SQLServer 2016 new features.
Speaker(s):
- Mohit Gupta
Track and Room: Other - Western Room
Title: backup and restore features in SQL 2012
Abstract: Backup types in SQL Server. Importance of not having a backup strategy and instead having a restore strategy. Backup and restore examples including:
- Full DB backup and Restore
- Filegroup Backup and restore
- File Backup and Restore
- page backup and restore
- Special case scenarios example: restoring master
- Tips on improving performance of backups
Will try to take the audience from a beginner level to intermediate to advanced by giving examples. That way, they can get an idea on different options and ways of backing up and restoring and can use the scripts shown to practice later.
Speaker(s):
- mirza baig
Track and Room: Enterprise Database Administration Deployment - Canadian Room
Title: Optimizing your data warehouse for OLAP Processing
Abstract: Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS as well as enterprise level features within the database engine itself and how aligning them to work side by side would yield us at least 200% improvement in our processing time.
Speaker(s):
- Konstantin Melamud
Track and Room: BI Platform Architecture, Development Administration - Western Room
Title: Migrating SQL Server Quickly and Effectively
Abstract: Have you ever had to migrate a SQL Server Instance from one server to another? Are you a 24/7 shop with a strict maintenance window? Have you ever been asked to migrate 100’s of databases in a matter of minutes to keep the outage as short as possible?
In this session we will look at some techniques that can be used to migrate your SQL instances from one server to another using tools included with SQL Server. We will discuss how these strategies can be used to keep your down time requirements to a minimum and measured in minutes rather than hours.
Speaker(s):
- Ian Chamberland
Track and Room: Enterprise Database Administration Deployment - Western Room
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Terry Bunio
Twitter: - @tbunio
Contact: http://www.agilevoyageur.com
Terry started his career working with Adabas as a DBA., Over the next 20 years, Terry has worked with Oracle, Informix, Sybase, and Microsoft SQL Server as both a Data Modeler and DBA. Terry is a huge proponent of normalization and dimensional modeling.
Terry has implemented Operational Data Stores, Data Warehouses, and ETL solutions for Investors Group, LPL Financial, Manitoba Blue Cross, and others.
Terry has recently worked on integrating Agile practices into Database projects.
Konstantin Melamud
Twitter: - @kmelamud
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
William Wolf
Twitter: - sqlwarewolf
LinkedIn: William Wolf
Contact: http://www.sqlwarewolf.com
Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.
mirza baig
Been a SQL Server Developer since Jan 2000. Been a DBA for 4-5 years now.
Craig Millang
LinkedIn: Craig Millang
Data Migration developer working on CWB Project ARI, I have seen good data, bad data and have had to use quite a few abdominal queries to have data work corporate nicely between two systems.
Favorite feature of SQL Server : CTEs because in order to enjoy recursion you have to enjoy recursion
4 Yrs. of SQL and C# experience
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.
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.
Konstantin Melamud
Twitter: - @kmelamud
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
William Wolf
Twitter: - sqlwarewolf
LinkedIn: William Wolf
Contact: http://www.sqlwarewolf.com
Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.
Melody Zacharias
Twitter: - SQLMelody
LinkedIn: Melody Zacharias
Contact: http://sqlmelody.com
Melody is the Sr. Microsoft Solutions Manager at Pure and has been in love with data since 1991. She has been sharing her passion with the community in technical sessions and blogs since 2014. She has been a Microsoft MVP since 2016, including winning Rookie of the year for Canada that year. This last year, she was elected to the board of directors for PASS.org, the professional association for SQL Server and was awarded Regional Director by Microsoft. She has co-authored 3 books, including, SQL Server 2019 Administration inside out by Microsoft Press.
Ian Chamberland
LinkedIn: Ian Chamberland
Ian has been working as a SQL Server Database Administrator since 2010. He focuses on new implementations of SQL Server environments and improving existing ones. He enjoys working with HA/DR technologies, ensuring performance requirements are met and automating tasks with PowerShell.
Randolph West
Twitter: - _randolph_west
LinkedIn: Randolph West
Contact: https://bornsql.ca/blog/
Randolph West (they / them), founder of Born SQL, is an independent IT consultant, speaker, Calgary PASS user group leader, Microsoft Data Platform MVP, and lead author of “SQL Server 2019 Administration Inside Out”.
Randolph specialises in SQL Server performance tuning, disaster recovery, and migrations from really old versions, with an emphasis on implementing best practices.
Randolph has presented at PASS Summit, SQLBits, SQLSaturdays, and user groups. You can also find Randolph acting and directing on screen or the stage, or annoying people on Twitter.
Do not trust Randolph around chocolate.
Terry Bunio
Twitter: - @tbunio
Contact: http://www.agilevoyageur.com
Terry started his career working with Adabas as a DBA., Over the next 20 years, Terry has worked with Oracle, Informix, Sybase, and Microsoft SQL Server as both a Data Modeler and DBA. Terry is a huge proponent of normalization and dimensional modeling.
Terry has implemented Operational Data Stores, Data Warehouses, and ETL solutions for Investors Group, LPL Financial, Manitoba Blue Cross, and others.
Terry has recently worked on integrating Agile practices into Database projects.
Sponsors
The following is a list of sponsors that helped fund the event: