Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 31
In this session Thomas will explore and explain the different options that exist in SQL Server to temporary store data and show you when to use which and why not the others. This will cover #, ##, @,  Non-Durable Memory Optimized and regular user tables.  He will also present alternatives like common table expressions.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 29

Time: 2:00 PM - 3:15 PM

Room: LC24

Tired to look at colored and nice shape plans? Want to go further and see geek stuff? Came to this session to explore the query trees, internals and deep analysis on execution plans on SQL Server. This is a advanced session, so, expect to see lots of traceflags, undocumented and nasty execution plans.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Optimization/Tuning

Level: Advanced

Session Code:

Date: July 29

Time: 8:30 AM - 9:45 AM

Room: LC20

Are you a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you're considering AlwaysOn Availability Groups? This session is for you! I'll cover the pros and cons of four typical configurations of AlwaysOn Availability Groups: stand-alone instances, fail-over cluster instances, multi-subnet configurations, and disaster-recovery-on-the-cheap. I'll also discuss read-only routing, and implications and limitations of the Availability Group Listener. In addition, you'll learn why you should be using Windows Server 2012 R2 or above for your Windows clusters. Join me to learn which configuration options you should choose for your Availability Group.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 29

Time: 8:30 AM - 9:45 AM

Room: LC24

Do you consider yourself a beginner to T-SQL? This session will go over the basic T-SQL syntax for querying data. We'll break down the fundamental statements to look at the different parts to see how they work together. 

This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: July 29

Time: 12:30 PM - 1:45 PM

Room: LC21

SQL Server Integrations Services is a robust product, with lots of different options available to the ETL developer. One of the main components in SSIS is the Data Flow task. For someone new to SSIS, it can be daunting to be assigned a project to extract data from a source, transform it and then load it into its intended destination. What components do I use? Why pick one over another? Even if you are new to SSIS, it's good to have an understanding of what's going on under the hood when a data flow task is run. Come to this session to learn what non blocking, semi blocking and fully blocking transformations are. We'll explore how SSIS creates and manages memory buffers. You'll leave with a better understanding of how certain tasks and transformations can affect your package’s performance.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: July 29

Time: 12:30 PM - 1:45 PM

Room: LC24

It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.

In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.

You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: July 29

Time: 3:30 PM - 4:45 PM

Room: LC24

The hottest topic in Analytics is predictive modeling because it gives an enterprise a competitive advantage.  In this presentation we will explain the steps of creating a predictive model.  We'll discuss preliminary data analysis, determining the model to use, training the model, and using the model to predict outcomes, all with examples in the R programming language.     Learn what the excitement is about!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Big Data

Level: Beginner

Session Code:

Date: July 29

Time: 2:00 PM - 3:15 PM

Room: LC20

Both Power BI and SSRS will help you deliver compelling BI solutions, whether IT managed and/or self-service. For many companies it is important to deliver such solution as on-premises option.

In this session I will give you a tour of enhancements in SSRS 2016 including KPI, mobile & paginated reports. Mobile reports can now be viewed on any device; tablet, smartphone and desktop. 

I will also show you the newly introduced Power BI Report Server, that allows you to deploy Power BI Reports on-premises.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise BI

Level: Intermedia

Session Code:

Date: July 29

Time: 8:30 AM - 9:45 AM

Room: LC23

How big should the page file be for Windows Server 2016? How many data files should SQL Server 2016's TempDB contain? What trace flags should we use by default now?
 
These are questions you addressed long ago in your setup checklist. You've spent a lot of time with that checklist, and you're sure it's perfect. Or is it? When was the last time you visited that checklist?  Does it make sense for SQL 2014? What about SQL 2016? Change is hard, and DBAs need to constantly challenge yesterday's best practices to ensure they meet today's business needs.
 
Join veteran DBA Mike Hillwig and his list of server administration best practices that need to be revisited for modern versions of SQL Server, especially SQL 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 29

Time: 8:30 AM - 9:45 AM

Room: LC21

This session will contain a set of 10-minute lighting talks from 5 of our speakers:

Derek Hammer: Launch your database into the cloud!
In this lightning talk, I will explain bacpacs and demonstrate how they can be used to launch your database into the cloud.

George Walters: Making Something With Power BI in 10 Minutes
Do you think Power BI is hard? We will show you how easy it can be to get value out of data in under 10 minutes.

Paresh Motiwala: Fine Tuning Your Execution Plans
In this session, we'll discuss how best to shorten your backup times using both native SQL and third party tools.

Sunil Kadimdiwan: Graph data processing - SQL Server 2017
In this brief session I will demonstrate how to utilize graph database capabilities in SQL Server 2017.

Kevin Feasel: Learning Languages
The purpose of this light-hearted talk is to think a little bit about ways to sharpen our skills while still leaving at least a trace of free time.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Lightning Talks

Level: Beginner

Session Code:

Date: July 29

