Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 40
Administering production SQL Servers can be a complex job.  How does this task change when the environment you’re supporting will be used as part of a development or testing environment?  And what can the DBA do to best support development teams?  This session will discuss the unique challenges that are part of servicing these special systems and highlight ways that a DBA can help development teams produce better code.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Track 7

Level: Intermedia

Session Code:

Date: April 11

Time: 2:30 PM - 3:45 PM

Room: Room 325

Do you have multiple databases with distinct workloads running on a single SQL Server Enterprise Edition instance? Have you ever had a runaway process or bad query from one system bring an entire instance to its knees, impacting a wide range of end users? If you answered yes to either of these questions, then come learn about Resource Governor for SQL Server. We’ll spend the first part of this introductory session going over the concepts you will need to know in order to implement Resource Governor successfully. Once we've covered the basics, we’ll spend the rest of the session working through a number of demos, reviewing exciting enhancements to Resource Governor in SQL Server 2014, and discussing scenarios in which you can use Resource Governor in your environment right away. Hardware resources are a valuable commodity.  Learn how you can control them effectively in a multitenant environment, ensuring they are assigned where they need to be.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 1

Level: Beginner

Session Code:

Date: April 11

Time: 10:30 AM - 11:45 AM

Room: Room 213

This session will utilize SQL tools and techniques to manage Cloud and DataCenters Environments. Learn to use some of the latest SQL technologies to automate and manage your datacenter! 
Topics include:
-Scheduling SQL Service Integration Services with System Center Orchestrator and Service Management Automation (SMA)
-Install and Configure and manage SQL environments using PowerShell DSC
-Monitoring and Reporting of Datacenter Operational Performance using Power BI 
-Lots of other cool stuff!

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 11

Time: 9:00 AM - 10:15 AM

Room: Room DE232

Learn how to use integration services to create a fast, reliable, repeatable ETL structure that's designed to insert or update your destination from nearly any source.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Track 4

Level: Beginner

Session Code:

Date: April 11

Time: 1:00 PM - 2:15 PM

Room: Room DE235

Building out an Enterprise Data Warehouse can be extremely time consuming when developing the initial ETL building blocks.  Using a Data Repository and BIML to centralize enterprise data can decrease Data Warehouse development time.  It can be used as a central repository for ad-hoc reporting, and keep an audit trail of source system changes.  This session will look at the benefits of centralizing data in its original format and how to automate the collection and auditing using BIML.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 8

Level: Intermedia

Session Code:

Date: April 11

Time: 2:30 PM - 3:45 PM

Room: Room 326

Many people have never heard of a Contained Database let alone know why they would use a Contained Database.  In this session, I will go into the WHAT is a Contained Database, the HOW a Contained Database works, and the WHY I would use a Contained Database.  We will use, both successfully and unsuccessfully, a Contained Database through Management Studio, Integration Services, Reporting Services, and a Web Application (Visual Studio MVC).  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 3

Level: Beginner

Session Code:

Date: April 11

Time: 10:30 AM - 11:45 AM

Room: Room DE232

The key to becoming a great DBA is time.  The best way to regain some time is by spending less time doing the daily mundane work.  Let this mundane effort work autonomously.  We will introduce the basics in monitoring and maintenance.  The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Track 7

Level: Beginner

Session Code:

Date: April 11

Time: 4:00 PM - 5:15 PM

Room: Room 325

AlwaysOn Failover Cluster Instances, Availability Groups and Windows Server Clustering...this is an overview of these features in SQL 2012 and 2014 for D/R, overlaying Windows OS features.  We'll discuss what you need to use when and why.  We'll discuss options on how you can achieve a D/R strategy with all the features you have in Windows and SQL Server to best meet your needs.  Review key architectural considerations to making sure you have a successful recovery after a disaster.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 6

Level: Intermedia

Session Code:

Date: April 11

Time: 2:30 PM - 3:45 PM

Room: Room 313

Are you curious about Facts, Dimensions, and type 2 slowly changing dimensions that those Data Warehouse people talk about? This session will provide an introduction to the different architectures proposed by the two Data Warehouse proponents, Bill Inmon and Ralph Kimball.  We will present the theory and key concepts of Dimensional modeling and review why Dimensional modeling is important and the functionality a Data Warehouse can deliver that a normalized database cannot. We will also present some more advanced topics like heriarchies, snowflakes, recursive relationships, and bridge tables.   
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 4

Level: Beginner

Session Code:

Date: April 11

Time: 10:30 AM - 11:45 AM

Room: Room DE235

