Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 35
The Tabular model is still the new kid on the block in the world of SQL Server Analysis Services, and its importance in the Microsoft BI roadmap continues to grow. Based on xVelocity, a highly compressed in-memory technology, Tabular models promise considerable performance improvements over Multidimensional models in many scenarios. But, as is the case with any new technology, there are certain limitations of which to be aware. 

Join me in this session and learn what a Tabular model is, how it fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live step-by-step demo where we'll build and deploy a basic Tabular model. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration Intermedi

Level: Intermedia

Session Code:

Date: October 10

Time: 11:00 AM - 12:00 PM

Room: 214

As is commonly the case, all good things come to an end.  And now is as good a time as any for the use of SQL Trace and Profiler to come to an end.  Let’s face it, Trace was a good tool and had some wonderful uses.  Profiler for that matter was a good tool and was useful at times.
It is time to let those old tools retire gracefully and move into the world of XE.  This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties.  This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment Advanced

Level: Advanced

Session Code:

Date: October 10

Time: 11:00 AM - 12:00 PM

Room: 222

SSIS has many great built-in tasks and components. Sometime, though, you need to go further than what they allow. Come to this session to see how far you can stretch the scripting capabilities of SSIS. 
SSIS offers significant capabilities out-of-the-box. However, many data movement projects have needs that go above and beyond the common scenarios. Have you ever needed to calculate running totals during your ETL process? What about using dynamically updated business rules during processing to determine what data is valid? These things, and much more, can be accomplished using the script task and component within SSIS. During this session, we will demonstrate several scripts in SSIS (including the ones mentioned above) that show how to take full advantage of the capabilities of SSIS. This session is intended for people who have worked with and understand SSIS, and have a basic understanding of .NET development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration Intermedi

Level: Intermedia

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: 214

When was the last time you read up on SQL Agent features? Is there more you could be doing with it?

We'll answer this question and more as we take a deep dive into the SQL Server Agent. In this session we will cover some of the basic best practices of SQL Agent configuration as well as more advanced topics like managing large numbers of jobs, properly managing job history, and keeping jobs in sync across multiple instances.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment Intermediate

Level: Intermedia

Session Code:

Date: October 10

Time: 9:45 AM - 10:45 AM

Room: 222

"Its.Slow!" are probably the two most dreaded words for any database professional (right behind "You're fired!") 

What's slow? Since when? Compared to what?

Join this "something-everyone-should-be-doing-but-isn't" session, in which we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We'll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration Intermedi

Level: Intermedia

Session Code:

Date: October 10

Time: 8:30 AM - 9:30 AM

Room: 214

How do you know if Availability Groups are the correct high availability solution for your business application?  We’ll cover some common business problems that Availability Groups can solve and go through a quick demo where we’ll cover some pre and post checklist items to help you understand the requirements for a successful implementation.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment Beginner

Level: Beginner

Session Code:

Date: October 10

Time: 4:00 PM - 5:00 PM

Room: 217

Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process.  PowerShell scripts can greatly reduce the time required to complete the process.  They can also ensure build standardization throughout your SQL environment.  In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment Beginner

Level: Beginner

Session Code:

Date: October 10

Time: 11:00 AM - 12:00 PM

Room: 217

The cloud is here! Are you ready?  Microsoft, Amazon and others are all vying for your cloud attention.  In this session, we will review the different types of cloud platforms available and what they mean to you.  We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions.  What are these hosting options and what are the differences between them?  Most importantly, how do I get started with all of this cloud business?  Let's put SQL Server into the cloud!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 10

Time: 2:45 PM - 3:45 PM

Room: 217

Is your SQL Server instance running at its peak performance level?  Probably not but the real question is do you know why not? Is your disk subsystem too slow or are you lacking enough CPU’s or is it something else? It is very easy to capture and analyze the file & wait statistical information that is automatically provided by the SQL Server instance with several key DMV’s so why not utilize them. We will see how you can stop chasing your tail and focus on which area of SQL Server performance bottlenecks are doing you the most harm. This should be part of every DBA’s arsenal so come make it part of yours as well.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment Intermediate

Level: Intermedia

Session Code:

Date: October 10

Time: 1:30 PM - 2:30 PM

Room: 113

SQL Server has been around long enough for numerous misconceptions to have become part of the general folklore.  Despite the best efforts of many,  aspiring SQL development professionals still regularly find themselves misinformed about the behaviors of key features such as cursors,  temporary tables and table variables, nested  transactions and foreign keys. Early in your career you may already be instilling a lifetime of bad habits that can be detrimental to the performance and the integrity of the applications you work with. In this session we address several such commonly held misconceptions and demonstrate that they are invalid.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development Beginner

