Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 41
Ever feel like you are just doing busy work while creating new SSIS packages?  Feel like you are doing the same thing over and over while changing the names to protect the innocent?  Ever wonder if there is a better way?  Well wonder no more.  Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors.  Come with intrigue and leave with a fundamental understanding of BIML!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: March 17

Time: 2:30 PM - 3:30 PM

Room: 202 (34 seats)

Abstract: Azure Data Factory version 2 is really exciting, number one it can run SSIS in the cloud! Yes no more on-prem deploy to SSIS! Deploy from VS or SSMS directly to you cloud based SSIS instance.

Joe Barth will walk your through what is new and what is available to do with ADFv2.
His presentation will also show what we have learned so far as an early adopter and how to run Azuure SSIS in the cloud.

Speaker Bio: Joe Barth is the AZSSUG PASS chapter Leader, over 9 years SQL Server experience from DBA to Developer. Joe's main focus over the past 5 years has been SSIS and Data Warehousing.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 17

Time: 2:30 PM - 3:30 PM

Room: 206 (30 seats)

Cloud Migration
Big data to Big Memory 
Quick review of using a Azure SQL Warehouse to preform a system Cloud Rearchitect
Rehost - Refactor - Rearchitect (move logic but use Cloud resources to execute) - Rebuild
Hadoop Decommision Effort - Hadoop 16hr process replaced with 1.5 hr process at at fraction of the cost
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Advanced

Session Code:

Date: March 17

Time: 10:00 AM - 11:00 AM

Room: 107 (38 seats)

A introduction to key concepts for improving Query Performance in SQL Server. We will cover the basics of the optimization engine, how to read execution plans, and potential pitfalls/anti-patterns to avoid.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 17

Time: 11:15 AM - 12:15 PM

Room: 203 (38 seats)

Accessibility is catering for your whole audience, including those with disabilities. According to the US Census Bureau, 19 percent of the of the population had a disability in 2010. Do you know if your reports are designed in an inclusive way such that everyone can use them? This can be especially important if you are making reports for government entities, educational institutions, or the general public. In this session, we'll discuss accessibility standards and regulations of which you may want to be aware, how users with disabilities can consume Power BI reports, and guidance and pitfalls when designing inclusive reports.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 17

Time: 1:15 PM - 2:15 PM

Room: 203 (38 seats)

This session dives down and looks at the important items on data pages of clustered, non-clustered, and unique non-clustered indexes using the DBCC Page command. It will also look at the effect of row data compression on clustered and non-clustered indexes. In all demos we will try to ascertain how the SQL Server® optimizer might use them and also strive to gain some insight from a performance advantage.  Its purpose is mainly to try and understand how SQL Server implements indexes, their underlying structure, and where performance benefits might lie from a layman’s viewpoint.  Session is 80% demos.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 17

Time: 1:15 PM - 2:15 PM

Room: 204 (30 seats)

Go beyond the buzzwords and let’s get real about how you can transform your company as a data professional. Adam will walk you through the major areas of business that you can help transform, as well as provide you with tips on how to gain influence within your organization by leading this change. You’ll leave with 5 specific steps that you can implement immediately to improve your company’s data culture.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: March 17

Time: 11:15 AM - 12:15 PM

Room: 107 (38 seats)

A theoretical discussion on two methods that professional data modelers use to model data (ERD and star schema). 

We discuss why we need to model data, benefits / value of modeling data, and why we select one modeling technique over the other. Once we understand why and when we use these different modeling techniques, we will focus in on dimensional modeling that is used when developing data warehouses, SSAS cubes and Power BI. 

Sample diagrams will be used to explain these different modeling techniques and try to bring a more tangible aspect to the theoretical aspects of the discussion.

Why Model Data
•	The Value of Enterprise Data
•	Why Should We Data Model
•	The Multifarious Data Environment
•	Business Benefits of Data Modeling

Different Model Types
•	Enterprise Model 
•	Conceptual Model 
•	Logical Model 
•	Physical Model 
•	Dimensional Model

Different Modeling Techniques
•	Normal Form Modeling
•	Star & Snow Flake Schema
•	Slowly Changing Dimensions
•	Many to Many Relationships
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: March 17

Time: 10:00 AM - 11:00 AM

Room: 102 (36 seats)

