Build Schedule

Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type


Sessions Found: 49
DevOps is the melding of application development, testing, and IT operations. All tasks from infrastructure to coding to testing to transition into production must be automated so that new features and fixes can be continuously delivered.

Constraining DevOps is data. Databases and applications have grown enormous and complex. "Storage is cheap" is a lie. Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, and code quality suffers.

Data virtualization is the solution. Virtual databases and file-systems only consume space from deltas, so it is possible to provision multiple terabytes for megabytes. Coders and testers have full environments fast in which to develop and test, improving code quality.  Learn about the technical details behind this solutio
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Intermedia

Session Code:

Date: October 01

Time: 1:30 PM - 2:30 PM

Room: Schulze 316

The world's most powerful virtualization platform, VMware vSphere, contains a number of hidden gems that DBAs can use to make their SQL Servers more highly available and perform better. The demos in this session have been developed to illustrate a few key capabilities of VMware vSphere and VMware NSX that can be used to enhance the overall SQL Server implementation. Features such as vSphere vMotion, vSphere HA, Distributed Resource Scheduler and Fault Tolerance are complimentary to all the features and capabilities of SQL Server and create an unparalleled combination of the world’s top RDBMS and the world’s most complete and effective virtualization proposition. With network virtualization NSX can provide security enhancements unachievable with any other technology and can streamline SQL server deployment automation processes. Please join us for this demonstration of advanced vSphere and NSX feature functionality and an explanation as to how this enhances your SQL Server environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: October 01

Time: 10:40 AM - 11:40 AM

Room: Schulze Auditorium 120

We’ll examine how to leverage big data to extend SQL Server particularly around archive patterns. Demos include moving data into Hadoop for query and batch processing as wells as leveraging Spark for fast batch processing.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Big Data

Level: Intermedia

Session Code:

Date: October 01

Time: 4:00 PM - 5:00 PM

Room: Schulze 419

Developers are building Data warehouse solutions to satisfy business requirements. Good developers design solutions with flexibility in mind anticipating requirement’s changes. Great developers deliver solutions that exceed requirements, performance expectations and are long term manageable.
 
In this session we will learn design patterns that allow for delivery of flexible and sustainable solutions through Data Warehouse life cycle avoiding making common architectural mistakes.
We will answer What? How? and Why? questions about capturing data, designing ODS, ETL, dimensional Data warehouse, symantec and presentations layers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: October 01

Time: 10:40 AM - 11:40 AM

Room: Schulze 419

A panel of SQL Server experts take on all questions..
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Beginner

Session Code:

Date: October 01

Time: 4:00 PM - 5:00 PM

Room: Schulze 301

