Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type


Sessions Found: 36
Learn how to create your own skill (app) for Amazon's Echo / Dot service known as Alexa.
In this session, we'll create a simple skill from scratch, and show how to get into some of the more advanced options.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: February 03

Time: 8:30 AM - 9:30 AM

Room: Training 3

Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be successful with DAX and Powerpivot, you'll need a completely different mental model. In this introduction to DAX, we won't spend too much time on the basics. Instead, we'll focus the concepts that make DAX unique. This will help you avoid the stumbling blocks of working with DAX. We will cover calculated columns, measures, aggregations, filtering, and iterators.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: February 03

Time: 8:30 AM - 9:30 AM

Room: Training 2

Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford's Law, outlier analysis, time series analysis, and cohort analysis.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 03

Time: 1:30 PM - 2:30 PM

Room: Training 3

Microsoft’s Power BI service has allowed end users and business analysts to exercise their creativity as developers.  The expansion of department resources to create elegant and visually appealing reports for themselves as well as the organization at a fast pace has taken some of the burden off developers, or has it?

Are you hoarding your environment with unorganized piles of data to feed your wonderful Power BI reports?  In this life of point and click, drag and drop reporting, we sometimes lose sight of cohesive business standards, data integration and modeling.

In this session, we will look at potential data management nightmares that include but are not limited to; overlapping data, inconsistent naming conventions, undocumented transformations, mismatch data types and varying granularity.  We will focus on the importance of having a solid data model and managing data governance using Power BI as well as traditional tools and best practices.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: February 03

Time: 1:30 PM - 2:30 PM

Room: Training 4

The cardinality estimator in SQL Server is a massively complex piece of software that is responsible for calculating the estimated number of rows for query plans. We will derive some of the simplest and most important rules for cardinality estimation. Armed with that knowledge, we will address errors in cardinality estimates which can cause poor query performance. Demos include filtering on multiple columns, using local variables, dealing with ascending keys, and more.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 03

Time: 9:45 AM - 10:45 AM

Room: Training 1

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.
Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
 - Source to Target mapping documents can be used to generate the code to effect the mapping.
 - Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
 - Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
 - Business rules can be encoded in data and the code to implement them manufactured.
Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 03

Time: 11:00 AM - 12:15 PM

Room: Training 2

Most of the time pilots are learning to fly, they're actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: February 03

Time: 8:30 AM - 9:45 AM

Room: Training 5

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:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 03

Time: 11:00 AM - 12:00 PM

Room: Training 5

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.
In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible.
By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: February 03

Time: 9:45 AM - 10:45 AM

Room: Auditorium

Power BI is constantly evolving; this session is an overview of the current elements of Power BI and ways to implement them, based on our experience in the field using it. Topics include the Power BI Service, Power BI Desktop, Power BI Embedded, Pricing models and some details of Power BI Premium. Sample data set used in this presentation is from @DogRates
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: February 03

Time: 4:15 PM - 5:15 PM

Room: Training 3

Hierarchical data sets are everywhere. If you haven't worked with one yet, you probably will someday.

If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process.

This simple but code intensive "Black Arts" session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and includes a very high performance method (100,000 nodes in less than 4 seconds and 1 Million nodes in less than a minute) for converting Adjacency Lists to Nested Sets that even a beginner can understand.  

If there's time, we'll cover a new "pre-aggregated" Hierarchical table structure that answers most of the questions you'd ask of a Hierarchy. You just have to know that a Tally Table is involved somewhere in this. ;-)

Don't let the "Intermediate" rating of this session scare you beginners away because we start at the ground floor.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 03

Time: 4:15 PM - 5:15 PM

Room: Training 1

SQL Server Reporting Services (SSRS) is an easy-to-use tool for automating reports and creating highly visual dashboards. Although SSRS is easy to learn there are many tips and tricks that can improve your report building experience, not to mention make your reports run blazing fast! 
This rapid-fire session goes over my learnings from the past six years of developing high-performance SSRS reports, including topics like multivalue parameter efficiencies, how to best utilize subreports, and performing SQL CRUD operations with SSRS.
Each rapid-fire topic includes sample data and an SSRS reporting example that users will be able to try out for themselves.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: February 03

