Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 21
tSQLt is a database unit testing framework for Microsoft SQL Server.  tSQLt is ideal for the database developer because tests are written in TSQL and is easy to use.

In this session you’ll learn how to use tSQLt to add automated tests to your database to ensure your code produces desired results even after modifications.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 05

Time: 2:45 PM - 3:45 PM

Room: Canadian Room

Data is today’s currency. Azure Data Catalog (ADC) is a relatively unknown resource in the IT community.  This is an unfortunate state since ADC is an incredibly useful tool that is easy to implement and use. Companies that are able to leverage their data have seen the greatest gains in growth and market capitalization.  The reason for this is simple: We live in the information age.  Being able to leverage the data you gather is the invitation you need just to compete in information age.
ADC is an indispensable tool that helps companies organize and make sense of the mountains of data they collect every day.  By walking participants through an implementation of ADC, I will introduce them to the product, and show how easy it is to use.  By presenting concrete examples of how ADC is used, I will demonstrate its importance. Participants should leave this session determined to introduce ADC to their team and resolute in their intention to implement it within their company.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: May 05

Time: 11:00 AM - 12:00 PM

Room: Alberta Room

Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean. We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favourite: auditing. There's even a bit of In-Memory OLTP. There might even be time for demos!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 05

Time: 11:00 AM - 12:00 PM

Room: Canadian Room

You want Enterprise Edition of SQL Server? Not gonna happen!  When we are limited by having just the Standard version we have to dig into our “Blue Collar” roots, we need to become more creative and squeeze every penny it has to offer out of it.

In this session, we will review some of the limitations that Standard has.  Then review items such as basic normalization and  High Availability options available to Standard.   You will also learn Blue Collar techniques to implement partitioning using techniques like as indexed views and partitioned views.

Let’s dig in and learn to make use of all we have until we beg our bosses enough to get Enterprise Edition!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 05

Time: 1:30 PM - 2: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: May 05

Time: 2:45 PM - 3:45 PM

Room: Alberta Room

Confidence is the fuel for action.  How often have you thought about wanting to do something and thought you may not be successful at it, so it then became too much work to try?  The American Pastor Robert Shuler famously asked a very powerful question: “What would you do if you knew you could not fail?”  Come explore this exciting topic with me, and we will see what we can accomplish together!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 05

Time: 4:00 PM - 5:00 PM

Room: Alberta Room

Now that SQL Server loves PowerShell and Microsoft loves open source, it is even easier to automate even your most time-consuming, repetitive, mundane or burdensome tasks.

Using the DbaChecks PowerShell module released at the SQLBits 2018 conference we can:
    Track SQL Server instance configurations
    Promptly provide required information to managmement, change configuration or developers
    Deftly respond to audit change requirements across your entire estate (and impress your auditor with PowerShell;)
    Restore SQL Servers to their correct state prior and post deployment
    Test *everything* from configuration to permissions, SQL service account share access to sysadmins, Agent Jobs to SPNs
 
This session will look at how to install and use this module . With multiple examples we will look at both running the checks and viewing the data in the supplied PowerBI reports.

Pre-requisites
Some basic knowledge of PowerShell and DBA
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 05

Time: 4:00 PM - 5:00 PM

Room: Western Room

Powershell has been part of Windows for > 10 years and has been part of SQL Server since 2008.
In spite of this the adoption among Database Professionals for use in investigating and managing their environments has been low.

With the release of the open source DBA Tools module from DBATools.IO, with its 300+ commands, the time has arrived for Database Professionals to embrace PowerShell and upgrade their skills to support the modern Hybrid environment.

In this session we will look how to download, install and begin using the power within both this module and Powershell.

No prior experience with Powershell required!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 05

Time: 11:00 AM - 12:00 PM

Room: Western Room

Desired State Configuration (DSC) is PowerShell add-on released with PowerShell 4.5 update and updated with PowerShell 5.0.  In this session we'll look at how DSC can be used to deploy & monitoring for configuration drift using industry standard approach.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 05

Time: 1:30 PM - 2:30 PM

Room: Western Room

This talk introduces DBAs to Object-Relational Mapping (ORM) from the point of view of a software developer creating a simple website.  Aside from introducing ORM I'll explain why developers like to use them, their strengths and weaknesses, and how DBAs and ORM developers can work together in perfect harmony.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 05

Time: 9:45 AM - 10:45 AM

Room: ATCO Room

