Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type



Sessions Found: 70
Be it a T-SQL developer or DBA, we spend most of our time working in SQL Server Management Studio. In this session, we will learn a number of tips and tricks to increase productivity and efficiency in SSMS IDE. We will also look at the new and improved features of SSMS 2016. We will learn how adding few free third party tools to the SSMS IDE will enhance your coding speed. This will be a content rich session with plenty of live demonstrations.

By the end of this session, you will learn some useful techniques to take back with you and apply in your day to day work.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Intermedia

Session Code:

Date: January 14

Time: 2:50 PM - 3:50 PM

Room: S279

So many of us have learned data modeling and database design approaches from working with one database or data technology. We may have used only one design tool.  That means our vocabularies around identifiers and keys tend to be product-specific.  Do you know the difference between a unique index and a unique key? What about the difference between RI, FK and AK? Do you know if your surrogate keys have their companion alternate keys?  Do you know about weak versus strong keys?

In this session we’ll look at the generic and proprietary terms for these concepts, as well as where they fit in the data modeling and database design process.  We’ll also look at implementation options in SQL Server 2016 -- what works, what really doesn't work, and what mistakes are commonly made in implementing keys.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: January 14

Time: 9:45 AM - 10:45 AM

Room: S305

The problem with most PowerShell "beginner's tutorials" is that they almost always go way beyond the basics. In this session we cover the true basics, focusing primarily on only three cmdlets: Get-Command, Get-Help, and Get-Member, in the context of SQL Server.
Speaker:

Accompanying Materials:

No material found.

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

Track:
PowerShell

Level: Beginner

Session Code:

Date: January 14

Time: 11:00 AM - 12:15 PM

Room: S334

Autonomous/nested transactions are available in other database products, but are not natively supported in SQL Server. Fortunately there are several methods available to provide this functionality. 

We'll cover the standard table variable techniques to preserve data outside of transaction scope, and how the new in-memory table type can improve their performance.  Other techniques like user-defined events, CLR procedures, linked servers will also be demonstrated, and how they can enhance functionality.

We'll review minimal techniques like RAISERROR and the new SESSION_CONTEXT() feature in SQL Server 2016, to provide different levels of logging and transaction management.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: January 14

Time: 1:30 PM - 1:45 PM

Room: S275

With more and more data moving to the cloud it's time DBA's began learning how to automate their cloud environments. Many have already begun to do this using PowerShell and this is a great way to start but in this session we'll take it to the next level and learn about Azure Automation, Runbooks, and PowerShell Workflows. Whether you need to pause and resume Azure SQLDW on a schedule, load or re-load an Azure SQLDB, check and react to specific conditions, or even complete more advanced tasks, Azure Automation and Runbooks can help. In this session we'll cover the basics of Azure Automation and walk through creating a PowerShell Workflow or two. We'll also learn about variables, schedules, credentials and how they work with Azure Automation so that you can take full advantage of your Runbooks. Come learn how you can make your cloud life easier as well as save time and money using Azure Automation and Runbooks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Database/Application Development & Deployment

Level: Intermedia

Session Code:

Date: January 14

Time: 11:00 AM - 12:00 PM

Room: S274

The cloud is the new great tool in our toolbox. It offers the ability to quickly create and remove IT resources on-demand, at high value. This is a great opportunity for developers and organizations to spin up new solutions and test them without large capital investments. The real value in the cloud comes in to play when you are able to spin up and spin down resources, and their sizes as demanded by the application. Attendees of this session will learn how easy it is to automate creation and alteration of Azure resources from the PowerShell command line, and why that's important. We'll talk through different architecture types for cloud services where this is important.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PowerShell

Level: Intermedia

Session Code:

Date: January 14

Time: 2:50 PM - 3:50 PM

Room: S213

There is no place like home, there is no place like home! When a database crashes and you have to recover it, this may be what you're saying to yourself over and over.  It can feel like a house just landed on you if you're not prepared.  Ok, not really, but recovering a database from an unexpected event is often just as terrifying! If you aren't prepared for it, it's really going to hurt.  So what do you do? You prepare. You plan. You practice.  We'll talk about how the backup & restore process works in SQL Server and how it can help you prevent a Wizard of Oz situation!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: January 14

Time: 11:00 AM - 12:00 PM

Room: S270

Users want Data Warehouses built, but no one ever builds one for the DBA. Let's fix that!

Get information from Active Directory, your Windows Servers, SQL Servers and other sources that mean something and will help you to keep the databases running smoothly. Be able to see which disks/machines are low on disk, what databases are on which SQL Servers, when backups happened and if any jobs failed.

