SQLSaturday #594 - Edmonton 2017

Event Date: 04/22/2017 00:00:00

Event Location:

  • Canadian Western Bank Conference Centre
  • 10303 Jasper Avenue NW
  • Edmonton, Alberta, Canada

PDF of Schedule

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).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Creating Dynamic Packages

Abstract: In a perfect world an ETL solution would only have to import data from a single file that always had the same name deliver it to a single already existing table. Unfortunately this case is the exception rather than the rule. How can you use SSIS to:

  1. Iterate through all files in a folder and import their content into SQL
  2. Dynamically create and name table based on a data source
  3. Dynamically create a T-SQL statement at runtime based on run time conditions This session focuses on how to create SSIS packages that can change to meet runtime events dynamically based on the environment. Each attendee will leave with the knowledge and toolset necessary to:
  4. Use expressions within SSIS packages
  5. Use variables to dynamically create SQL statements
  6. Configure custom dynamic logging
  7. Use package configurations and parameters and environments to make packages more portable at execution
  8. Replace dynamic SQL using expressions in SSIS


  • David Dye

Track and Room: BI Platform Architecture, Development Administration - Room 1

Title: Mobile, Paginated, KPIs, and Power BI, Oh My! SSRS 2016 Reporting

Abstract: SQL Server Reporting Services (SSRS) 2016 is getting the biggest update since SQL Server 2005! This session will define and demo each of the SSRS report types are and how they are developed and supported: Mobile (previously DataZen reports), Paginated (SSRS RDL reports), KPIs (new standalone Key Performance Indicators), and Power BI (now Power BI can be managed in SSRS for an on-premises solution). All of these report types can now be managed in SSRS for a single reporting solution.

We will also look at the new SSRS Web Portal (replacement for Report Manager) and how the development environment will change as well. Sometime will also be spent on how to support all of these report types and the impact it will have on IT. If you have been curious about what has changed with SSRS in SQL Server 2016 and you want to be ahead of the curve, this is the session for you!


  • Steve Wake

Track and Room: BI Platform Architecture, Development Administration - Western Room

Title: To Compress or Decompress—that is this Session

Abstract: Data Compression has been available since SQL Server 2008 in the Enterprise Editions, but it’s now available across all editions starting in 2016 Service Pack 1 and worth checking out if you haven’t able to in the past. You know that data compression can help save on storage space, but do you know when it doesn’t? You’ve heard that it can cost additional CPU to use it, but is that always the case, and how much CPU overhead is there really? Do you know how it can improve I/O performance and enhance SQL Server memory usage? In this session I’ll take you through a real-world example and case study to illustrate the benefits and drawbacks of SQL Server Data Compression to not only show you how it works, but more importantly, when it works, and how to determine whether data will compress well, and perform well. You’ll leave this session with the information and checklists needed to figure out how to use data compression in your database.


  • Melissa Connors

Track and Room: Application Database Development - ATCO Room

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


  • Pinal Dave

Track and Room: Enterprise Database Administration Deployment - Western Room

Title: Reports on the Go: SSRS 2016 Mobile Reporting

Abstract: SQL Server 2016 Reporting Services added reporting functionality with a new report type of Mobile. Mobile reports is the new name for the DataZen reports that was a separate reporting solution before Microsoft acquired DataZen a few years ago. Now with SQL Server 2016 Reporting Services the Mobile report type has been integrated into the platform and can be delivered using the SSRS data sources and datasets you have already developed for Paginated reports. In this session we will walkthrough how to create/update Mobile reports using the SSRS 2016 Mobile Report Publisher application and how the Mobile reports are delivered through the new SSRS Web Portal and apps for iOS/Android/Windows. We will also cover the pluses and minuses of developing new Mobile reports with Power BI also working on mobile platforms. There will be plenty of demos and time for questions in this session.


  • Steve Wake

Track and Room: BI Platform Architecture, Development Administration - Western Room

Title: Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Abstract: Like parents having to break up a fight between battling siblings, SQL Server must do the same for conflicting transactions. We call these Deadlocks and they can present a problem to many DBAs. Deadlocks can be minor fights or major issues making SQL Server continually choose a side like constantly quarreling siblings.