Level: Beginner

Session Code:

Date: October 10

Time: 11:00 AM - 12:00 PM

Room: 111

For those of you that don’t have a full time DBA on staff, this session is built around you. I will give you the skills and tools necessary to successfully manage Microsoft SQL Server. Automation is the key to any monitoring effort and SQL Server is no different. I will show you publicly available tools and scripts to alert you when key areas of SQL Server are being stressed. Proactively monitoring SQL Server will make you more efficient and allow you to continue your success within your role.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 10

Time: 11:00 AM - 12:00 PM

Room: 114

Having a good disaster recovery strategy is important for all DBAs.  SQL Server offers several options, but how do you choose the right one to meet your business requirements?  In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and High Availability Groups.  Then we will talk about how to choose the best one to meet your needs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 10

Time: 8:30 AM - 9:30 AM

Room: 217

DAX is the new formula language (builds upon Excel's) supporting PowerPivot and Analysis Services Tabular mode. If you know Excel, you already know the basics of DAX (without even knowing it). If you have been meaning to use Analysis Services, but MDX has been proving difficultin the way, now is the perfect time! Come check out DAX and see how it can help you.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration Beginner

Level: Beginner

Session Code:

Date: October 10

Time: 2:45 PM - 4:15 PM

Room: 214

Microsoft has been busy working on the next version of SQL Server - SQL Server 2016.  We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB.  Row Level Security allows you to add another layer of security to your environment.  StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment Intermediate

Level: Intermedia

Session Code:

Date: October 10

Time: 9:45 AM - 10:45 AM

Room: 113

You've never worked with spatial data and would like to know how to do it.
We'll go through very basic SQL Server Spatial data functionality and draw some Spatial pictures using Management Studio.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development Beginner

Level: Beginner

Session Code:

Date: October 10

Time: 8:30 AM - 9:30 AM

Room: 116

SSIS has many great built-in tasks and components. Sometime, though, you need to go further than what they allow. Come to this session for an introduction to the scripting capabilities of SSIS. 
Many data movement activities can be handled with SSIS using the built-in tasks and components. Eventually, though, you will run into a scenario that will be better handled by extending SSIS functionality with custom code. In this session, we will cover the basics of using scripts in SSIS control flows and data flows. We’ll talk about the pros and cons of scripts, review the development environment for scripts, cover some interesting and useful .NET classes, and walk through multiple examples of scripts that add useful functionality to SSIS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration Beginner

Level: Beginner

Session Code:

Date: October 10

Time: 9:45 AM - 10:45 AM

Room: 214

Any changes to Non-Memory Optimized tables require a certain amount of logging to the transaction log in order to ensure the integrity of the operation and of course the database. Most of these are fully logged operations and can write a tremendous amount of data to the transaction log. As you probably already know these can lead to various performance and availability issues. However you may be able to minimize the effect of these with what is called a minimally logged operation. This session will outline how these can be used under the right conditions to save time, resources and potentially a lot of headaches. Various demos will hit home on just how much of an impact this can have on some every day operations.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment Intermediate

Level: Intermedia

Session Code:

Date: October 10

Time: 8:30 AM - 9:30 AM

Room: 113

I have been new to something at some point in my life, new town, new job or new profession. Now, I am the new DBA!  Feeling overwhelmed, not sure where to begin.  I know I have data and maybe lots of it.  I need a friend and mentor to help me discover my new role. Select wants to be my friend, in fact Select and I need to become best friends.   For Select and I to become best friends, we need to learn about each other, our weaknesses and our strengths. Come along, Select wants to introduce you to all of Selects friends.  Let’s meet Where, Join, Group By and more of Select friends. Come along, let’s discover Select and his friends.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development Beginner

Level: Beginner

Session Code:

Date: October 10

Time: 9:45 AM - 10:45 AM

Room: 111

Often times we might feel like we are simply spinning our wheels and can't seem to move ahead.  Perhaps we see others getting opportunities and can't quite place why more doesn't come our way.  This session will discuss how we can put ourselves in the drivers seat when it comes to making opportunities so we can make some decisions about what we want to do rather than choosing from what is left.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 10

Time: 9:45 AM - 10:45 AM

Room: 114

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs.  Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment Intermediate

Level: Intermedia

Session Code:

Date: October 10

Time: 11:00 AM - 12:00 PM

Room: 113

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