Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 36
While the web portal makes it easy to deploy SQL Server on Azure Virtual Machines, there are a number of benefits to using PowerShell to do the job. This session will introduce Azure PowerShell command-lets and how to create a basic Azure infrastructure to support a SQL Server VM. We'll include the Azure Resource Manager, how to use ARM VM templates and Custom Script Extension, and how users can modify an existing Azure Gallery template. Desired State Configuration (DSC) will be covered to complete the Azure Powershell automation toolkit, allowing attendees to automate the deployment of dozens or more SQL Server virtual machines. Finally, we will configure Availability Groups and explain their eccentricities in the Azure environment as well as how to make them work effectively.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 06

Time: 3:30 PM - 4:30 PM

Room: 202

Defining and documenting a backup strategy in today's data platform is simply not enough to prevent a major catastrophe. For that, a company needs to define a recovery strategy that encompasses their backup solution with an appropriate, tested recovery plan. This session outlines the various backup strategies and how to implement them in a recovery scenario to minimize data loss.  This session will discuss various case studies of backup strategy implementations that neglected a strong recovery strategy and resulted in catastrophe for the company. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 06

Time: 1:00 PM - 2:00 PM

Room: 206

How are your servers running? What is going on in your SQL Server? How are you trending? When will you need the next server? Do you need to throw more hardware at SQL or more query tuning? (Or both?) In this session – we will share some free tools, techniques and approaches you can take right now with resources you already have to answer these questions and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 06

Time: 9:45 AM - 10:45 AM

Room: 203

We have all encountered difficult managers that leave us stressed out.  They can be micro-managers, bullies, too timid, or even just apathetic.  In any case, you are currently stuck with this manager, and you need coping strategies!
Through case studies and open discussion, we will help you determine if you indeed have a difficult manager.  We will identify and categorize behavior patterns of managers so that you can determine the best strategies to deal with him or her.  In addition, we will also explore the consequences of these actions, and how they can help you to succeed in furthering your career.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 06

Time: 3:30 PM - 4:30 PM

Room: 205

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 (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 06

Time: 2:15 PM - 3:15 PM

Room: 206

A big hurdle for using Powershell and SQL Server together is the SQLPS module. Both old and new users of Powershell don’t completely understand its capabilities. In this session, we’ll talk about the cmdlets you may not know about, tricks to save time using the provider, and even a few gotchas on how the provider works that can save you some time and energy. When we’re finished, you will have a deeper understanding of how you can use SQL Server and Powershell together.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 06

Time: 11:00 AM - 12:00 PM

Room: 202

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 06

Time: 3:30 PM - 4:30 PM

Room: 206

SQL Server 2016 significantly raises the bar in terms of data security.  One of the most exciting features introduced in the newest release of SQL Server is Always Encrypted.  This feature ensures that data remains encrypted in its entire lifecycle - at rest as well as in transit.  Additionally, the encrypted data can be made completely inaccessible to database administrators.  With the assistance of an updated .Net client-side driver, this great new feature ensures that applications can leverage Always Encrypted data without application code changes.  In this demo-rich session we will look at how to enable and configure Always Encrypted as well as how applications can be configured to use this amazing new technology.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 06

Time: 1:00 PM - 2:00 PM

Room: 201

SQL Server replication is an excellent way to keep a subset of data synced with another database for reporting, audit, or recovery purposes.  In this session we will examine terms, internals, and walk through the setup of transactional and snapshot replication so you can utilize it as a valuable tool in your toolkit.  We will also examine some ways to make replication perform better as well. This session is targeted towards database administrators who have little to no experience with replication and developers looking for different ways to duplicate data for reporting or data consumption.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 06

Time: 1:00 PM - 2:00 PM

Room: 202

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering.  This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too.  When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 06

Time: 11:00 AM - 12:00 PM

Room: 203

PowerPoint can enhance the presentation of any speaker or business professional, but using it effectively in your sessions or presentations can be difficult without practice. In this session, you will learn how to take your PowerPoint skills to the next level, using more advanced transitions, animations, and media forms in your presentations. This will help you engage your audience and communicate visually instead of just verbally, making your presentations more effective. After attending this session, you can feel confident that your PowerPoint skills have improved.   
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 06

Time: 9:45 AM - 10:45 AM

Room: 206

It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important.  Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening.  This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive.  We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers.  Additionally, some suggestions as to where to find more information will be provided. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 06

Time: 8:30 AM - 9:30 AM

Room: 206

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it.  This session includes demonstration and use case scenarios.  The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: August 06

Time: 3:30 PM - 4:30 PM

Room: 203

Most of us are overwhelmed with data from all the different applications that we use on a daily basis.  Bringing all the data together is often a very time-consuming and sometimes a challenging process.  Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome.  Now with Power BI this can all be made very simple.  Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop.   In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: August 06

Time: 2:15 PM - 3:15 PM

Room: 203

It’s easy to find useful data on the Internet, model the data and construct a BI Dashboard using Power BI Desktop.  The application used in this session shows on-time performance of domestic flights.
Using government data this is available, you can answer these questions:
1.	Which airlines have the best on-time performance?
2.	Which flights between airports are regularly on-time?
3.	What day of the week or month is best to fly to get there on time?
4.	Which airline has the most cancelations?
This session covers how to build, model, and deploy a Power BI Dashboard to PowerBI.com that reads flight data and displays aircraft flights on-time performance.  The session also shows how to use Power Query to get data from the web.  
Finally, see the Dashboard in action and also how to use Q&A, a natural-language search technology.  Also, see Quick “Data” Insights, which uses Cortana Analytics in the background to show additional insights and analysis using the existing data model.

Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: August 06

Time: 11:00 AM - 12:00 PM

Room: 201

R -- it's included in SQL Server 2016. What the heck can I do with it? Why do I need to know yet another software language? How can I use it to figure out important things -- like who do I draft over who in my fantasy football league?

We'll go over the basics of R and rStudio, plus items such as:

- Installing and managing packages
- Accessing data in various formats
- Basic data visualization functions
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 06

Time: 8:30 AM - 9:30 AM

Room: 205

OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency.  How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 06

Time: 11:00 AM - 12:00 PM

Room: 204

So you jumped on the bandwagon and set up a Hadoop cluster…but now what?  Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience.  This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 06

Time: 3:30 PM - 4:30 PM

Room: 204

We will explore the relationship between SharePoint and Excel, how Power BI swooped SharePoint off her feet, and the current Business Intelligence soap opera that stars all three. Using live demos, we will look at data interaction between SharePoint, Excel, Power BI (including the iOS app), and the intriguing new next door neighbor - Microsoft Flow.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 06

Time: 8:30 AM - 9:30 AM

Room: 203

This session will take a look at the new Query Store feature in SQL Server 2016.  Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems as well as some of the new DMVs you can use to find issues as they arise.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 06

Time: 1:00 PM - 2:00 PM

Room: 203

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