Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 45
This session will demonstrate how to offload your resource intensive data transformations to a Hadoop cluster using Sqoop and move the results back to your SQL Server quickly and easily.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Big Data

Level: Intermedia

Session Code:

Date: August 08

Time: 1:00 PM - 2:00 PM

Room: Room 200

Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA - Administration

Level: Beginner

Session Code:

Date: August 08

Time: 9:15 AM - 10:15 AM

Room: Room 208/210

SQL Server 2012 introduced columnstore indexing but with one major drawback -- columnstore indexes were not updateable.  Thus, adopting them to improve data warehousing (or other) query patterns took careful planning and quite a bit of management.  SQL Server 2014 introduces clustered columnstore indexes that are now fully updateable!  During this session, we'll take a look at how clustered columnstore indexes work, what implications exist for using them, and how the update process is handled.  We'll also take a look at what management and maintenance operations are required to keep clustered columnstore indexes performing optimally.  Anyone with a large data warehouse environment (or even an OLTP or ODS database with very large tables) will definitely want to attend!  
Speaker:

Session Type:
Regular Session

Track:
DBA - Database Development

Level: Advanced

Session Code:

Date: August 08

Time: 8:00 AM - 9:00 AM

Room: Room 104

There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: August 08

Time: 1:00 PM - 2:00 PM

Room: Room 108/110

If you've ever looked at the visualizations available in Power BI for Office 365 or the robust sharing capabilities available with the cloud service, but the requirement of uploading/storing data in the cloud was a deal-breaker, there is a new option available for you in the current Power BI Preview. The new Power BI Analysis Services Connector allows you to directly query on-premises SSAS Tabular data for display in Power BI. In this session, we'll go through installation and configuration of this Connector which can open all-new data sources for use in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Enterprise BI

Level: Beginner

Session Code:

Date: August 08

Time: 10:30 AM - 11:30 AM

Room: Room 215

Put on your CSI caps as we delve into the anatomy of a Very Large Data Warehouse environment!  During this case study session, we'll take a look at the data warehouse environment at the Department of Veterans Affairs.  The VA is the largest healthcare organization in the US and has an extensive national DW and BI infrastructure, now in its seventh year of evolution.  We'll take a look at the database infrastructure, the data loading process, and the various reporting and analytics solutions that provide over 150,000 knowledge workers and report consumers with timely data and information.  We'll also take a look at some of the processes in place to support the myriad of extended reporting and analytics teams throughout the VA who build and manage second-tier downstream data marts and other reporting solutions.
Speaker:

Session Type:
Regular Session

Track:
Enterprise BI

Level: Intermedia

Session Code:

Date: August 08

Time: 9:15 AM - 10:15 AM

Room: Room 108/110

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!
Speaker:

Session Type:
Regular Session

Track:
DBA - Database Development

Level: Intermedia

Session Code:

Date: August 08

Time: 10:30 AM - 11:30 AM

Room: Room 108/110

Data warehousing professionals often consider data profiling to be drudgery and/or an unnecessary part of the larger warehouse design process.  However, information unearthed during this process can prove instrumental in avoiding pitfalls later on.  This session will explore the reasons for profiling and scenarios in which it proves particularly useful.  We will also discuss profiling methods, including the SSIS profiling task and supplemental profiling techniques that provide both developers and business users insight into the quality and consistency of source data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Enterprise BI

Level: Intermedia

Session Code:

Date: August 08

Time: 1:00 PM - 2:00 PM

Room: Room 114

John knows everything and goes out of his way to correct you at every turn.  Mary is agreeable to a fault and just placates everyone.  Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: August 08

Time: 3:30 PM - 4:30 PM

Room: Room 111

A "Disaster" doesn't need to be on a massive scale to cause widespread destruction in your enterprise. Simple things like failing hardware, strange storage bugs, a forgotten WHERE clause, or an angry employee can either cause devastation or be just a nuisance to the properly-prepared DBA. This session is a survey of recovery techniques that should be in every DBA's toolbox.
Speaker:

Session Type:
Regular Session

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: August 08

Time: 2:15 PM - 3:15 PM

Room: Room 111

Whether a company has 1 database containing 1GB of data or hundreds of databases containing terabytes or even petabytes of data, at some point they all have the same question..."What is the quality of our data?". A business runs off of it's data and if that data isn't complete, consistent, and accurate bad decision can be made. Come to this session and learn how to tell if your data is quality data worthy of making decision from. We'll learn what it means to have quality data and how you can measure the quality of your data using the Data Quality Services (DQS) component of SQL Server. Together we'll explore this lesser known part of SQL Server and learn how it works and how you can start using it to measure and improve the quality of your data and thus the decisions being made from it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Enterprise BI

