Build Schedule

Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type





Sessions Found: 37
This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: April 09

Time: 3:45 PM - 4:45 PM

Room: Exec Conf (SQL Server Fundamentals)

This session is designed for production DBAs and Developers who are working on high volume data transfer.
I prepare many common mistakes people make with their  ETL jobs, and how to do it right.  I will introduce Minimal Logging, and discuss how to determine when minimal logging is appropriate.  Wewill compare logs that are fully logged and minimal logged.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: April 09

Time: 5:00 PM - 6:00 PM

Room: Mercury (Cloud & Big Data)

SQL Server 2014 includes a new cardinality estimator. This feature allows for statistics to be updated more frequently than previous versions of SQL Server, resulting in better query performance. Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 09

Time: 1:15 PM - 2:15 PM

Room: Jupiter (Database Administration)

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over SEVENTY times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: April 09

Time: 5:00 PM - 6:00 PM

Room: Exec Conf (SQL Server Fundamentals)

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

Time: 1:15 PM - 2:15 PM

Room: Nebula (Bonus)

A new era of business analytics is emerging, driven by an explosion of new data sources, an accelerated adoption of cloud computing, and a rise of machine learning and advanced analytics methods. Cortana Analytics, a fully managed big data and advanced analytics suite, embodies this paradigm shift. During the session, we will outline Microsoft’s advanced analytics vision, take a deep dive into the core components of Cortana Analytics Suite and demonstrate how Cortana Analytics streamlines data science processes and accelerates development of the state-of-the-art, intelligent solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (75 Minutes) (75 minutes)

Track:
Analytics & Visualization

Level: Intermedia

Session Code:

Date: April 09

Time: 4:45 PM - 6:00 PM

Room: Galileo (Big Stage)

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.

We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 09

Time: 3:45 PM - 4:45 PM

Room: Nebula (Bonus)

Amazon, Microsoft, VMWare, and many other companies are opening up Database-as-a-Service to the general public. These new database offerings can be perceived as a threat as well as a source of confusion to a DBA, but they're coming and you need to be ready.

In this presentation, Scott McCormick will cover Amazon's and Microsoft's DBaaS products. These are the leading SQL Server DBaaS vendors, and they have the most complete offerings to date. 

You'll learn about:
    * Current DBaaS flavors and their future
    * Use cases for DBaaS instances
    * Security Best Practices for a DBaaS environment
    * Pros & Cons of Amazon & Microsoft DBaaS
       *** Including a cost comparison of each performance tier
    * How to migrate your database
       *** A walk through of Amazon's AWS Migration tool
       *** A walk through of migrating to Microsoft's Azure SQL DB using replication
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: April 09

Time: 2:30 PM - 3:30 PM

Room: Saturn (BI & Dev)

How many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? Where do you start tuning? When do you stop tuning? Each application is different. With the ever increasing number of systems one production DBA has to manage today, it's very important to use TOP to BOTTOM approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration. 

While you can find top queries, wouldn't it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour and current situation? Now you can focus on those specific queries!

In this session, Prakash walks you through with scenario & demos to find which exact queries are taxing production systems resources based on CPU/DISK/Memory/Network. They are all based on his own real-life experience from managing demanding database systems.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: April 09

Time: 10:30 AM - 11:30 AM

Room: Nebula (Bonus)

We will discuss the various methods of presentation of data in applications, connectivity and services available in the Azure Mobile Apps suite. We will create a database and webserver and discuss the options available to the novice mobile developer to get started quickly with a limited set of knowledge about mobile applications. We will specifically use C# and Swift 2  for development and XCode and Visual Studio to demonstrate the mentioned functions. We will  also briefly discuss Xamarin, Android, Android for Work and Hybrid Technologies.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: April 09

Time: 5:00 PM - 6:00 PM

Room: Saturn (BI & Dev)

Most DBA's rarely establish Service Level Agreements (SLA) with the Management and if they do they sometimes just come up with some random numbers for availability. Then when at some point something goes really wrong everybody wonders why it takes so long to bring everything back online.
 
This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 09

Time: 5:00 PM - 6:00 PM

Room: Jupiter (Database Administration)

