Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 53
In this demo-heavy session we will discuss the value of a SSIS Framework, explore forward engineering benefits, and demonstrate SSIS design patterns on loading SQL structures when developing Data Warehouses, SSAS Cubes, and Power BI Analytics.

An outline of the subject matter to be covered is below:

Live Demo SSIS Framework
  ? Load & Error Meta Data
  ? Restart ability, Rollback, Reload Count
  ? Master Load ID, LoadID, ExecutionID (SSISDB), Refresh
  ? Package Sequencing and Signatures
  ? Connections, Expressions, Parameters, Event Handlers
  ? Alerting (SMTP), Error Flows (XML Destination Script)

Forward Engineering SQL Structures (Examples from Most Popular Modeling Tools)
  ? Relationships, Primary & Foreign Keys
  ? Data Types, Nullability, Indexes

Fully Functional Demos for Multiple Design Patterns
  ? Dimensions
  ? Slowly Changing
  ? Facts
  ? Inserts, Updates, Deletes
  ? Bridges / Snowflakes
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 3:45 PM - 4:45 PM

Room: 2.306

I would like to share the 3 lessons I learned that helped me become a much better consultant. These lessons were crucial in helping me make that "mind shift" from thinking like a regular "9 to 5 DBA" to thinking like a consultant. The goal of this session is to help those who are interested in becoming a consultant. Hopefully these 3 lessons will help make that transition successful as it did for me.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 19

Time: 3:45 PM - 4:45 PM

Room: 2.203

CIOs and VPs everywhere are asking me, how do we achieve HA with SQL Server? Having architected and implemented over 100 architectures, see how to architect, design, setup, deploy, tons of gotchas and best practices from real production deployments With the introduction of AlwaysOn and the deprecation of Database Mirroring, Windows Clustering Services is now more critical than ever. If you have moved away from clustering or implemented database mirroring as an alternative to clustering and found it lacking AlwaysOn is the way forward for you. This talk will demonstrate a complete end-to-end solution using Windows Server Failover Clustering, AlwaysOn, SQL Server 2017 Enterprise edition, and Active Directory.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 3:45 PM - 4:45 PM

Room: 2.412

Could your seemingly-normal SSIS package be hiding a disaster, waiting to detonate at the most inconvenient time? Integration Services is an incredibly flexible product, and that flexibility can lead to good - and occasionally bad - design patterns. Small and seemingly trivial design decisions can lead to big issues down the road, including leaky data flows, data quality issues, paralyzing performance issues, and other explosive behaviors.

In this session, we will explore some of the most common SSIS design patterns that are potentially more harmful than they first appear. From package configuration to control flow constraints, and data flow transformations to logging, we'll demonstrate what can go wrong and show some alternative designs to prevent these types of problems from developing into bigger issues.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 8:30 AM - 9:30 AM

Room: 2.415

The elasticity of the cloud lets you provide a better user experience instead of breaking the bank running your solution at the highest scale 24 hours a day. This demo-heavy session will show how to automate Azure Analysis Services. We will look at solutions to the following questions: How do you schedule a refresh of the data in your Azure Analysis Services model? How do you pause the server on the weekends? Better yet, how can you pause it when the last user disconnects and start it automatically when the first user connects in the morning? How do you scale to meet peak demand each day? How can Azure Analysis Services load balance across servers in multiple countries so that the user connects to the geographically closest server? How do you extend your on-premises SSAS solution into Azure Analysis Services?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 1:15 PM - 2:15 PM

Room: 2.203

AWS Aurora sounds perfect - a magical in-the-cloud relational database where everything Just Works.  And while that's true to an extent, it's still MySQL behind the scenes, and there's some things to keep in mind.  Join us as we discuss the advantages, disadvantages, promises, & realities.  We'll also look at ways to monitor performance, track code changes, and investigate what's going on behind the scenes.  There will be demos, SQL code, Powershell and more.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 2:30 PM - 3:30 PM

Room: 2.311

SSIS was originally designed to work in a world where all data was structured and on premise. As modern enterprise data projects increasingly move online, tools like Azure Data Factory (ADF) can extend SSIS capabilities to the cloud. Azure Data Factory is a flexible and powerful cloud based ETL service, but it doesn't replace the functionality of SSIS. 

In this session you will learn the advantages and disadvantages of both ETL platforms; how to use both in tandem to maximize productivity; and how both ETL platforms, as well as any supporting structures, can be be automatically generated with Biml Script. 

All of the code used in this presentation can be downloaded by attendees, customized, and used in their production environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 2:30 PM - 3:30 PM

Room: 2.412