Level: Beginner

Session Code:

Date: August 08

Time: 3:30 PM - 4:30 PM

Room: Room 208/210

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these data type choices can be a real performance killer? 

Attend this session to learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! 

When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA - Database Development

Level: Intermedia

Session Code:

Date: August 08

Time: 10:30 AM - 11:30 AM

Room: Room 104

Abstract: As a beginner database professional, execution plans are intimidating. In this 1 hour session, I will take you through the basics of reading graphical execution plans and drill into key operators, warnings and properties.
Prerequisites: Basic understanding of T-SQL and the SQL Server Engine.
Sections:
•	You will understand how, why and when the execution plan will be created and saved to plan cache.
•	Reading the execution plan will be much less intimidating as you can talk through the flow and process of a graphical execution plan. 
•	After looking at the key operators you will be able to analyze the operators of your execution plans, the operator properties and identify common performance issues and tuning opportunities.
•	Finally, you will be able to capture the execution plan, save it for later analysis and comparison after modifications have occurred. 


Speaker:

Session Type:
Regular Session

Track:
DBA - Administration

Level: Beginner

Session Code:

Date: August 08

Time: 2:15 PM - 3:15 PM

Room: Room 114

Flash storage is a game changer for virtually every app in which it is used.  Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head.  Contemporary IT environments should standardize their architecture including a tier of flash.   Virtualized or non-virtualized, standardizing on in-server flash is vital for optimizing performance, scalability, efficiency (technical and cost), reliability, & availability.  Learn how flash flips the /faster bit & the significant impact flash makes not just in terms of performance, but also best practices, & the massive savings in licensing driven by consolidation on flash.
Speaker:

Session Type:
Regular Session

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: August 08

Time: 2:15 PM - 3:15 PM

Room: Room 104

Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization's data. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Enterprise BI

Level: Beginner

Session Code:

Date: August 08

Time: 8:00 AM - 9:00 AM

Room: Room 108/110

Are you just breaking into the query tuning side of managing your SQL Servers?  In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process.  We will discuss how SQL Server creates and uses plans, and how to collect them.  Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean.  We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance.  We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.

Speaker:

Session Type:
Regular Session

Track:
DBA - Administration

Level: Beginner

Session Code:

Date: August 08

Time: 10:30 AM - 11:30 AM

Room: Room 208/210

In this session we will examine how SQL Server replication works.  A technology that has been around, this tool is not going anywhere anytime soon.  It's an excellent way to keep a subset of data synched with another database without having to synch the entire thing (although you could if you wanted to!).  We will examine terms, internals, and walk through the setup of transactional and snapshot replication pieces so you can implement this technology in your environment and use it as a valuable tool in your personal knowledge book.
Speaker:

Session Type:
Regular Session

Track:
DBA - Administration

Level: Beginner

Session Code:

Date: August 08

Time: 9:15 AM - 10:15 AM

Room: Room 111

You have to be compliant, but can’t change source code, or SQL code. What’s your option? Transparent Data Encryption (TDE) of course! 
The real question though, is just how transparent is TDE?
In this, the second installment of the Hacking Exposé series, we will assume the role of a hacker once more and dig into our database and steal our backups and data files. We will then try to restore the files, and even dig into the files themselves and see what might be exposed.
We then go through the steps to lock down our data using TDE.
Once again we assume the role of a hacker and try to dig through the database, steal backups and data files and see just what is available to us.
*Warning - Do not try these demos at work without proper permissions as some actual hacking techniques are used.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: August 08

Time: 3:30 PM - 4:30 PM

Room: Room 215

With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.
Speaker:

Session Type:
Regular Session

Track:
DBA - Database Development

Level: Intermedia

Session Code:

Date: August 08

Time: 10:30 AM - 11:30 AM

Room: Room 111

There are two kinds of DBAs in the world -- those who have experienced corruption, and those who will.  Join me for this session to learn what corruption is, how it can occur, and how to check if your data is corrupt.  And if you do find corruption, I will show you how to identify what data is affected using DBCC CHECKDB and DBCC PAGE.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: August 08

Time: 1:00 PM - 2:00 PM

Room: Room 104

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