Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type




Sessions Found: 73
"With the release of SQL Server 2016, Microsoft has included two features that could fundamentally change the way we look at Data Warehousing.  The addition of Polybase for connecting to external data sources such as Hadoop and Azure Blob for native TSQL queries extends the reach of the DW.   The Temporal Table feature creates all kinds of possibilities for implementing Type 1 and 2 dimensions as well as time based reporting and logical data recovery.  In this session we will take an in depth lock at the features and scenarios for use.   We will also look at some actual demos of the technologies so you can get a feel for the technologies in action."
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 16

Time: 1:45 PM - 2:45 PM

Room: 206

Window functions and the OVER() clause are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions. We will also look at some of the performance implications of using these functions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 16

Time: 1:45 PM - 2:45 PM

Room: 105

The Apache Spark framework can accelerate processing 100x or more on Hadoop from diverse data sources such as Cassandra, Hive, or HBase. We’re going to look at the architecture and go step by step through examples using R and Python against public data sources.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 16

Time: 1:45 PM - 2:45 PM

Room: 207

So you have your availability groups configured and everything reports green.  How do you measure SLA compliance? Do you know when replication is delayed? Did you know it failed over last night?
This session will answer all these questions and more, and will show you what should you be looking at to ensure no surprises...
We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and policies to show what to monitor in your AG and how to setup alerts so you know when to take action.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 16

Time: 1:45 PM - 2:45 PM

Room: 204

Join Microsoft TSP Josh Sivey as we explore Microsoft’s new Azure SQL Data Warehouse cloud service.  SQL Data Warehouse is a data warehouse as a service offering that offers petabyte scale massively parallel processing power, created and managed with the tools developers are familiar with.  In this session we will provision a SQL Data Warehouse in minutes and show how we can independently scale the storage and compute to meet the needs of the workload on demand.  We will showcase SQL Data Warehouse’s Polybase feature to allow us to write T-SQL queries across relational and non-relational data.  We will manage and maintain our SQL Data Warehouse using the tools we are familiar with (SSMS and Visual Studio).  Finally, we will show how SQL Data Warehouse seamlessly integrates with Power BI, Machine Learning and other Cortana Analytic services.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: April 16

Time: 1:45 PM - 2:45 PM

Room: 102

Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time. 

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 16

Time: 3:00 PM - 4:00 PM

Room: 221

The topic for this hour will be modeling for MS BI with a focus on multidimensional modeling. We’ll talk about a recommended blueprint for MS BI projects, the best option for effectively handing deleted rows, denormalization, degenerate dimensions, slowly changing dimensions, many-to-many relationships, considerations for predictive analytics, and tips for migrating from other platforms. Given time considerations, we’ll also be covering how agile methodologies and ABC (audit, balance and control) impact our modeling decisions. Come join us for an information packed hour!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 16

Time: 10:00 AM - 11:00 AM

Room: 204

SmartStack solutions bring together the innovative Cisco Unified Computing System (Cisco UCS) and the Nimble Storage Adaptive Flash platform, creating the first integrated infrastructure solution based on a modern, flash-optimized storage architecture. Learn how SmartStack provides an efficient platform that delivers enterprise capabilities in a small form factor for Microsoft’s SQL Server workloads.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 16

Time: 12:30 PM - 1:30 PM

Room: 107

In this session, you'll learn how to quickly build an Access Web App, tour the online development environment and see a real, live working app in action.   We'll discuss app distribution and deploying updates and demonstrate add-in features like Power BI Tiles and Bing Maps.  And lastly, you'll learn the pros/cons of Access Web Apps and hybrid solutions in a corporate environment as well as how to extend the data to mobile phones & tablets.  Presented by Andy Tabisz, Microsoft MVP, WorkSmart Database Masters.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 16

Time: 10:00 AM - 11:00 AM

Room: 139