Need more SQL but you have run out of hardware on premises?  How about SQL in the cloud?  In this session we will discover what Azure is with a high level overview of Azure and we will dive into two of Azure’s Data offerings, Azure SQL Database (SQL Server) and Azure SQL Datawarehouse (PDW).  We will walk through setting up an Azure environment for the first time and how to deploy and use Azure SQL Database and Azure SQL Datawarehouse.  The discussion will also include defining IaaS, PaaS and SaaS
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 19

Time: 9:45 AM - 10:45 AM

Room: 2.305

Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success.  Often times we focus on showing how smart we are instead of showing what a good team member we can be.  We will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills?  We will explore innovative and fun ways in which to do just that!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 19

Time: 1:15 PM - 2:15 PM

Room: 2.410

Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected.  In this class, we'll cover the basics of the big five administrator tasks:

* Backups – You must set up regular backups, to keep copies of your databases...just in case something breaks, or someone makes a bad, bad mistake.
* Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined.
* Index maintenance – Databases need regular upkeep so they'll continue to run well.
* Disk management – It's actually your job to find out about full disks before they happen. After all, databases grow!
* Alerting – Alerts tell you what's wrong, so you don't have to go looking for problems.

Being a database administrator is a big job, but we can cover the basics in one session!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 2:30 PM - 3:30 PM

Room: 2.203

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:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 19

Time: 8:30 AM - 9:30 AM

Room: 2.306

Python is the one of the most popular programming languages used today and one of the most useful tools in the data scientist's tool belt especially for machine learning. Python is integrated into the Microsoft stack in tools like Azure ML and now SQL Server 2017.

The session will be an introduction to the Python language including: 

1.) Installing and Configuring Python
2.) Access and Manipulate Data
3.) Install and Manage Packages
4.) Create and Use Objects/Variables
5.) Control Flows and Functions
6.) Managing the Python installation in MSSQL

Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.

No prior statistics knowledge needed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization, BI Delivery

Level: Beginner

Session Code:

Date: May 19

Time: 1:15 PM - 2:15 PM

Room: 2.102

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:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 2:30 PM - 3:30 PM

Room: 2.306

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 8:30 AM - 9:30 AM

Room: 2.311

SQL Server on Azure virtual machines enables you to use full versions of SQL Server in the Cloud without having to manage any on-premises hardware. The session covers options, features and best practices on SQL Server on Azure VM. We will highlight frequently asked questions, common issues with SQL server on Azure VM and how to avoid them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 9:45 AM - 10:45 AM

Room: 2.311

Targeted at the non-DBA such as BI/DW folks, Application Developers, Managers, and System Admins, this session will go over the reasons we back up our databases, our systems, etc.  Considerations such as Single points of failure, High Availability/Disaster recovery, Business Continuity and others will be discussed in this interactive conversation.   It will be conversation heavy, with supporting slides to download, and one Database backup demo at the end if time permits.

Everyone involved in a technical role needs to at least know that the things they have created will be recoverable in the event of a disaster, or even just an "oops" moment.   The CIO/CTO should know how long critical systems will be down when bad things happen.  Backups are everyone's responsibility...whether asking the right questions or implementing the process.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 11:00 AM - 12:00 PM

Room: 2.305

Have you wanted monitoring tools but know it's not feasible to procure them for your SQL Server enterprise?  In this session, you will learn how to implement multiple solutions to help you be a Proactive DBA instead of retroactive DBA. You will understand which checks should be mandatory for every SQL Server environment.  You will also learn common pitfalls with implementing your own monitoring solutions and how to customize them to work for you.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 8:30 AM - 9:30 AM

Room: 2.412

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: May 19

Time: 1:15 PM - 2:15 PM

Room: 2.415

Are you interested in data encryption?  Do you store sensitive data in SQL Server databases?  Does GDPR affect your company?  If you answered yes to any of these questions then this session is for you.  In this session we will introduce and implement 4 methods of encryption available in SQL Server --Backup encryption, Transparent Data Encryption, AlwaysEncrypted, and connection encryption.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 1:15 PM - 2:15 PM

Room: 2.412

Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for years to manage their databases on this valuable OS?
This session is taught by a multi-platform DBA who specializes in Oracle and SQL Server with almost two decades on Unix/Linux experience.  The goal is to give you the most valuable fundamentals and commands that are important to the DBA when managing a database in a Non-Windows environment. 
We’ll learn:
1.    Linux history and concepts.
2.    Important differences between systems
3.    Crucial commands to get around 
a.    Navigating, searching and managing
b.    Monitoring, tracing and updating
c.     Editing and scripting

You’ll leave feeling more at ease with Linux and have plenty of content and links to continue the learning after the session!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: May 19

Time: 11:00 AM - 12:00 PM

Room: 2.102

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