Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type


Sessions Found: 33
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 05

Time: 9:45 AM - 10:45 AM

Room: Room 5

Constraining everything in development and testing is database size.  Storage is a bottleneck, and while faster SSD/Flash is available, it is still too expensive due to the size of many databases, especially in DEV and TEST.  More to the point, it takes a lot of time to push terabytes around, and time itself is expensive.  The old joke about "good, fast, and cheap -- pick any two" is so true with data.

Providing full databases for each developer or tester on each task of each project seems unrealistic, when each copy might require terabytes of storage, so for decades everyone has limited themselves to working in shared dev/test environments that are refreshed only every few months, where conflicts occur,  quality suffers, and things move slowly.

Come learn why data virtualization is the solution to a problem everyone knows.

Good, fast, and cheap -- have all three with data virtualization.  Be able to clone data quickly, and remove the biggest constraint to development and testing.
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: Room 4

It's not a question on whether or not the landscape for the common DBA is changing. Without a doubt, it is.  Azure offers up a new world of possibilities for DBA's and we should all strive to learn it.  In this session we'll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this.  This new found knowledge will help propel your career into the new landscape.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Introduction to SQL Server

Level: Beginner

Session Code:

Date: May 05

Time: 2:15 PM - 3:30 PM

Room: Room 1

This session will explore every aspect of Power BI…from the technology used behind the scenes and the tenant/service in Azure, to data refresh options and development best practices. We’ll cover everything you need to know (and more) before you embark on your first Power BI project.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Introduction to SQL Server

Level: Beginner

Session Code:

Date: May 05

Time: 1:00 PM - 2:00 PM

Room: Room 1

Almost all of us use SQL Server Management Studio to interact with SQL Server.  But, did you know it's chock full of tricks and handy little shortcuts.   In this session I will demonstrate my favorite tricks and shortcuts that I've picked up over the years that have helped make it easier and more fun to use.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Introduction to SQL Server

Level: Beginner

Session Code:

Date: May 05

Time: 8:30 AM - 9:30 AM

Room: Room 1

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:
BI Information Delivery

Level: Beginner

Session Code:

Date: May 05

Time: 2:15 PM - 3:15 PM

Room: Room 4

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

Level: Beginner

Session Code:

Date: May 05

Time: 1:00 PM - 2:00 PM

Room: Room 5

Critical path SQL will focus on recursive common table expressions (CTE) on problem solving in finding minimum and maximums for common business problems like minimum/maximum manufacturing costs and lead times in BOM's (bill of materials) and other hierarchical data structures where a tree traversal is needed as well as non-hierarchal data structure examining CTE usage with the traveling salesman problem to examine a desired minimum.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database & Application Development

Level: Intermedia

Session Code:

Date: May 05

Time: 1:00 PM - 2:15 PM

Room: Room 2

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:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: May 05

Time: 11:00 AM - 12:00 PM

Room: Room 5

Data Driven reports are a powerful Reporting Services feature, but they are only available in the Enterprise Edition.  In this session we're going to dig into the ReportServer database and look at some tables that will allow us to dynamically interact with subscription records and use them to control report output.
  
We will also leverage an SSRS interface to set and update parameters to the subscription tables.  
By using these techniques we can simulate the power of Data Driven Subscriptions without having to have Enterprise Edition.  These techniques can also be used to dynamically configure actual Data Driven Subscriptions and kick them off without access to the SQL Agent engine.  Anyone wanting to extend their SSRS capabilities in creating report automation should attend this session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: May 05

Time: 9:45 AM - 10:45 AM

Room: Room 3

Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs. 

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 05

Time: 8:30 AM - 9:45 AM

Room: Room 2

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 05

Time: 1:00 PM - 2:00 PM

Room: Room 3

If you’ve looked at the cloud, you’ve realized the large number of options you have to implement a complete cloud analytics solution. You have the ability to deploy dashboards, data ingestion and integration and advanced analytics to the cloud that will empower data-driven decisions for your organizations. This talk will discuss and review options you have to run Cloud Analytic Solutions from the three major cloud providers – AWS, Azure and Google Cloud Platform.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Analytics

Level: Intermedia

Session Code:

Date: May 05

Time: 8:30 AM - 9:30 AM

Room: Room 4

You will learn R data structures such as vectors, matrices, lists and data frames; how to work with variables; common data transformations; and lastly how to leverage R's graphical capabilities.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 05

Time: 9:45 AM - 10:45 AM

Room: Room 6

T-SQL windowing functions can simplify many complex queries. They are the best thing that has happened to the T-SQL language in years, but many database professionals and developers haven’t heard about them. 
They were initially introduced with SQL Server 2005. In 2012, Microsoft added several new functions that let you do things like pull values from different rows without a performance penalty. 
Attend this session to learn how T-SQL windowing functions apply to many real world examples.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: May 05

Time: 3:45 PM - 4:45 PM

Room: Room 4

You’ve been around long enough to pick up on the disdain that the T-SQL community has for cursors, but how do you get away from them?  We will take a common business problem and work our way through a few alternative approaches, discussing the strengths and weaknesses of the various approaches and evaluating the performance of each. CTEs, recursive CTEs, and the OVER AND PARTITION BY clause will be covered.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Intermedia

Session Code:

Date: May 05

Time: 9:45 AM - 10:45 AM

Room: Room 4

Power BI makes accessing data from various sources and building advanced visualizations for analytics easy to do. Behind the scenes Power BI is built on standard technologies and APIs that allow it to be customized in multiple ways to fit in with your environment the way you need it to. In this session we will walk though samples and demos that show how you can extend Power BI with custom visualizations, access custom data sources, embed various Power BI elements in your applications, and be able to push your data into a Power BI report/dashboard. Each of these items take advantage of the Power BI APIs in different ways and we will discuss each and provide the code samples for you to take back and get a head start. This session will be showing code to access the Power BI REST API using C# and NodeJS along with some M for accessing and manipulating custom data sources.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 05

Time: 2:15 PM - 3:30 PM

Room: Room 3

Partitioned tables are an ideal solution for improving write performance in certain situations. But they present unique challenges for the developer who simply needs to query the data. In this session, you will learn how the optimizer takes partitioned tables into account when producing query plans, recognize common query plan issues, and learn tactics for improving performance when querying partitioned data.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Intermedia

Session Code:

Date: May 05

Time: 8:30 AM - 9:30 AM

Room: Room 3

Because little in business or life gets done without negotiation, this session has the potential to deliver significant upside in your professional and personal outcomes. In this session, you will be introduced to basic negotiation concepts and tactics, followed by a focus on important aspects of the negotiation process—obstacles to effective communication at the bargaining table, the maximization of multiple interests, and preparation tactics for your next negotiation. We will put it all together by examining a special type of negotiation: YOUR SALARY! 

Participants will: 

•	Learn strategies for negotiation analysis and preparation
•	Understand different strategic choices and interpersonal skills necessary for success 
•	Know what information is needed to negotiate effective outcomes
•	Experiment with new techniques and test their effectiveness in a safe environment
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 05

Time: 1:00 PM - 2:00 PM

Room: Room 4

Microsoft’s Power BI is the new hotness. In this session, you will get your hands dirty and dive into PowerBI and create an actual report, with actual data. You will get to learn from examples from what a DBA has done to implement Power BI in his shop and make his data accessible.

As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point Power BI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, Power BI, and how to make these work for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 05

Time: 3:45 PM - 5:00 PM

Room: Room 3

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