Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 25
Creating a Power BI data model is pretty easy, but sometimes we have to deal with more complex scenarios the require us to dig a little deeper. 

In this session we'll take your modeling skills to the next level as we explore a few advanced techniques that deal with displaying measures in the rows of a table (as opposed to the columns), dynamic currency conversions and an alternate approach to role-playing dimensions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Advanced

Session Code:

Date: August 03

Time: 9:45 AM - 10:45 AM

Room: 150GH

We all love SQL Server but is it really so much different than Postgres, Oracle or Mysql?  I've spent a lot of years in many of these technologies and I want people to understand the good and the bad about the different technologies out there.  My goal with this session is to entertain and to hopefully open your eyes to the reality that if you have skills and knowledge of RDBMS you shouldn't be afraid of ever finding a job in any of these technologies.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: August 03

Time: 1:00 PM - 2:00 PM

Room: 150CD

SQL Server 2012 brought to life a new form of high availability and disaster recovery in the form of Availability Groups (AGs). This all sounds fantastic, but in reality there are issues and problems that are generally not discussed, or well known, that can impact your HA/DR story and cause major performance issues. In this session, I’ll give a brief overview on AGs in SQL Server 2012 and the enhancements that come in 2014 and 2016. Then we’ll get into some of the problems that exist, that I’ve seen in the real world of using AGs, and that you should be aware of before implementing it in your environment.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 03

Time: 8:30 AM - 9:30 AM

Room: 150CD

Deploying to SQL Azure? What are the best ways to login/authenticate to SQL Azure? Learn about Azure AD Authentication methods: Integrated Windows authentication, Azure AD principal name and a password, Application token authentication, and additional Azure Active Directory methods  Integrated, Universal with MFA, and Interactive
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: August 03

Time: 3:30 PM - 4:30 PM

Room: 150CD

There are several ways to create a machine learning model. You can use R or Python or even other languages such as C#. Advanced coding skills are required no matter which language you choose. Once the solution is created, it’s often difficult to deploy. 

Microsoft addresses those problems with Azure Machine Learning, or Azure ML. Azure ML has built-in transforms for cleansing and munging data. It also contains a variety of configurable machine learning models that can be used without coding. Deploying the model is easy, and users can link to it directly with Excel or a custom application can be written.

If you are experienced in machine learning but haven’t seen Azure ML or if you are curious about machine learning and data science, this session is for you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 03

Time: 11:00 AM - 12:00 PM

Room: 150EF

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: August 03

Time: 9:45 AM - 10:45 AM

Room: 150AB

So you have a brand new table with lots of data and when you do a query it takes forever to return. So you add an index to improve performance and it still takes forever. Huh? Let's talk about what an index really is, the different kinds of indexes, and we will finish with a scenario where even though you have the perfect index, it is still not used.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 03

Time: 1:00 PM - 2:00 PM

Room: 150EF

You're comfortable writing T-SQL, and you've built a lot of stored procedures that have a bunch of parameters. For example, you have that "product search" stored proc with parameters for product category, name, price range, sort order, etc, and you have to accept any of 'em. 

So how do we make those go fast? And how can we get 'em to use indexes?

In one all-demo hour, performance tuner Brent Ozar will show you several ways that fail in comically bad ways. You'll learn how to write dynamic SQL that's easy to tune, manage, and troubleshoot.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 03

Time: 8:30 AM - 9:30 AM

Room: 150AB

Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session we will discuss common pitfalls for any SQL professional who is manipulating large sets of data with INSERT, UPDATE, and DELETE statements. Not only will you learn about potential issues involving data pages, locks, and the transaction log, but also what techniques you can use to improve performance.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 03

Time: 8:30 AM - 9:30 AM

Room: 150GH

At some point or another, every DBA has to deal with concurrency issues.  Read Committed Snapshot Isolation (RCSI) is one of the many appealing options you have in your quiver as a DBA to resolve concurrency problems.  This session will focus on how RCSI works, and when it may be useful for you as a DBA or developer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 03

Time: 2:15 PM - 3:15 PM

Room: 150GH

There has been a movement towards PowerShell in the SQL Server Community lately. With so much out there, how do you get ahead.  I will take you through this massive module that has grown very quickly to over 300 functions for use in your daily DBA job. This module can single handedly migrate an entire server with one command, or you can choose the parts you want to do and just do those. Join me to find out how you can quickly leverage the power of this module. This is one tool you want in your PowerShell toolbox.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 03

Time: 2:15 PM - 3:15 PM

Room: 150AB

Have you heard about all the hot new features in SQL Server 2017? One of the game-changing features is Graph DB. Come see what it is, how you can use it, and what scenarios it excels in - specifically where data has strongly defined relationships and is more interconnected.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 03

Time: 2:15 PM - 3:15 PM

Room: 150EF

Discussion of the best practices and considerations for security, governance, and administration of Power BI. Not only of the available options, but tips and tricks for how to navigate those options and set yourself and your organization up for success down the road.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 03

Time: 3:30 PM - 4:30 PM

Room: 150EF

This technical presentation shows how to manipulate data with versioning switched off, what to consider when building queries referencing multiple temporal tables and building views.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 03

Time: 11:00 AM - 12:00 PM

Room: 150GH

In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.
Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 03

Time: 2:15 PM - 3:15 PM

Room: ROOM3

Data masking is likely to become a new legal requirement.  Don't let this catch your organization unaware and flat-footed!

For decades, IT has been negligent, using production data during software development and testing, exposing sensitive data to those not authorized to access it.  That decades-old practice must end.

Data masking is the solution for providing non-production environments (i.e. DEV, TEST, etc) with realistic but artificial data for development and testing, while reducing the surface area of risk for breaching data.

The alternative, generating test data, incurs classic problems of engineering bias as well as blindness to true-to-life data scenarios which arise in the "wild".

Masking real production data retains realistic data conditions and distributions while merely obfuscating real data.

Masking is important, and sophisticated software packages are available today, but the field is new enough that there is lots of room for improvement in all of them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 03

Time: 1:00 PM - 2:00 PM

Room: 150AB

Nifty tips and tricks to start taking your business from Point A to Point B2B using Power BI. We will use real world use case examples of combining supplier, syndicated, or retail data in Power BI in a way that can help you move the needle.

We will cover:

•	Sales Dax/M: Options for measures and columns
•	Real life examples of converting data to continual, common sense Business Intelligence 
•	Actionable items: Dashboards, Alerts, and KPIs
•	Sharing: B2B permissions, New and Classic Workspaces

No matter what business you are in, we will cover the basics and benefits of advancing your company from emailing excel trackers to cloud collaboration.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 03

Time: 8:30 AM - 9:30 AM

Room: 150EF

How to prevent your users from writing bad queries. Tips for teaching the non-IT user how to query basic business data.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: August 03

Time: 9:45 AM - 10:45 AM

Room: 150CD

DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process.  In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded.   Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing.  "Near production data" is used in Staging, and finally production is upgraded.  This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process.  Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages.   Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes.  Learn how leading enterprises are simplifying SQL DevOps.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 03

Time: 9:45 AM - 10:45 AM

Room: 150EF

Have you ever watched a Microsoft SQL Presentation and wondered how in the world they did that cool trick? What was that keyboard shortcut? Come find out Microsoft SQL tips and tricks that will help you be more productive in your day to day work and give you a few cool ideas to make other SQL people jealous. There will even be a few SQL Server Management Studio 18 tricks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 03

Time: 2:15 PM - 3:15 PM

Room: 150CD

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