This is targeted at the DBA who is responsible for multiple SQL Servers, in multiple places, and doesn't have time to "point and click" their way to a comfortable understanding of the moving pieces on all of the systems that they need to monitor!

NOTE: This session covers how to BUILD the warehouse, how to collect information and store it in relational tables in a way that makes sense as a warehouse. I'm developing a follow on session that presents the collected data using BI tools.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: January 14

Time: 1:30 PM - 2:30 PM

Room: S274

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!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: January 14

Time: 2:50 PM - 3:50 PM

Room: S274

We have more information available to us today than ever before.  So much so that we run the risk of not being able to tell concise stories.  There's a lot more to creating that story than just getting the correct information.  Come learn not just the do's and don'ts, but the whys…
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics and Visualization

Level: Beginner

Session Code:

Date: January 14

Time: 1:30 PM - 2:30 PM

Room: S270

In this session we will review the new enhancements to SQL Server security available in SQL Server 2016 and Azure SQL DB, including Always Encrypted, Row-Level Security, and Dynamic Data Masking, as well as whatever else Microsoft has released since this abstract was written. We'll look at how to set these features up, how to use them, and most importantly, when to use them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: January 14

Time: 1:30 PM - 2:30 PM

Room: S260

So you have a good backup strategy in place, but now you have to think about a disaster recovery.  Where do you start and what are your options?  SQL Server offers several options, but then how do you choose the right one to meet your business requirements?  In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and AlwaysOn.  Then we will talk about how to choose the best one to meet your business needs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: January 14

Time: 11:00 AM - 12:00 PM

Room: S275

As a database professional, you have plenty of choice in your career path. Should you stay at the same company for 20 years, or change every few years? Much depends on what matters most to you. Do you want higher income, regular work hours, training, vacation time, group insurance, job security, lots of travel, telecommuting, or the possibility to advance to management?  The panel will give their observations and experience over decades of experience. Discussion will include at least one person who has spent over 19 years with the same employer, one person who has changed careers very recently, and everyone in attendance who is willing to give an opinion.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: January 14

Time: 12:20 PM - 1:20 PM

Room: S128

Before you go and move that mission critical application to a new version of SQL or new hardware you are probably creating some sort of testing and benchmarking scenarios to ensure a smooth upgrade.  Right?  Come learn how distributed replay can capture your workload and play it back on your new instance. Be it an upgrade of SQL or hardware we can review all sorts of scenarios to help make your upgrade a smooth process.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: January 14

Time: 1:30 PM - 2:30 PM

Room: S309

Performance tuning can be complex.It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

 1. Quickly fine tune a SQL statement
 2.  Identify performance inhibitors to help avoid future performance issues
 3.  Recognize and understand how new SQL Server features can help improve query    
      performance
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database & Application Development

Level: Intermedia

Session Code:

Date: January 14

Time: 9:45 AM - 10:45 AM

Room: S279

Learning how to detect, diagnose and resolve performance problems in SQL Server is tough.  Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.  

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

• XEvents, Profiler/Traces, and PerfMon 
• Using Dynamic Management Views (DMVs)
• Advanced Diagnostics Using Wait Stats
• Reading SQL Server execution plan 

Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: January 14

Time: 9:45 AM - 10:45 AM

Room: S260

R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics and Visualization

Level: Intermedia

Session Code:

Date: January 14

Time: 8:30 AM - 9:30 AM

Room: S270

The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/Azure SQL DB with predicate based RLS.  


This session will show how organizational & asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/Azure SQL Database without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations. 


Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating the database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS using Power BI as a test application.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: January 14

Time: 2:50 PM - 3:50 PM

Room: S260

For decades batch processing has been the defacto standard for Extract Transform and Load.  For most of that time 24 hour data refresh cycles were accepted as part of Business Intelligence solutions and developer skill sets have long dependent upon the reliable patterns of batch. In recent years, however, demands have begun to shift. New use cases in every industry are now causing leading edge BI solutions to demand much shorter time to realizing value. The old architecture, skills, and tools are proving insufficient to meet this demand. In this session we will look at the fundamentals of architecting real-time BI solutions, including the new categories of problems for which we will now have to solve.  Upon completing the session attendees will have a clear picture of the new skills and patterns that must be learned in order to excel in the next phase of Business Intelligence evolution.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture & Management

Level: Intermedia

Session Code:

Date: January 14

Time: 11:00 AM - 12:00 PM

Room: S276

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache. 

Reading execution plans becomes much less intimidating as we walk 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, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.
Speaker:

Accompanying Materials:

No material found.

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

Track:
Database & Application Development

Level: Beginner

Session Code:

Date: January 14

Time: 11:00 AM - 12:15 PM

Room: S314

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