Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 20
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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 22

Time: 1:15 PM - 2:15 PM

Room: ATCO Room

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: Canadian Room

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 9:45 AM - 10:45 AM

Room: ATCO Room

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:
1.      Use expressions within SSIS packages
2.      Use variables to dynamically create SQL statements
3.      Configure custom dynamic logging
4.      Use package configurations and parameters and environments to make packages more portable at execution
5. 	Replace dynamic SQL using expressions in SSIS
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Room 1

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!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 22

Time: 11:00 AM - 12:00 PM

Room: ATCO Room

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 9:45 AM - 10:45 AM

Room: Western Room

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 8:30 AM - 9:30 AM

Room: Canadian Room

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: ATCO Room

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: ATCO Room

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!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 2:30 PM - 3:30 PM

Room: Western Room

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:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Canadian Room

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Canadian Room

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:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 22

Time: 1:15 PM - 2:15 PM

Room: Western Room

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:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 22

Time: 11:00 AM - 12:00 PM

Room: Western Room

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:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 22

Time: 8:30 AM - 9:30 AM

Room: Western Room

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 22

Time: 3:45 PM - 4:45 PM

Room: Western Room

How to leverage in-flight recorder (Query Data Store) to tune workloads that are performing poorly?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 22

Time: 1:15 PM - 2:15 PM

Room: Canadian Room

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 22

Time: 11:00 AM - 12:00 PM

Room: Canadian Room

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 22

Time: 8:30 AM - 9:30 AM

Room: ATCO Room

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 22

Time: 9:45 AM - 10:45 AM

Room: Canadian Room

Sessions Found: 20
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids