Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type




Sessions Found: 61
What is "Windows Azure SQL Database" all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to "The Cloud" ? How do I possibly leverage this new technology in my production environment ? 
If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 10

Time: 10:35 AM - 11:35 AM

Room: Azure+ - 1206B

Have you ever felt like an extra in Office Space? You've got the skills. You've got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What's the deal?

In this session, you'll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: Prof Dev - 3205

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Spotlight Session (45 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 10

Time: 12:30 PM - 1:15 PM

Room: DBA 2 - 4106

Tired of dealing with Replication issues? Want high availability and readable replicas for reporting? The you should consider availability groups! This session provides a run through from start to end of my experience implementing AlwaysOn Availability Groups for High Availability and read only secondary database copies.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: DBA 3 - 4205

In this session we will be covering one of Microsoft's latest Azure offerings SQL Data Warehouse, which leverages the massive parallel processing (MPP) architecture. We will talk about the differences between SMP vs MPP architectures and benefits of an MPP architecture in the cloud. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: Azure+ - 1206B

In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented. It should be noted that this session is not intended to be an in depth look at performance tuning, but rather a cornerstone in learning to use a tool appropriate for tuning.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 10

Time: 10:35 AM - 11:35 AM

Room: DBA 4 - 4208

This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: October 10

Time: 10:35 AM - 11:35 AM

Room: DBA 2 - 4106

If you are a working professional there is a chance that your career has interrupted your life and you've forgotten about you and/or your family.  How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a  better you.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 10

Time: 3:15 PM - 4:15 PM

Room: Prof Dev - 3205

As the value of Dev/Ops becomes more apparent to IT organizations, increasing demand is placed on the SQL Server DBA to manage a more agile and resilient database environment.  A Dev/Ops model requires management of dozens of copies of each database across many servers, The need to provision and refresh these copies quickly is key to the success of any Agile development effort.  In this session we will discuss the SQL Server DBA's role within Dev/Ops - we'll talk a bit about things like Sprints, Chef and Puppet, but most importantly we will discuss how you can present a database to any host in your environment in a couple of minutes regardless of size.  Come see a copy of a 1.6TB SQL Server database presented to a host (same host or different doesn't matter) in less than 2 minutes - try doing that from a database restore!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Spotlight Session (45 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 10

Time: 12:30 PM - 1:15 PM

Room: DBA 1 - 4105

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

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: Security - 3207

Many DBAs still hold onto the notion that each implementation of SQL Server requires a dedicated physical server. In today’s world dominated by virtualization and an ever increasing eye towards all things cloud, the infrastructure under SQL Server has a greater impact than ever before. This session will discuss the key differences between physical, virtual, and cloud; how the platform choice affects SQL Server deployments; and how Cisco’s UCS can benefit not only SQL Server and the DBAs, but also system administrators.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Spotlight Session (45 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 10

Time: 12:30 PM - 1:15 PM

Room: SQL Server 2016 - 1206A

Databases are growing.  The way we use data is changing and growing.  When you have a lot of change, it has to be managed, or bad things happen to your data and your job!  A common problem with database change management is... database change management.  This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy.  There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be.  Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 10

Time: 9:00 AM - 10:00 AM

Room: DBA 3 - 4205

Microsoft SQL Server and Microsoft Azure have been announcing so many features it’s hard to keep up. If you’ve heard of Cortana Analytics, you may be a little confused about what it is, and when you would use it. Buck Woody from the Cortana Analytics team is here to help with an overview of the Cortana Analytics stack, examples of how it works, information on what components to use when, and references to learn more. You’ll be able to amaze friend and family alike with your knowledge of the Blue side of the Force. No, really, you’ll be able to do that. He’ll prove it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: DBA 4 - 4208

The Azure platform is ever changing. Today is no different. Azure has released a new tool called Data Factory. It is a cloud PaaS that is SSIS in the cloud. Are you curious what all it entails and if you can use it? In this session, we'll go over the basics of Data Factory like structure, billing, and building blocks. We'll go over a couple instances on how you can use Data Factory in current processes that you have in your data warehouse ETL.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 10

Time: 9:00 AM - 10:00 AM

Room: Azure+ - 1206B

Developers and DBAs:  How do you determine what DataType will be required for your database?  Far too often, Database Development teams are pressured into making quick decisions for their database models, usually full of NVarChars and GUIDs, typically based on a suggestion that these datatypes were the only useful datatypes for Web development.  In this session, we will discuss the pro's and con's of the differing datatypes, and arm the Database Developers and DBAs with the analysis necessary to create databases that are easily maintained.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 10

Time: 9:00 AM - 10:00 AM

Room: DBA 2 - 4106

What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we'll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We'll also discuss how the design of our dimensional model affects a SQL Server Analysis Services solution and how the choices we make during the data warehouse design phase can make or break our SSAS cubes. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 10

Time: 10:35 AM - 11:35 AM

Room: BI 1 - 4102

How many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? Where do you start tuning? When do you stop tuning? Each application is different. With the ever increasing number of systems one production DBA has to manage today, it's very important to use TOP to BOTTOM approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration. 

While you can find top queries, wouldn't it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour and current situation? Now you can focus on those specific queries!

In this session, Prakash walks you through with scenario & demos to find which exact queries are taxing production systems resources based on CPU/DISK/Memory/Network. They are all based on his own real-life experience from managing demanding database systems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: DBA 2 - 4106

Many seasoned DBA's don't want developers to use triggers because of the many common mistakes made when coding triggers that can adversely affect performance.  We will discuss the different types of triggers: DDL and DML (Instead of and after) and see many common mistakes made and how to fix them.  We will also discuss when a trigger may be the best solution and other options when a trigger is not the best solution.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 10

Time: 4:30 PM - 5:30 PM

Room: DBA 1 - 4105

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

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 10

Time: 4:30 PM - 5:30 PM

Room: Azure+ - 1206B

You're a SQL Server DBA working at Contoso and your boss calls you out of your cubicle one day and tells you that the development team is interested in implementing a Hadoop-based solution to your customers. She wants you to help plan for the implementation and ongoing administration. Where do you begin?

This session will cover the foundations of Hadoop and how it fundamentally differs from the relational approach. The goal is to provide a map between your current skill set and "big data.” Although we will talk about basic techniques for querying data, the focus is on basic understanding of how Hadoop works, how to plan for growth, and what you need to do to start maintaining a Hadoop cluster.  Additional discussion will cover the complementary nature of Hadoop and SQL Server.

Examples and demos will highlight basic query tools, including transferring data to and from SQL Server.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 10

Time: 3:15 PM - 4:15 PM

Room: BI 2 - 4104

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