Time: 2:45 PM - 3:45 PM

Room: Training 1

Are you just starting out writing SQL for applications or reports?  Did you back into a DBA role by accident?  Do you know nothing about indexes and think you should?  If you answered yes to any of those questions then this class is for you.  
This class presents indexes from the ground up and lays the foundation for solid index usage.  We'll cover what indexes are, different types of indexes, when to use them, and when not to use them.  We'll also briefly cover index maintenance.  
This class is designed for beginners and is designed to be very practical.  It won't dive deep on any one subject and won't bog down with technical minutiae.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 03

Time: 1:30 PM - 2:30 PM

Room: Auditorium

This session is a very basic introduction to Integration Services (SSIS).  We’ll cover the basics; what it’s used for and the various parts and pieces to get you started creating your own projects in no time.  We’ll talk about packages, connections and project parameters and their respective tasks/properties.  We’ll also cover some basic performance tuning to make your packages run faster.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: February 03

Time: 11:00 AM - 12:15 PM

Room: Training 1

Integrating databases schema changes into a Software Development Lifecycle Management (SDLC) process can be a  daunting and often tedious proposition. Adding  the complexity of version control to the mix complicates this scenario. Fortunately, beginning with Visual Studio 2012, Database Projects add an "easy" button to this process. In this session, you will learn about the features and capabilities of VS Database Projects and how to use them to improve the lifecycle of your database structures, even if your organization does no code management.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 03

Time: 9:45 AM - 10:45 AM

Room: Training 5

SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: February 03

Time: 1:30 PM - 2:30 PM

Room: Training 2

Microsoft has added new performance improvements and new features to SQL Server 2016 and 2017’s implementation of Always On Availability Groups. This session will cover improvements that range from Standard Edition support for AGs to load balanced replicas to new ways to create those replicas. We’ll kick the tires on the improved Azure support and discuss the massive performance improvements in Always On as well.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 03

Time: 4:15 PM - 5:15 PM

Room: Training 5

The acronyms get out of control sometimes but the platform as a service (PaaS) offerings keep coming!  Microsoft has introduced another one in the data platform called Azure Analysis Services.  This service allows for the hosting of your BI Semantic models (BISM) in Azure.  In this session we'll get an introduction to this new service and walk through how to get started using it.  We'll also discuss the benefits and differences of this and the on premise SSAS solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: February 03

Time: 2:45 PM - 3:45 PM

Room: Training 4

T-SQL programming makes wide use of parameterization in stored procedures, dynamic statements and ad-hoc queries. Many developers aren’t aware of the significant influence they have on query performance. Incorrect use or lack of parameters is a common reason for query performance issues.
Have you experienced a query that always ran fast, suddenly (and for "no reason") become slow? And with nothing changing? Yep!
* In this session we will learn about how the plan cache deals with queries that are (and are not) parameterized. 
* You'll learn about parameter sniffing, what it is, and how it's handled in the older and newest versions of SQL. 
* We will explore the problem of mismatched data types and implicit conversions - and how that ties in with ORM generated code. 
* Lastly, we'll take a peek at value list handling from applications, and how using a table valued parameter as an input instead.
If this is a new topic to you, you'll leave this session with takeaways galore.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 03

Time: 2:45 PM - 3:45 PM

Room: Auditorium

One of the most highly anticipated new features in the SQL Server 2016 release was Query Store. It's referred to as the "flight data recorder" for SQL Server because it tracks query information over time – including the text, the plan, and execution statistics. The addition of wait statistics information – tracked for each query plan – in SQL Server 2017 makes Query Store a tool that every data professional needs to know how to use, whether you're new to troubleshooting or someone who's been doing it for years. When you include the new Automatic Tuning capabilities in SQL Server 2017 and Azure SQL Database, suddenly it seems like you might spend less time fighting fires and more time enjoying a lunch break that’s not at your desk. In this session, we'll talk through these new features - and see them in action - so you can understand how you can immediately start to use them once you’ve upgraded to SQL Server 2017.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: February 03

Time: 11:00 AM - 12:15 PM

Room: Training 3

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