Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 99
Are you familiar w/ SSAS Multidimensional and curious about Tabular? Having trouble deciding between cubes and tabular models? Then this is your session!

Analysis Services Tabular was introduced back in 2012, and yet it has only just started to emerge from the Proof-Of-Concept phase to a legitimate production alternative in most IT departments. Based on xVelocity, a highly compressed in-memory technology, Tabular models provide considerable performance improvements over Multidimensional models in many scenarios. And with major advancements in 2016, Tabular has never been a more appealing solution. But, as is the case with any new technology, there are certain limitations of which to be aware. 

Join me in this session and learn what a Tabular model is, how it fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live step-by-step demo where we'll build and deploy a Tabular model.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 21

Time: 8:15 AM - 9:15 AM

Room: Probably Unavailable

Azure Data Factory is a modern data orchestration platform design to help you manage any data of any size from any source. It also makes a number of technologies available to you such as Azure Machine learning so that you can integrate predictive machine learning models in your data pipelines. This platform enables you to create intelligent applications that not only provide insights but can also recommend actions upon specific events. Join me in this session as we take a closer look at many of the capabilities built into the platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Intermedia

Session Code:

Date: May 21

Time: 1:15 PM - 2:15 PM

Room: 106 (51)

If you're a new DBA, or an experienced DBA who's a few years behind, you are probably overwhelmed by all the fancy new terms and features: Azure/Cloud/On-Premises, Power Shell/Query/Pivot/View/Map/BI, Availability Groups, In-Memory/Hekaton, Columnstore, Everything-As-A-Service, and even having to deal with the dreaded NoSQL! And you've still got your hands full with clustering, mirroring, replication and backups! What is a modern SQL Server DBA to do?

This lightning talk will offer a gentle guide to all that new-fangled stuff and show you how they can make your current tasks easier and better. You'll learn where to find help and best practices, and how to get started with SQL Server in Azure. We'll also cover Microsoft Virtual Labs and show you how you can get hands-on experience with no risk or cost to you. 

You'll laugh, you'll smile, and most of all you'll feel a lot better about all these new features and how to get the most out of them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 21

Time: 12:00 PM - 12:15 PM

Room: Room 03

It is about developing a sense for patterns in our day-to-day repeatable processes, and creating solutions to automate them. 

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 21

Time: 1:15 PM - 2:15 PM

Room: 205 (40)

You already know how to write SQL queries against a data warehouse but your new job responsibilities require you to write MDX queries against Analysis Services (SSAS). MDX is the query language of SSAS in multidimensional mode. While SQL and MDX share some common keywords, they have very different syntax and concepts. In fact, the common keywords can be confusing if you are used to thinking in SQL. 
 
In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel and SQL Server Management Studio, to use as practical examples of how to write MDX queries.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 21

Time: 9:30 AM - 10:30 AM

Room: 223 (40)

Ever wondered what the craze of Server Core is all about? There is a lot of power in Core and with it comes the admin challenge of NO GUI.  But there are settings that you want to change in the OS, how do you do that? This session will take you through some of the challenges that are not really challenges when you know. We will use the builtin method of making some changes and also use PowerShell and commandline tools to get you where you want to be with Core. I built a 6 node cluster on Server Core and created it with PowerShell (Cluster and all) and it runs very nicely with a little footprint in RAM for the effort.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 21

Time: 3:45 PM - 4:45 PM

Room: 106 (51)

In this session, we will walk through how to build a detailed error notification service for SQL Server that will trap errors, and email you a well formatted and detailed error report on what went wrong. In many organizations, you typically have SQL agent jobs running, and when failures occur, you get a generic email with a jumbled up message about the error, but it doesn't really help you understand where and at what point did your stored procedure fail.
In this class, we will introduce and go through how to pinpoint errors in real time, and how to identify troubling areas or bottlenecks in stored procedures. In the end, you will have a notification and error handling system that sends you a well formatted email alert with an html table output to show you the events that led up to the error, and what exactly the error was.
This toolset has saved many developers and DBA's tons of time researching failures in jobs, and we hope it helps you too!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Information Delivery

Level: Intermedia

Session Code:

Date: May 21

Time: 2:30 PM - 3:30 PM

Room: 218 (60)

Today, many enterprise organizations have already virtualized most of their non critical applications, these organizations are now employing a "Virtual First" policy, harnessing the efficiency and cost savings of virtualization for their most critical applications. 
Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about  performance, scale, availability and support for what is usually considered their most critical applications.  In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience  and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by the author of the official SQL server on VMware best practices guide.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 21

Time: 10:45 AM - 11:45 AM

Room: Room 07

During a recent project migrating from on premise to the cloud. First we were going to Redshift and started coding, then were asked to use Azure DWH instead. We soon realized that moving between cloud providers was actually quite similar, just different names and slightly different code format.

In this session we will investigate several options to migrate your existing solution and the "fastest" way to get your data into the cloud including:
 1) Reusable data export templates
2) Transferring files to Azure Blob Storage
3) Polybase to load data
4) CTAS to Merge data