Legacy corporate applications that are built in-house can quite often be tightly coupled together. Either you have cross database connections, load jobs, linked servers, multiple copies of data, etc. These design patterns increase your technical debt and application changes will need to carefully consider the impact to the downstream applications. Tightly coupled databases can also make migration/upgrade projects more difficult, especially as you start to looking towards cloud based solutions.   
 
What if your organization has started to implement newer design patterns and technologies like microservices, restful web integration or enterprise service buses? Do you have to re-write all of your legacy applications to use these new technologies? 
This presentation will show a method that was used to update legacy applications to utilize an integration middleware platform without a major re-write of the application. We will then expand on this and show how your SQL Server database could
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 05

Time: 2:45 PM - 3:45 PM

Room: ATCO Room

If you're interested in Hadoop but don't know where to begin, this session will give you an idea of what you can do with the open-source platform.  We will see an overview of the Hadoop architecture, becoming familiar with the overall platform and its solutions for warehousing, ETL, streaming data ingest, in-memory processing, and more.  We will compare Hadoop to SQL Server to help gain an understanding of when to deploy which technology.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: May 05

Time: 9:45 AM - 10:45 AM

Room: Canadian 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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: May 05

Time: 4:00 PM - 5:00 PM

Room: Alberta Room

Power BI v1. Started off in Excel. Today Power BI v2 has Excel capabilities, a free desktop app for development, native mobile apps for consuming on all devices, and a cloud service to distribute your data visualizations at scale. Let's look at some common architectures for pieces and how they can deliver value to your business.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 05

Time: 9:45 AM - 10:45 AM

Room: Alberta Room

R is the premiere language for data analysis.  If the world of data science sounds fun and exciting, now is the time to get into R.  We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R.  This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 05

Time: 1:30 PM - 2:30 PM

Room: Alberta Room

Where do you look when you are having performance problems?  What tools you have available?  In this session I'll share with everyone a troubleshooting methodology that can help you identify and focus your search.  In addition, we'll walk through some hands on scenarios to fix performance issues.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: May 05

Time: 9:45 AM - 10:45 AM

Room: Western Room

Optimize SQL Server from the roots. Through demonstrations this session will teach the intermediate user diverse, solid and rounded fundamentals that SQL Server offers. Explore the Master database to retrieve records for improved database administration. Learn how to query the Report Server database for essential information. Use Begin… END with TRY… CATCH: to Drop or Truncate tables with Set Operators. The goal of this presentation is to expose how fundamentals of SQL Server can be applied in ways that may be overlooked and how to enhance query performance optimization. Pick up a trick or two along the way.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: May 05

Time: 2:45 PM - 3:00 PM

Room: Western Room

Enjoy a fun filled adventure through the landscape of data and information security options available within SQL Server as we explore the promises, perils, and pitfalls of CRUD, Data Masking, Row Level Security, Transparent Data Encryption, and Always Encrypted.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 05

Time: 11:00 AM - 12:00 PM

Room: ATCO Room

If you are involved in data warehouse development using the Microsoft technology stack, then you have been introduced SSIS.  The question you will have asked yourself many times as you develop is: "What the #%@ were they thinking?".  This session is dedicated to providing an overview to some of the items that just drive you nutz using this tool in an enterprise environment, and having a laugh while we learn.

From tiny windows designed for a 640x480 monitor, to clicky-clicky-clicky madness, to the tool being anti-agile.  Developing and maintaining code with SSIS is enough to turn your hair gray early.  But it sure looked "snazzy" when your boss got a demo of it, so now it is your problem.

So if you are a seasoned developer come on out and commiserate with the community, and if you haven't used to tool yet you can find out what your boss is asking you to get involved with.

Either way this will be a fun presentation that I am hoping you won't soon forget.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 05

Time: 1:30 PM - 2:30 PM

Room: ATCO Room

Restoring service broker from a live system to a test system can give you strange results.  From messages that refuse to send to messages that appear to send but never arrive.  We will be troubleshooting using SQL profiler and some DMV’s to see what goes on in the background when service broker is misbehaving.  Nothing more worrying than performing a disaster recovery and having service broker messages not send.  We will also be doing a quick overview of what Service broker does and what is required for a service broker setup.  Once we have shown the profiler method of diagnosing problems, I will show a quicker and easier way to find and resolve service broker issues.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 05

Time: 4:00 PM - 5:00 PM

Room: ATCO Room

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