Two of the of the most under-utilized management features of SQL Server are the Central Management Server and the SQL Agent Multi-Server Administration tools. The CMS is a powerful little tool creates a catalog of servers that allows you to execute any query or script against multiple servers at the same time. The SQL Agent Multi-Server Administration (MSX) tool allows you to create a SQL Agent job on one server and then deploy it to multiple servers instantly. When used in conjunction with each other, you have a powerful set of features that make managing your enterprise a lot simpler. 

SQL Server MVP Mike Hillwig will show you how to to deploy these two powerful features right out of the box without writing a single line of new code. 

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 8

Level: Intermedia

Session Code:

Date: April 11

Time: 9:00 AM - 10:15 AM

Room: Room 326

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these data type choices can be a real performance killer? 

Attend this session to learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! 

When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Track 8

Level: Intermedia

Session Code:

Date: April 11

Time: 1:00 PM - 2:15 PM

Room: Room 326

Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization's data. 
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Track 5

Level: Intermedia

Session Code:

Date: April 11

Time: 9:00 AM - 10:15 AM

Room: Room 309

You’re a DBA at your company, and you’re in charge of keeping the production SQL servers humming. You know how to maintain and troubleshoot those instances for top performance. But now your boss has given you a new task: find out why the company reports are running so slowly and why the server itself seems unresponsive at times.

In this session we’ll talk about how to get the best performance from your SQL reporting server. We will discuss how to administer a SQL Server Reporting Service (SSRS) instance; how to install and configure the service for best performance, how to see what reports are currently running, and find which reports are bogging down the server. 

This session will not cover report design scaling out, or SSRS for SharePoint.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 11

Time: 4:00 PM - 5:15 PM

Room: Room DE235

Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I'm doing something about it...I'm automating my installs!  From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA's and Developers, I'll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project).  We'll cover many of the scenarios you may encounter and you'll walk away with some pre-built install scripts to help get you started.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 11

Time: 4:00 PM - 5:15 PM

Room: Room DE232

Your boss comes up to you and asks you why the system is slow, unless you know how your system is supposed to respond you are stuck scrambling to answer those questions.  With a few free quires and some SSIS magic you can capture a Baseline of your systems.  With this you will be able to know exactly where to look and what might be amiss.  Before you can say what is wrong with your system you need to know how it reacts under normal circumstances.  This session will provide the tools you need to start collection of your systems baselines and give you a great deal of information.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Track 7

Level: Intermedia

Session Code:

Date: April 11

Time: 1:00 PM - 2:15 PM

Room: Room 325

There are two kinds of DBAs in the world -- those who have experienced corruption, and those who will.  Join me for this session to learn what corruption is, how it can occur, and how to check if your data is corrupt.  And if you do find corruption, I will show you how to identify what data is affected using DBCC CHECKDB and DBCC PAGE.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Track 3

Level: Intermedia

Session Code:

Date: April 11

Time: 1:00 PM - 2:15 PM

Room: Room DE232

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks.  This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 6

Level: Beginner

Session Code:

Date: April 11

Time: 4:00 PM - 5:15 PM

Room: Room 313

So you know the difference between a clustered and a nonclustered index.  I won't review it again - I promise.  This session will focus on expanding your understanding of indexes and what you can use them for. We will look at the internals of how they are structured, included columns, filtered indexes and indexed views. We will explore how to use indexes to enforce contraints beyond just simple uniqueness.  Earn your SQL Black belt with this fun and informative session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Track 1

Level: Intermedia

Session Code:

Date: April 11

Time: 2:30 PM - 3:45 PM

Room: Room 213

This introduction will provide a brief history of machine learning and its practical uses.  We will then dive into Microsoft's Azure ML offering and demonstrate how you can build a real-world use case using Azure ML Studio with a free trial account.  If you have been curious about machine learning, this session will show you what you need to get started.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Track 2

Level: Beginner

Session Code:

Date: April 11

Time: 1:00 PM - 2:15 PM

Room: Room DE335

Do you need a high availability and disaster recovery solution for your mission critical databases?  SQL Server AlwaysOn can help, but with Windows Clustering, Failover Cluster Instances, and Availability Groups it gets confusing and complicated fast. I'll clear up all the confusion by explaining the various components and exposing all the gotchas.  There are different levels of protection and you will learn how to choose the right one for your environment.  You will walk away with the knowledge and confidence to pick the right solution to give your critical databases a solid high availability and disaster recovery plan.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Track 6

Level: Beginner

Session Code:

Date: April 11

Time: 10:30 AM - 11:45 AM

Room: Room 313

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