This session is designed to be useful to two different audiences:
1.Those implementing Ola Hallengren’s Maintenance Solution for the first time. (Or don't even know what the Maintenance Solution is!)
2.Those that have been using it for awhile, but might have a hole in their DR plan – what to restore when a resource goes offline.

We will do an overview of the maintenance solution to start, then get down and dirty with the guts of the extension. What I am presenting is a custom extension that works out of the box for jobs created using the maintenance solution. The scripts will add an additional job step to all DatabaseBackup jobs which will output a text file that contains the most current restore scripts for each database in the instance.
If you don't know what I just described in that last paragraph, you should come to this session and that will be explained as well!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: October 01

Time: 2:45 PM - 3:45 PM

Room: Schulze 302

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:
Database Administration

Level: Intermedia

Session Code:

Date: October 01

Time: 8:00 AM - 9:00 AM

Room: Schulze 419

Battle scars are proof of the struggles endured and won.  Find out about one particular battle in porting a SQL Server application to Netezza.  In this session, we’ll review Big Data platform options and the differences between them.  We’ll see how Massively Parallel Processor (MPP) systems (like Netezza) are different from Symmetric Multi-Processor (SMP) systems (like SQL Server) and witness the lessons learned in the struggle.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 01

Time: 1:30 PM - 2:30 PM

Room: Schulze 127

ETL development can consume a significant portion of time in Data Warehousing initiatives.  It can also be very cumbersome to change ETL patterns across a large number of objects.  This session will look at how BIML + metadata can be leverage to significantly reduce ETL development time.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Advanced

Session Code:

Date: October 01

Time: 8:00 AM - 9:00 AM

Room: Schulze 302

To get the most from our SSAS Tabular and Power BI models, we must be able to create robust DAX expressions. This requires a solid conceptual understanding of DAX expressions, especially the interaction of aggregates and filters with the Calculate() function. In this session, we will also look at time analytics and hierarchies within DAX expressions. As we explore the ins and outs of DAX expressions, we will call out new features and functionality available in DAX in SQL Server 2016.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 01

Time: 9:25 AM - 10:55 AM

Room: Law 235

What is cardinality estimation and how statistics affect your execution plan. In this session we'll cover the mechanics behind cardinality estimation and why it is so critical to query performance. We will also be discussing some of the changes that were made to the estimator in SQL Server 2014 and how you can benefit from these changes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: October 01

Time: 2:45 PM - 3:45 PM

Room: Schulze 127

As the tools available for BI and data warehousing continue to improve, it should change the way we ultimately deliver BI solutions. Microsoft's BI solutions help us keep data closer to the source. As data and BI architects, we need to design solutions that can support this model. Consumption Based Architecture is one such architecture. The goal of this architecture is to plan and design solutions that minimize ongoing maintenance and enable users quicker and more complete access to data. Some highlights are how tabular models and PowerPivot support this process and where does MDM for BI fit in. Ready to discuss the "death of enterprise data warehouses"? Join the conversation in this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: October 01

Time: 10:40 AM - 11:40 AM

Room: Law 238

2016 is the year of All-Flash for primary storage and DELL EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, DELL EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type. 
 
Beyond just production database performance, DELL EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Intermedia

Session Code:

Date: October 01

Time: 12:15 PM - 1:15 PM

Room: Schulze Auditorium 120

Dimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements.

In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: October 01

Time: 2:45 PM - 3:45 PM

Room: Schulze Auditorium 120

How often do you review your SQL Servers for basic security, maintenance, and performance issues?  Many of the servers I "inherit" as a managed services provider have quite a few gaping holes. It is not unusual to find databases that are never backed up, servers with constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that even have too much!) 

Come learn how to use freely available tools from multiple layers of the SQL Server stack to check your servers for basic issues like missing backups and CheckDB as well as for more advanced issues like page life expectancy problems and improper indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: October 01

Time: 8:00 AM - 9:00 AM

Room: Schulze 301

Everybody loves a free lunch. Come to this session to learn about all the SQL Server freebees.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server

Level: Beginner

Session Code:

Date: October 01

Time: 4:00 PM - 5:00 PM

Room: Schulze 301

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated?  In this session, we will examine details the query optimization process that are not very well known.  We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient.  Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos?  We'll do just that, and then take it a step further with a unique visualization tool that I have created.  With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: October 01

Time: 2:45 PM - 3:45 PM

Room: Law 238

You've got knowledge to share. Maybe you like the idea of blogging or presenting, but what really gets your heart pounding is making videos. How do you get your big ideas to the big screen? Making technical videos doesn't have to be hard; you just have to focus on the right details.

Topics we'll cover include: The essential steps of planning, shooting, editing, and publishing your video; the best video-making gear to buy for any budget, and how to get the most out of that gear; how to make your video stand out from the rest on platforms like YouTube and Vimeo; how videos have a unique way of connecting you and your material to your audience.

You'll hear my insider tips and lessons I've learned from years of creating technical training videos. You'll learn mistakes that even experienced video creators make, and how to avoid them. We'll also tear down the myths and misconceptions that are holding you back from getting started.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 01

Time: 2:45 PM - 3:45 PM

Room: Schulze 301

Setting up a Hadoop cluster can be a long, expensive and frustrating experience.  Adding nodes can take days, weeks, or months.  What if you could have a Hadoop cluster up and running in 20 mins and could add nodes in minutes?  Come to this demo heavy session on provisioning HDInsight and wrangle some data!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Big Data

Level: Beginner

Session Code:

Date: October 01

Time: 1:30 PM - 2:30 PM

Room: Schulze 301

Employee/manager relationships, family trees, and the like are all hierarchical data. In this session, we'll look at a common way to represent such relationships, common methods of querying them, and how we can leverage the hierarchyid datatype to make queries go a lot easier and faster!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: October 01

Time: 10:40 AM - 11:40 AM

Room: Law 235

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