Time: 3:30 PM - 4:45 PM

Room: LC21

Query optimizer is getting smart, computers are taking DBAs jobs. In this session MVP Fabiano Amorim will talk about new “automatic” optimizations on SQL Server 2017. Adaptive query processing, auto tune and few other features added into the product. Are you taking weekend off? What about turn automatic tune to avoid bad queries to show up after an index rebuild or an ‘unexpected’ change?
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: July 29

Time: 12:30 PM - 1:45 PM

Room: LC19

PowerShell is the robust automation language for Windows. When extended with the Azure modules, you get a robust automation platform for Azure.  In this talk, we’ll explain how to create, inquire about, and manage Azure resources with PowerShell.  We’ll discuss the greatly improved Azure portal featuring Resource Manager which allows us to group resources together and what that means for our PowerShell development.  For those not using Azure Active Directory, we’ll explain how to create a Service Principal which is an application account so unattended PowerShell jobs can authenticate without human interaction.  Beyond Azure scripting, we’ll review ways to maximize the extensibility and reusability of your PowerShell code by creating custom modules, functions, and configuration frameworks.  If you plan to use Azure, you need PowerShell, the Azure automation language.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: July 29

Time: 10:00 AM - 11:15 AM

Room: LC24

Master Data Management is a discipline, Master Data Services and Data Quality Services are tools for implementation.  In this presentation you will learn the different types of data mastering.  Assuming you have the services installed and configured, the demonstration will walk you through a mastering implementation that requires DQS and MDS integration.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: July 29

Time: 2:00 PM - 3:15 PM

Room: LC22

If you're interested in Hadoop but don't know where to begin, this session will give you an idea of what you can do with the open-source platform.  We will see an overview of the Hadoop architecture, becoming familiar with the overall platform and its solutions for warehousing, ETL, streaming data ingest, in-memory processing, and more.  We will compare Hadoop to SQL Server to help gain an understanding of when to deploy which technology.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Big Data

Level: Beginner

Session Code:

Date: July 29

Time: 12:30 PM - 1:45 PM

Room: LC20

Did you know that most employers  -- whether looking for a full time employee, contractor, or consultant – interview people because of their technical skills and experiences, but hire and keep them for their social capital?  In times of economic downturn, it’s not the person who is the most competent who stays; it’s the one who’s most competent, likeable, and connected.   Socially adept people also get invited to the table more often for big projects and are promoted (or extended) more frequently than purely ‘competent’ individuals. 

Whether or not you’ve been in your role for a few months, years, or even decades – or you’re looking for a new job and new opportunities -- strategic networking is the way to make yourself more relevant, more attractive for projects and promotion – or more hirable by potential customers.  

Join us for an interactive session to strategize the best actions to increase your social capital and network your way to success!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional/Personal Development

Level: Beginner

Session Code:

Date: July 29

Time: 10:00 AM - 11:15 AM

Room: LC23

You need to deal with more security requirements in your role.  How can SQL Server features help you comply?  We will delve into Audit, Compliance, and Encryption.  New 2016 features like Always Encrypted will be detailed at the end.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 29

Time: 10:00 AM - 11:15 AM

Room: LC19

How outsource administrative tasks to your end user groups in a safe, secure, and repeatable pattern.   Now you no longer have to pause and stop what you are doing to create that new login, and replicate it to your Disaster Recovery.   You do not have to stop and perform a backup/restore to refresh the development environment.  Empower your end users, let them do this on their own without compromising your security.

There will be a demo!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 29

Time: 3:30 PM - 4:45 PM

Room: LC20

The SQL Server canvas gives us limitless opportunity for scripting and automation, and PowerShell is the perfect brush to paint with. Configuring our database servers, deploying database code changes, performing backups and restores are just a few examples of a day in the life of a DBA. Automation and scripting bring consistency, simplicity and scalability to many of these sometimes daunting tasks. 

Join me to learn how to paint your own SQL Server canvas with PowerShell.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: July 29

Time: 8:30 AM - 9:45 AM

Room: LC22

Wonder how to get into "Power BI"? Architecture of Power BI confusing you? Listen to George Walters discuss the architecture of Power BI from rich desktop authoring, to dashboards in the cloud.  We will finish with an interactive dashboard of data.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Self-Service BI

Level: Beginner

Session Code:

Date: July 29

Time: 2:00 PM - 3:15 PM

Room: LC23

Learn how to install a new SQL Server instance in less time than it takes to get a latte at Starbucks. 

My team manages hundreds of SQL Server instances, and performs dozens of installations every year. By automating our SQL Server install, each new server requires just a few minutes of effort before they are ready for use. Even if you only install a few SQL Server instances every year, introducing automation will save you time, and ensure a more consistent configuration. 

I will share my automation script, and show you different methods to add automation to your installation routine.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: July 29

Time: 10:00 AM - 11:15 AM

Room: LC22

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