To understand how Deadlocking occurs, we must understand what caused the fight . Learning about basic locking and blocking of SQL Server is a great place to start.

By the end of this session you will walk away with the knowledge of how the locking/blocking mechanism works, the basics of deadlocking, and what Isolation Levels are . You will know how these can help or hurt your situation. Finally you will have the power to capture, report, and stop the family fighting.


  • William Wolf

Track and Room: Application Database Development - ATCO Room

Title: Building a Successful BI practice

Abstract: Are you considering a move towards a business intelligence capability in your company? Or perhaps you have tried before to build one and had to abandon it? In “Building a Successful BI Practice”, you will learn what the road to success looks like when you’re building a BI practice, how to get there, and what some of the pitfalls are along the way. DevFacto had a proven track record of helping companies get more value out of their business by building solid foundations on which to quickly deliver value.


  • Camron Bute

Track and Room: BI Platform Architecture, Development Administration - Canadian Room

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?


  • Chris Wood

Track and Room: Enterprise Database Administration Deployment - Canadian Room

Title: Optimizing Query Plans

Abstract: Queries that take 45 minutes aren’t fun for anyone. However, many people don’t know where to start in order to speed things up, and far too often it becomes a regular occurrence in IT departments. In “Optimizing T-SQL Queries”, you will learn the basics of optimizing query plans. You will learn how to examine and understand query execution plans, diagnose missing indexes, and understand the various types of joins available to you in order to get your queries running quickly and efficiently.


  • Dwija Dholakia

Track and Room: Enterprise Database Administration Deployment - Canadian Room

Title: Introduction to BI Architecture

Abstract: There is a ton of buzz in the market about BI, but do we really know what is BI Architecture? We will go over an ideal architecture design and explain the various elements and tools that make up this architecture. We will use the Microsoft BI Stack as a perspective, but architecture can be replicated with various vendor tools.


  • Warren Sifre

Track and Room: BI Platform Architecture, Development Administration - Western Room

Title: Introduction to Microsoft Analytics – Turning Data into Intelligent Action

Abstract: Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business. As data professionals we need to know how these will affect what we do, and how we can use it to help our business and clients. In this session we will take a look at these hot topics and learn how it helps us turn data into intelligence that will lead to actions that drive profits. We will take a look at how Microsoft’s Cortana suite is the central hub for learning and implementing each of these core pieces.


  • Melody Zacharias

Track and Room: BI Platform Architecture, Development Administration - Canadian Room

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!


  • Scott Stauffer

Track and Room: Analytics and Visualization - Western Room

Title: Agile Analytics: Automated builds and deployments

Abstract: Your team must be able to compile and deploy their code at any time so that it can be tested for quality, or rolled out for production use with confidence. Using the build system in Visual Studio Online (or Team Foundation Server), we will look at what is necessary to automatically compile and deploy BI code assets, including SQL databases, SSIS projects, SSAS databases, and SSRS projects.


  • Mike Diehl

Track and Room: BI Platform Architecture, Development Administration - ATCO Room

Title: Columnstore Index Primer

Abstract: Overview of Columnstore indexes introduced in SQL Server 2012 and its evolution through each release. We will explore how data is organized differently in Columnstore and its impact on query performances. We would cover some of best practices when using this new technology and pitfalls to watch out for when designing your system.


  • Sepand Gojgini

Track and Room: BI Platform Architecture, Development Administration - ATCO Room

Title: Database Corruption - Advanced Recovery Techniques

Abstract: Being able to monitor, diagnose and recover from Database Corruption is a critical skill for any SQL Server DBA. In this session we will walk through the techniques required to detect and repair various forms of Corruption Using a number of example corrupted database we will explore how to determine and fix corruption while avoiding some of the common mistakes. Warning: Hex Editors and DBCC Page dumps will be involved!


  • Patrick Flynn

Track and Room: Enterprise Database Administration Deployment - ATCO Room

Title: Migrating to Azure SQL Database: Tips, Tricks, and Lessons Learned

