Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 38
Indexes can be a boon or decrement for query performance. This presentation will present what they are (in layman’s terms) and how they may affect query performance – both from a read (SELECT) viewpoint as well as a data modification aspect (INSERT, UPDATE, DELETE).  This session will concentrate with a deep dive into clustered indexes and nonclustered indexes, their syntax and utilization, and their effect on performance in transaction and data warehouse databases.  Covering nonclustered indexes will also be examined in detail and the scenarios they should be applied.  There will be many query demos illustrating index utilization using statistics and query plans.  Attendee should have some TSQL and Management Studio experience.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 03

Time: 3:00 PM - 4:00 PM

Room: 1774

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

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 03

Time: 4:15 PM - 5:15 PM

Room: 1775

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of  Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 03

Time: 11:15 AM - 12:15 PM

Room: 1774

R is the most popular statistics language used today. It is one of the most useful tools in the data scientist's tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.  
  
Come to this session to get an introduction to the R language including: 

  - installing and Configuring R and RStudio 
  - RStudio Overview and Debugging
  - how to Access and Manipulate Data 
  - install and Manage Packages 
  - create and Use Variables 
  - control Flows 
  - functions 
  - basic Graphing and Statistical Analysis. 

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.  
  
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 03

Time: 4:15 PM - 5:15 PM

Room: 2169

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 03

Time: 4:15 PM - 5:15 PM

Room: 1776

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 03

Time: 4:15 PM - 5:15 PM

Room: 1774

Are you looking for a high availability solution for your business critical application? You're heard about AlwaysOn Availability Groups and they seem like a good solution, but you don't know where to start. It all starts with a solid design. In this session we introduce the core concepts needed to design a Availability Group based system. Covering topics such as recovery objectives, replica placement, failover requirements, synchronization models, quorum, backup and recovery and monitoring. This session is modeled after real world client engagements conducted by Centino Systems that have lead to many successful Availability Groups based systems supporting tier 1 business critical applications.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 03

Time: 8:00 AM - 9:30 AM

Room: 2142

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:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 03

Time: 9:45 AM - 10:45 AM

Room: 2171

Are you struggling with database performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for quickly finding and fixing inefficient queries by utilizing wait-time analytics. Janis Griffin, database performance evangelist, SolarWinds, will use real-life case studies to show how quickly you can identify and fix the problems that are affecting your end user applications while saving countless of hours of investigation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Spotlight Session (45 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 03

Time: 1:00 PM - 1:45 PM

Room: 2171

Embedding Power BI In your Web Application

Power BI is growing by leaps and volumes and there is need to host the portal in your web application.

This session goes through different ways you can embed Power BI (Portal Reports) and Embedded Power BI Service Reports in your Web Application.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: June 03

Time: 3:00 PM - 4:30 PM

Room: 2171

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:

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 03

Time: 1:45 PM - 3:15 PM

Room: 1775

In this session, we'll cover the basics of Disaster Planning and key operational items to consider when establishing software systems.  We'll cover terms and their importance as well as commonly used software and hardware techniques for disaster planning purposes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 03

Time: 3:00 PM - 4:00 PM

Room: 1775

In this talk, we will explore two powerful technologies from the Microsoft Azure Stack: DocumentDB and Azure Search. DocumentDB is Microsoft's NoSQL service for building globally scalable schema-free applications. Azure Search allows you to integrate the power of Microsoft's search and natural language processing abilities to explore your complex data stores. During this talk we will cover the benefits of implementing a schema-free database, we will learn how to replicate your data at a global scale with the ease of a simple configuration and we will cover various techniques of querying that data using SQL and the DocumentDB API. Once we have a large datastore in place (we will use 200k+ Jeopardy questions), we will apply the powerful natural language querying capabilities and faceted search features of Azure Search to quickly create an searchable data repository. All of this will be built and exposed using a cross-platform application built in Angular on the Electron framework.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 03

Time: 4:15 PM - 5:15 PM

Room: 2171

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 03

Time: 11:15 AM - 12:15 PM

Room: 1775

Every developer wants to be productive and get more things accomplished during their day to day work. Given a choice between working harder and working smarter, you will most likely choose the latter. But the big question is – How do you boost your productivity? How do you reduce your development time? How do you increase your coding speed?

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 03

Time: 8:00 AM - 9:00 AM

Room: 2169

Using indexing to improve performance
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 03

Time: 9:45 AM - 10:45 AM

Room: 1774

In this session we will take a look at the basics of execution plans.    We will discuss what they are, how they are made, and how they are used.  We will explore some of the common operators seen in execution plans and their functions.   Next we will look at the differences between estimated and actual execution plans. Throughout, you will be getting insight on how to read execution plans to help tune your queries.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 03

Time: 11:15 AM - 12:15 PM

Room: 2171

Inherited SharePoint or being tasked to implement it? In this session we will start with the fundamentals of SharePoint and work our way to understanding what it looks like to be a successful SharePoint administrator. We will cover common SharePoint misconceptions & use live demos to show frequently performed tasks - all to set you up for success day one. Lastly we will cover the training options and other resources available to make your job easier and more automated.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: June 03

Time: 8:00 AM - 9:00 AM

Room: 1775

Next time you attend a meeting, watch what happens when women at the table offer ideas. If your office is like most in America, you’ll notice women are interrupted almost three times as often as men. Some interruptions are to assert dominance but sometimes people do it to be helpful & offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers & better performance reviews from bosses. This translates into $ when raises and bonuses are handed out.
 This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 03

Time: 11:15 AM - 12:15 PM

Room: 1776

Your ideas are only as good as your ability to describe them to others.
 
As technology professionals, our tech skills need to be at their peak. However, we often lack the communication skills to describe technical concepts to others, including business users, executives, or even other technology professionals. In this session, veteran IT professional Mike Hillwig, will show you a handful of skills that are essential in communicating with people outside of the database world.
 
You will learn Mike's keys to good storytelling, making analogies, listening, writing, and putting technology concepts into things that give you a common language with business users. You'll leave this session with the ability to influence technology decisions based on your skills explaining why the DBA is usually right.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 03

Time: 3:00 PM - 4:00 PM

Room: 2169

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