sqlsathistory

Nr: 594

SQLSaturday #594 - Edmonton 2017

Start Time (24h)	Speaker	Track	Title
08:30:00	Rushabh Mehta	BI Platform Architecture, Development Administration	PowerQuery Tips and Tricks for Power BI
08:30:00	Melody Zacharias	BI Platform Architecture, Development Administration	Introduction to Microsoft Analytics – Turning Data into Intelligent Action
08:30:00	Melissa Connors	Application Database Development	To Compress or Decompress—that is this Session
09:45:00	Sepand Gojgini	BI Platform Architecture, Development Administration	Columnstore Index Primer
09:45:00	Warren Sifre	BI Platform Architecture, Development Administration	Introduction to BI Architecture
09:45:00	Olivier Cann	Application Database Development	Tracking Data Changes with Temporal Tables and more
11:00:00	Patrick Flynn	Enterprise Database Administration Deployment	Database Corruption - Advanced Recovery Techniques
11:00:00	Scott Stauffer	Analytics and Visualization	Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!
11:00:00	Ian Chamberland	Enterprise Database Administration Deployment	SQL Server Management Strategies
13:15:00	Mohit Gupta	Enterprise Database Administration Deployment	SQL Server In-Flight Recorder Deep-Dive
13:15:00	Mike Diehl	BI Platform Architecture, Development Administration	Agile Analytics: Automated builds and deployments
13:15:00	Pinal Dave	Enterprise Database Administration Deployment	Performance in 60 Seconds – SQL Tricks Everybody MUST Know
14:30:00	Steve Wake	BI Platform Architecture, Development Administration	Mobile, Paginated, KPIs, and Power BI, Oh My! SSRS 2016 Reporting
14:30:00	Camron Bute	BI Platform Architecture, Development Administration	Building a Successful BI practice
14:30:00	William Wolf	Application Database Development	Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
15:45:00	David Dye	BI Platform Architecture, Development Administration	Creating Dynamic Packages
15:45:00	Chris Wood	Enterprise Database Administration Deployment	Monitoring SQL 2016 on-premise for performance and stability
15:45:00	Steve Wake	BI Platform Architecture, Development Administration	Reports on the Go: SSRS 2016 Mobile Reporting
15:45:00	Randolph West	Cloud Application Development Deployment	Migrating to Azure SQL Database: Tips, Tricks, and Lessons Learned
15:45:00	Dwija Dholakia	Enterprise Database Administration Deployment	Optimizing Query Plans

SessionID: 57449

PowerQuery Tips and Tricks for Power BI

Back to calendar

Event Date: 22-04-2017 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Rushabh Mehta

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.

SessionID: 61396

Introduction to Microsoft Analytics – Turning Data into Intelligent Action

Back to calendar

Event Date: 22-04-2017 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melody Zacharias

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.

SessionID: 62562

To Compress or Decompress—that is this Session

Back to calendar

Event Date: 22-04-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Melissa Connors

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.

SessionID: 59528

Columnstore Index Primer

Back to calendar

Event Date: 22-04-2017 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sepand Gojgini

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.

SessionID: 60992

Introduction to BI Architecture

Back to calendar

Event Date: 22-04-2017 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Warren Sifre

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.

SessionID: 62541

Tracking Data Changes with Temporal Tables and more

Back to calendar

Event Date: 22-04-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Olivier Cann

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.

SessionID: 59385

Database Corruption - Advanced Recovery Techniques

Back to calendar

Event Date: 22-04-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick Flynn

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!

SessionID: 61783

Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!

Back to calendar

Event Date: 22-04-2017 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Scott Stauffer

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!

SessionID: 62520

SQL Server Management Strategies

Back to calendar

Event Date: 22-04-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ian Chamberland

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.

SessionID: 61141

SQL Server In-Flight Recorder Deep-Dive

Back to calendar

Event Date: 22-04-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Mohit Gupta

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?

SessionID: 61255

Agile Analytics: Automated builds and deployments

Back to calendar

Event Date: 22-04-2017 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Mike Diehl

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.

SessionID: 62981

Performance in 60 Seconds – SQL Tricks Everybody MUST Know

Back to calendar

Event Date: 22-04-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Pinal Dave

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

SessionID: 61723

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

Back to calendar

Event Date: 22-04-2017 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Steve Wake

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!

SessionID: 63339

Building a Successful BI practice

Back to calendar

Event Date: 22-04-2017 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Camron Bute

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.

SessionID: 63837

Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Back to calendar

Event Date: 22-04-2017 - Session time: 14:30:00 - Track: Application Database Development

Speaker: William Wolf

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.

SessionID: 56527

Creating Dynamic Packages

Back to calendar

Event Date: 22-04-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Dye

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:

Iterate through all files in a folder and import their content into SQL
Dynamically create and name table based on a data source
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:
```
 Use expressions within SSIS packages
```

 Use variables to dynamically create SQL statements

```
 Configure custom dynamic logging
```

 Use package configurations and parameters and environments to make packages more portable at execution

Replace dynamic SQL using expressions in SSIS

SessionID: 61082

Monitoring SQL 2016 on-premise for performance and stability

Back to calendar

Event Date: 22-04-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Wood

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?

SessionID: 61802

Reports on the Go: SSRS 2016 Mobile Reporting

Back to calendar

Event Date: 22-04-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Steve Wake

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.

SessionID: 63323

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

Back to calendar

Event Date: 22-04-2017 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Randolph West

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.

SessionID: 63338

Optimizing Query Plans

Back to calendar

Event Date: 22-04-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Dwija Dholakia

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.

This site is open source. Improve this page.