As more enterprises adopt Power BI into their BI environment, questions still remain about data security when working with the Power BI Service. During this webinar, we will handle a number of these concerns and point out shortcomings that still exist. How does Power BI Premium impact security? (Hint: It’ not just about licensing). We will also take a closer look at auditing, App Workspaces, and Power BI Apps during this session. 

Due to the frequent changes to Power BI, improvements to data security are common within the platform as it matures. We will discuss data security and compliance within the platform including data classification, privacy levels, and other settings which help to manage your data security.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 17

Time: 10:00 AM - 11:30 AM

Room: 202 (34 seats)

The goal of this presentation is to introduce attendees to D3.js, Javascript's premiere library for data visualization.  I’ll showcase prominent examples of D3.js in action (e.g. NYTimes, Netflix, etc.), explain how it works and where it exists in the ecosystem of data visualization tools, as well as walk through the creation process and iterative design of a data visualization via a live-coding demo.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: March 17

Time: 3:45 PM - 4:45 PM

Room: 105 (38 seats)

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. 
Mashups using data from partners, commercial and public sources are fast becoming the new normal.
Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening?
Need to determine the quality of a file downloaded from the internet or supplied by another party?
In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 17

Time: 2:30 PM - 3:30 PM

Room: 204 (30 seats)

There may be resume generating events on the horizon. Find out what trends are happening in our industry that are likely to impact the world of the data professional. Machine Learning, autonomous databases, cloud, OH MY! Are they all really scary? Let's have a discussion and separate the hype from the probable.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 17

Time: 2:30 PM - 3:30 PM

Room: 107 (38 seats)

Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed.  Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query.  We will also see how to use Dynamic SQL to build multiple databases across servers, alter a single table in multiple servers and add columns to a table, all through the magic of Dynamic SQL.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 17

Time: 2:30 PM - 3:30 PM

Room: 102 (36 seats)

ETL (Extract, Transform and Load) is the backbone of any data project and can be upwards of 70% or more of the effort. The tools you have access to allow you to make progress in a hurry. However, are you implementing best practices and techniques that will scale to the demands you need? Or will you be refactoring far too quickly than you should to meet performance requirements?

Gain helpful insights from decades of lessons learned and walk away with best practices you can implement in your own ETL solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: March 17

Time: 2:30 PM - 3:30 PM

Room: 105 (38 seats)

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 17

Time: 1:15 PM - 2:15 PM

Room: 205 (38 seats)

SQL Server 2016 added R to the analytical toolset and SQL Server 2017 has added Python.  When looking at various lists of the most popular programming languages, Python always has one of the top positions.  This session provides an introduction to Python, including why it is a good choice for analyzing data.  
If you have not had a chance to review SQL Server 2017 yet, please attend to see some of the new changes coming later this year.  One of the features covers will show what is needed to incorporate Python into SQL Server and how Python can be incorporated in stored procedures to provide the ability to analyze data using arguably the most popular programming language to review data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: March 17

Time: 11:15 AM - 12:15 PM

Room: 102 (36 seats)

How do I test my Microsoft SQL database logic? How do I integrate it with my build? What's the point of testing T-SQL, anyway? 

If you've ever had these questions, this introduction to the unit test framework, tSQLt, is for you. We'll address how to set up and run unit tests, fakes, and spy procedures. We'll also talk about how to structure your Visual Studio projects that use tSQLt, whether they're SSDT projects or the new ReadyRoll Core project type, available with Visual Studio 2017.  You'll learn how to integrate your tSQLt tests with the CI/CD pipeline using Visual Studio Team Services, as well as how to analyze code coverage.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 17

Time: 2:30 PM - 3:30 PM

Room: 205 (38 seats)

What is this “Azure SQL Database” that I keep hearing about? In this session we will start from the beginning and answer the big questions around what it is, how you use it, how to monitor cost, and most importantly why you would and should use it in your particular environment/situation.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: March 17

Time: 11:15 AM - 12:15 PM

Room: 207 (32 seats)

Tasked with upgrading 4 TB worth of data to a new HA cluster, I wanted a faster way to do this. Yes I love binge watching Netflix while files copy and the cluster builds its 4 nodes for 20 hours, but I also value sleep. In this demo heavy session watch while I upgrade an 2016 HA server to 2017 as fast as a planned failover.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 17

Time: 11:15 AM - 12:15 PM

Room: 204 (30 seats)

Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare?

In this session, we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 17

Time: 1:15 PM - 2:15 PM

Room: 107 (38 seats)

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