By now, Tier 1 apps deployed on flash is ubiquitous.  However, Tier 2 apps often remain relegated to spinning media.  This presentation explains the economics of consolidating on flash.  Owing to the SQL Server core licensing model, licensing a 2-socket commodity server can cost up to $500,000 or more!  Consolidating instances on flash can—and does—save hundreds of thousands to millions of dollars.  This presentation provides real-life case studies showing such real-life savings.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 09

Time: 11:45 AM - 12:45 PM

Room: Mercury (Cloud & Big Data)

Like Frankenstein's Monster (or our teenagers) things get released into the wild and behave differently than planned - database usage patterns are no different.  Join Tim as he reviews what to look for when tweaking your index strategy: poor clustering key decisions, underutilized indexes, covering indexes gone wrong, overlooked heaps and fill factor failures are just a few of the blunders to be identified.  

A working knowledge of Dynamic Management Objects, indexing internals, and eagerness to experiment with metadata is a prerequisite!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: April 09

Time: 2:30 PM - 3:30 PM

Room: Jupiter (Database Administration)

Don’t be fooled by a vendor’s claims that their BI tool is all you need to solve your organization’s business intelligence needs.  In this session we will discuss the varied business intelligence needs of an organization and how to solve them.  Understand the differences between reporting and analytics and between self-service needs and the needs of IT.  We will see examples of using the best tools for the best job and bringing them together in a unified interface.
Speaker:

Accompanying Materials:

Session Type:
Sponsor-Centric Session (30 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: April 09

Time: 11:45 AM - 12:15 PM

Room: Saturn (BI & Dev)

In Memory OLTP is one of the most popular features of SQL Server 2014. Many BI professionals are finding memory optimized objects make excellent tools in the quiver of the ETL developer as well.  Attend this session to see how "hekaton", memory optimized objects, native stored procedures, and schema only designs can be applied to staging and transformations to achieve  incredible performance gains over traditional models.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 09

Time: 3:45 PM - 4:45 PM

Room: Saturn (BI & Dev)

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign. 

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 09

Time: 2:30 PM - 3:30 PM

Room: Saturn (BI & Dev)

Whether you are an Excel Pro, BI Developer, or Data Architect, sooner or later you're going to find it helpful to know a little DAX and a few DAX Patterns. DAX, the Data Analysis Expression Language is the future of insight development in tools such as: Excel, Analysis Services Tabular, and the new Power BI Desktop. Using DAX and these DAX Patterns, you'll be able to define both centralized and ad hoc metrics for blazing fast data analysis!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics & Visualization

Level: Beginner

Session Code:

Date: April 09

Time: 10:30 AM - 11:30 AM

Room: Saturn (BI & Dev)

Introduction to IoT
Strategy for IoT
IoT Use Cases
IoT Analytics
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: April 09

Time: 3:45 PM - 4:45 PM

Room: Mercury (Cloud & Big Data)

LT1:
Title: SSRS report development for SSMS
Description:  Have you ever used the standard Microsoft reports in SSMS, reports that help show server activity, performance counters or missing indexes?  Ever thought you could make a better looking report, or just wanted to visualize something else in your environment?  This session will outline how to develop SSRS reports for use in SSMS, showing some of the default parameters that SSMS uses.  We'll also see some live reports visualizing jobs and databases as an example.

LT2:
Title: Getting Started with SQL Server Data Compression
Description: The Enterprise Edition of SQL Server has offered native data compression since the 2008 version, but are you using it?

LT3: 
Title: Hidden Gems of SSMS
Description: We will show you some of the unknown features of SSMS that will make your life easier.

LT4:
Title: Auditing using SQL Audit
Description: This session will provide a quick overview of auditing user actions using SQL Server Audit
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Bonus

Level: Beginner

Session Code:

Date: April 09

Time: 5:00 PM - 6:00 PM

Room: Nebula (Bonus)

Trent will show you to get real-time notification and rapid diagnoses of your SQL Server performance problems using Dell Software’s Spotlight on SQL Server. Spotlight on SQL Server gives real-time alerts and brings together all of your critical SQL Server metrics onto a single dashboard-type screen, color-coded for problem severity and clickable for drilling down to the details and root causes of problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor-Centric Session (30 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: April 09

Time: 11:45 AM - 12:15 PM

Room: Galileo (Big Stage)

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