Abstract: Join Randolph West in learning the tips, tricks and lessons in migrating a SQL Server database to Azure, and whether it’s even a good idea to begin with. Short version: it depends.


  • Randolph West

Track and Room: Cloud Application Development Deployment - ATCO Room

Title: Tracking Data Changes with Temporal Tables and more

Abstract: The need to keep track of the ‘what’ and ‘when’ associated with data changes is a common requirement for data driven applications. However, the business requirements for ‘why’ and ‘how’ those data changes are tracked can be very application specific. Fortunately, SQL Server has a few different tools to help us out. In this presentation we’ll look at

  • Temporal Tables
  • Change data tracking
  • Change tracking
  • Triggers and how they can help you keep track of what’s happening with your data over time.


  • Olivier Cann

Track and Room: Application Database Development - Canadian Room

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.


  • Rushabh Mehta

Track and Room: BI Platform Architecture, Development Administration - Western Room

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?


  • Mohit Gupta

Track and Room: Enterprise Database Administration Deployment - Canadian Room

Title: SQL Server Management Strategies

Abstract: With each SQL Server instance that you have to install it can become more challenging to ensure that standards are enforced, best practices are met and every instance is managed effectively. This presentation will describe a strategy and methodology for leveraging the Windows and SQL Server infrastructure to ensure that when deploying new SQL Server instances you can meet your companies standards and make managing multiple instances as easy as possible.


  • Ian Chamberland

Track and Room: Enterprise Database Administration Deployment - Canadian Room


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

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

Camron Bute

LinkedIn: Camron Bute

Camron is an IT professional in Edmonton, Alberta. Currently focused on business intelligence, Camron also has experience with web, SharePoint, and client/server development, giving him an understanding of the various types of systems used in enterprises and how to connect them. Camron excels at teaching new concepts to people not familiar with the material in a way that’s engaging. In his spare time, Camron enjoys dancing, exploring Alberta, and coaching others.

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com

Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.

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.

Melissa Connors

Twitter: - MelikaNoKaOi

LinkedIn: Melissa Connors

Contact: https://blogs.sentryone.com/MelissaConnors/

Special Projects Lead at SentryOne, focusing primarily on performance testing, overhead analysis, and research projects for the SentryOne platform. Leader of Maine PASS. Organizer of SQLSaturday Maine. Dog person. Friend of chipmunks. Reader of books.

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.

Steve Wake

Twitter: - stevewake

LinkedIn: Steve Wake

Contact: http://blog.wakebi.com

Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.

Olivier Cann

Olivier’s first introduction to SQL Server was with SQL Server Compact Edition. He’s since expanded his experience include working with 2005, 2008, 2012 and 2016.

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.

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.

Dwija Dholakia

LinkedIn: Dwija Dholakia

Dedicated, responsible, hardworking, dependable and client-oriented Business Intelligence professional, offering a strong foundation in data warehouse design modeling, ETL (extract, transform, load) using Microsoft Business Intelligence (SSIS, SSRS) for data analysis data Integration concepts.

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

Mike Diehl

Twitter: - @MikeDiehl_Wpg

LinkedIn: Mike Diehl

Contact: http://weblogs.asp.net/miked

Mike Diehl is the practice lead for databases and Business Intelligence at Imaginet Resources, a Microsoft partner with offices in Dallas, Calgary, and Winnipeg. Mike has over 20 years of experience using Microsoft database technologies and is an expert in Agile Analytics, Scrum, Kanban, and Microsoft Team Foundation Server.

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.

Steve Wake

Twitter: - stevewake

LinkedIn: Steve Wake

Contact: http://blog.wakebi.com

Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.

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

Sepand Gojgini

Twitter: - @SwissArmySQL

LinkedIn: Sepand Gojgini

Product Director at Datateam Services, 10+ years of experience designing data warehouse model and ETL engines used globally. Had a chance of working on world biggest relational Data Warehouse at Amazon managing 5+ PetaByte of data with growth 7+ TeraByte daily. Seeking to apply best software development practices to ETL development and streamlining development process.

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.

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.

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.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page