Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 36
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Auditorium

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

You know what your query does, but do you know how it does it?  Do you know what type of resources your query uses?  Come to this session to find the answers to these questions and more as we walk through reading execution plans.  We will see how SQL breaks down the execution of your query and what each step tells us about the overall query.  If you are newer to Microsoft SQL or you just don’t feel totally comfortable with reading execution plans, this session is for you.
Speaker:

Session Type:
Regular Session

Track:
Training 3

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

After building a handful of SSIS packages, you probably want to have more flexibility to make the package execution more dynamic.  In this session, we will learn how to use  variables, expressions, and loops to do things like: extract data to a file with *today's* date in the file name, load all files in a directory at the same time, and loop through a set of servers to gather data.  For this session, you should already be familiar with how to create SSIS packages to load data from flat files and extract data to flat files.
Speaker:

Session Type:
Regular Session

Track:
Training 1

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
Speaker:

Session Type:
Regular Session

Track:
Auditorium

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Database deployments while trying to implement continuous integration can be tricky. Microsoft has some great tools available to make things easier. Aaron will show how to use Release Management and Visual Studio to make your development life easier.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Training 1

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

A database by its very nature is one of the most resource intensive applications you will ever virtualize. This is even more difficult to do correctly in the context of a virtualized infrastructure that is a shared resource environment. We will look at every possible dynamic to virtualizing a database from Design, Storage, Memory and Network considerations. This presentation is based upon material given at VMworld from a presentation that was in the top 10 out of all presentation given. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Training 3

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Training 3

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

A fun and sometimes irreverent look a the SQL Server and Data world through illustrations.
I often blog about my DB Developer life in a very visual way. I explore a subset of useful topics such as Normal Form, Deadlocks, the Query Optimizer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Training 5

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

In SQL Server 2008, Microsoft finally introduced a first-class auditing tool for monitoring what's going on in your databases.  Unfortunately, that's an Enterprise Edition feature.  What about those of us running Standard Edition?  In this demo-heavy session, we'll learn about auditing methods for the masses, including triggers, event notifications, SQL Trace, and extended events.
Speaker:

Session Type:
Regular Session

Track:
Training 4

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. After that we can start talking about if and how you want to raise it. It’s important to know that this is just a counter and there are situations where you don’t care about it nearly as much as you’d expect. It’s also important to know what effect a drop in PLE mid-day really means beyond query performance, including a possible impact on other, unrelated servers.
Speaker:

Session Type:
Regular Session

Track:
Training 2

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.
Speaker:

Session Type:
Regular Session

Track:
Training 2

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

We have all had requirements for a procedure based upon many parameters that may or may not contain a value. These are typically seen as the code behind a search screen. The end users need to do this regularly, and they can be real performance killers.

This session will provide a number of different ways to handle "sometimes" queries, and provide techniques to make these perform faster.

Michael John is a Senior DBA with almost 20 years experience working and solving problems for both Fortune 100 companies and smaller firms. As a frequent contributor to many of the community newsgroups, and expert at answering the 2:00 AM problem phone calls, Michael has seen nearly every issue as a DBA in his career. 
Speaker:

Session Type:
Regular Session

Track:
Auditorium

Level: Intermedia

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Need to build a more secure SQL Server?  Attend this session and learn 10 things you can do today to make your SQL Server more secure. Options like encrypting client connections, renaming SA, and configuring a SPN so SQL Server uses Kerberos.  You learn how to combine multiple layers to truly build “defense in depth” for a more secure database platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Training 4

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Power View is an interactive data exploration, reporting and presentation tool that is a pleasure for business people to use. It the one of the core building blocks of Power BI. In this session we will cover slicing, filtering, custom drill hierarchies, animated scatter plots, maps and more. You don't have to be a visualization expert to create beautiful and compelling visualizations. 
Speaker:

Session Type:
Regular Session

Track:
Training 5

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

This isn't your typical talk on "partitioning".  This is a deep dive into all the problems that you'll run into when partitioning new or existing "Write Once, Read Many" tables, such as large Audit Tables, and how to code around them.  You'll also learn the methods to support three of the best reasons for partitioning such monster tables... MUCH shorter nightly index maintenance, MUCH shorter and smaller backups, and MUCH shorter "Get back in business" piecemeal restores.  We'll also learn how to do the "impossible"... compact a File Group (one per partition) so that there's virtually no unused space in the underlying file.  After all, we don't want to set any "free" disk-space to "Read Only".  Don't let the "Advanced" rating of this session scare you away.  Anyone with a decent handle on T-SQL (or wants one) will be able to understand this session because "all will be explained" and there will be oodles of well-documented code to back up the explanations.
Speaker:

Session Type:
Regular Session

Track:
Training 2

Level: Advanced

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

This isn't your typical talk on "partitioning".  This is a deep dive on the code for the problems and desired results for partitioning things like the "Audit" Table covered in Part 1.  It's strongly recommended that you attend Part 1 where the groundwork for this session has been laid out.  In this session, we'll build a 4 million-row test table and do the initial partitioning.  We'll follow that up with the monthly process to re-index and compress the latest full partition automatically every month and do a deep dive on a view that makes monitoring partitions easy.  This code helped me reduce backups to 1/60th the amount of time that they used to take.  There's a ton of ancillary learning in the code, as well.  Don't let the "advanced" rating of this session scare you away because it's written for all levels to understand.
Speaker:

Session Type:
Regular Session

Track:
Training 2

Level: Advanced

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some SQLPSX to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and "I have to have it now" stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Training 4

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

I've said it before and I'll say it again, spatial data doesn't get much love in SQL Server.  It is a feature worthy of much appreciation and will become more vital as more location data is collected.  In this session we will explore spatial data and discover many ways it can be used for incredible analytics.  You will learn some new ways to visualize your data outside of the typical plots on a Bing map layer.  Come and learn how powerful spatial data can be even though it lacks a snazzy "power" title.
Speaker:

Session Type:
Regular Session

Track:
Training 5

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Walk through on creating SQL Server solutions in the cloud! Learn about the options for data storage in Azure, plus how to (very easily) configure and deploy a SQL Server. We will go over pricing, storage options, security and other details on using either Infrastructure as a Service (Iaas) or Database as a Service with Microsoft cloud solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Training 4

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you have an Analysis Services Multidimensional cube that isn't working right? Is it slow and non-performing? Does it take a REALLY long time to process? In this session, we'll review some of the best practices that you can put against your SSAS cube to get it running at peak efficiency. We'll discuss how to optimize dimension processing and why attribute relationships are so important, and what makes distinct count measure groups special. We'll also discuss why SSAS has 2 engines under the covers, and how you can use this knowledge to performance tune your cube to address the right bottleneck.
Speaker:

Session Type:
Regular Session

Track:
Training 5

Level: Beginner

Session Code:

Date: February 07

Time: 12:00 AM - 1:00 AM

Room: TBD

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