What kinds of things can you determine with Azure ML? Attendees will find out what kind of questions are good candidates for Azure ML and what aren't.   This session will show how to use Azure ML, by ncorporating items created in and SQL to develop an  Azure ML solution and incorporate the results into a data environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: April 16

Time: 3:00 PM - 4:00 PM

Room: 105

Cristian Vasconez and I will be presenting an in depth look at DataZen and what it has to offer, previewing Dashboard capabilities, KPI's, and administration.  We will also explore the  different cloud solution that was used to create this project and how we use different BI Tools, such as Powershell and SSIS to not only create this project, but to show how cost effective the cloud can be .
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: April 16

Time: 11:15 AM - 12:15 PM

Room: 202

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 16

Time: 3:00 PM - 4:00 PM

Room: 202

It may not be the most exciting topic, but it can quickly become the most important topic for a project! Many developers and architects make technical decisions based on features and capabilities, but do not consider licensing as part of the decision making process. Other times decisions are made by perceived licensing costs, that may not truly impact a customer’s environment. In this session Matt Smith will provide an overview of licensing options and details to consider for SQL Server including editions, versions, agreements, and software assurance. After an initial level set, Matt will then focus on guidance and best practices for licensing a SQL Server environment across a number of scenarios such as: Virtualized environments, public and private cloud scenarios, support, upgrades, high availability and disaster recovery scenarios. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: April 16

Time: 12:30 PM - 1:30 PM

Room: 105

Protecting our data from unauthorized access becomes more and more important all the time, however it has been difficult to ensure sensitive data is encrypted in SQL Server. The new Always Encrypted feature in SQL Server 2016 makes this much simpler for developers and DBAs with a framework for protecting data from the client, across networks, and inside of the database. This new feature allows for limiting access to the data, even from the DBAs and sysadmins that may control the database instance itself. Learn how to implement and use Always Encrypted in your applications.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 16

Time: 11:15 AM - 12:15 PM

Room: 102

While more and more workloads have moved to virtual environments, the data warehouse is often one of the last physical server in the data center. However, that doesn’t need to be the case, in this webinar you will learn about the challenges of implementing your BI environments in a virtual environment. This includes your data warehouse, and its ancillary systems like Analysis Services, Integration Services and Reporting Services. Finally, we’ll talk a little bit about how Azure VMs can change this guidance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 16

Time: 11:15 AM - 12:15 PM

Room: 219

What constitutes a view? Do we really need them in database development? Do they serve their purpose? Can we make them faster? At what point have we gone overboard with views? Just some of the questions that will be asked and answered...
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 16

Time: 11:15 AM - 12:15 PM

Room: 205

tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, where it can be used in an automated deployment pipeline, and introduce you to the tSQLt framework. We’ll show you how to design and write tests to enforce standards, check calculations and other DML operations as well as check exception handling. You will see how a real world refactoring task can be tested in a repeatable manner. Learn how you can incrementally write tests that help you build higher quality code and minimize the introduction of errors against your existing objects.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 16

Time: 3:00 PM - 4:00 PM

Room: 103

Tips and Tricks and Painful lessons learned as I have ventured into the world of Hadoop, JSon and Hive. Our data has made the move from a relational database to a JSon structure, and reporting across the entire enterprise of data has changed. We have introduced Hadoop batch processing to our ETL processes to collect and process data from various locations, depositing them in various other locations. Along the way, various brick walls were surmounted. We will discuss some of these brick walls. Some of the oddities encountered in this journey. and hopefully prepare you for a similar trip, without all the pain we suffered.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 16

Time: 1:45 PM - 2:45 PM

Room: 103

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: April 16

Time: 4:15 PM - 5:15 PM

Room: 202

After creating your perfect ETL process, how do you know if it is performing properly over time? It should be monitored and validated regularly. I will discuss several different types of validation as well as different methods to validate these attributes. I hope others will be willing to share their experiences with this session as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 16

Time: 3:00 PM - 4:00 PM

Room: 139

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