Can Biml also do AWS S3 and Redshift? Yes and we will show you the similarities in approaches and how we are using it at one of our customers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 21

Time: 9:30 AM - 10:30 AM

Room: 107 (54)

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of  Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you! 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 21

Time: 2:30 PM - 3:30 PM

Room: 212 (48)

Azure SQL Database offers compelling features for developers, especially those creating cloud applications. In this session, you'll learn about the Azure SQL Database platform and the tools provided for deployment and management of your databases. Demos will provide step-by-step examples of creating a SQL Server and Azure SQL Database, deploying a database using various methods and then managing that database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 21

Time: 2:30 PM - 3:30 PM

Room: 106 (51)

There is no place like home, there is no place like home! When a database crashes and you have to recover it, this may be what you're saying to yourself over and over.  It can feel like a house just landed on you if you're not prepared.  Ok, not really, but recovering a database from an unexpected event is often just as terrifying! If you aren't prepared for it, it's really going to hurt.  So what do you do? You prepare. You plan. You practice.  We'll talk about how the backup & restore process works in SQL Server and how it can help you prevent a Wizard of Oz situation!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 21

Time: 3:45 PM - 4:45 PM

Room: 107 (54)

You've probably heard a lot about Biml for SSIS automation, but it can also be used for building complex, yet reusable T-SQL statements for common database tasks – in most cases much faster and more easily than with dynamic T-SQL. This will be a scenario driven session where we discuss many real world examples of manual tasks that can be automated with Biml snippets and the free BIDS Helper AddIn to BIDS/SSDT. You will receive all code for your own use. Scenarios include: 1) Generation of T-SQL merge statements that removes all the drudgery of manually mapping columns - including complex SCD column handling. 2) Stale data detection that uses Biml to create queries that display ranges for all date/time columns in each table of a target database - perfect for retiring tables from WorkDB and other ad hoc environments. 3) Sample data creation that automatically produces test data based on DDL schema information from your data model. 4) And much more
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 21

Time: 1:15 PM - 2:15 PM

Room: 223 (40)

Join us for a practical look at the components of Cortana Intelligence Suite for information management, data storage, analytics, and visualization. Purpose, capabilities, and use cases for each component of the suite will be discussed. Expertise required for implementation of each component will be covered as well. If you are a technology professional who is involved with delivering business intelligence, analytics, data warehousing, or big data utilizing Azure services, this technical overview will help you gain familiarity with the components of Cortana Intelligence Suite and its potential for delivering value.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 21

Time: 9:30 AM - 10:30 AM

Room: 205 (40)

Tim Radney will share his experience with working with clients from all over the world that utilize Cisco UCS for the underlying infrastructure as well as how he helped a client migrate thousands of databases with over 100 instances to Cisco's UCS.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 21

Time: 12:00 PM - 1:00 PM

Room: 220 (60)

How much Azure can you Azure? How many cloud can you cloud? Hear the lessons learned from an attempt at an “All Azure” BI Project. We’ll explore Azure SQL Database, Azure Data Factory and Power BI as pieces of the solution and learn where On Prem had to be used to fill in the gaps in the solution. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 21

Time: 2:30 PM - 3:30 PM

Room: Room 07

You're looking to protect your SQL instance from a machine failure.  Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides.  Let's learn what a cluster is and why it might be the right thing for you.  We'll explore the system, network, storage and database administration sides of the equation.  And, when it's all said and done we'll even have built a SQL clustered instance!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 21

Time: 2:30 PM - 3:30 PM

Room: Room 07

R is the most popular statistics language used today. It is one of the most useful tools in the data scientist's tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.  
  
Come to this session to get an introduction to the R language including: 

  - Installing and Configuring R and RStudio 
  - RStudio Overview and Debugging
  - How to Access and Manipulate Data 
  - Install and Manage Packages 
  - Create and Use Variables 
  - Control Flows 
  - Functions 
  - Basic Graphing and Statistical Analysis 

We will finish with a brief introductions of how R integrates in Azure ML, Power BI and SQL Server 2016 using real demos.  
  
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science! 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 21

Time: 9:30 AM - 10:30 AM

Room: 112 (51)

Microsoft Power BI is going great places. Its great visualizations, easy-to-use tools, and robust sharing capabilities are improving with new releases almost every time you turn around. But, what if uploading or storing your company's data in the cloud is a potential deal-breaker? Fortunately, the Microsoft Power BI Gateway - Enterprise make it possible to live query data in an on-premises SSAS instance for display in Power BI. In this session, we will go through what this gateway does, how it works, and how it is installed to show that BI in the cloud doesn't require data in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: May 21

Time: 1:15 PM - 2:15 PM

Room: 218 (60)

DevOps is a word that gets thrown around a lot these days and is the way most shops will operate in the future. In my presentation I'll show you how to fast forward to the future by automating your deployments from SSDT using Powershell and SQLPackage.exe.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 21

Time: 3:45 PM - 4:45 PM

Room: 223 (40)

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