Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 30
This session is 90% live demonstrations.  I'll walk you through a complete AlwaysOn deployment.  You will see firsthand how to install and configure an AlwaysOn Failover Cluster.  I'll also show you how to setup an AlwaysOn Availability Group across 5 nodes using both the GUI and T-SQL so you know why and when to use each method.  I'll finish up by showing how you can connect to a readable secondary.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you wil learn how you can leverage Powershell to not only efficiently meet the needs of your busines, but also free up your time for other things.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will you chart the waters through the sea of Business Intelligence (BI) options.  IT departments need tools to turn data into useful information for users.  Instead of ROI, this session talks about Return on Data' for IT Managers.  

In this session we look at the roles of data warehousing, big data and business intelligence systems.  The Microsoft BI stack has evolved from traditional OLAP cubes to include tabular models, PowerBI, integration with HADOOP, reporting tools and full integration with SharePoint.  This session is non-technical.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

You have data to move, but you're tired of the pain and suffering that SQL Server Integration Services (SSIS) development brings. Business Intelligence Markup Language (BIML) is a popular meta-language that describes SSIS packages and solutions. In this high-speed, demo-laden session, we will look at some of the worst problems in SSIS development and how easily BIML sidesteps them while making you more productive. Most importantly, this session will demonstrate that you can develop SSIS packages without pulling out your hair!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Bonus 2

Level: Intermedia

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how to build a Master Data Management (MDM) Center of Excellence with Best Practices using extensive demonstration of SQL Server Master Data Services (MDS) and Profisee's Maestro product. The session will including building a complete sample customer domain including data quality, merge, match and deduplication, and business workflow.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture.  Change Tracking is now the red-headed step child, but in many cases may be a better solution for data ETL movement from an OLTP database to a data warehouse database.  This session will provide a review of change tracking syntax and implementation with detailed demos.  It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos.
Speaker:

Session Type:
Regular Session

Track:
Bonus 2

Level: Intermedia

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

ColumnStore indexes were first introduced as xVelocity with SQL 2012 as a way to improve query performance against large data sets by grouping and storing columns of data instead of rows.  With SQL 2014, those ColumnStore indexes become update-able.   In this session, we review the difference in ColumnStore indexes, implementing ColumnStore indexes Clustered and Non-Clustered and monitor performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

The deployment process is frustrating; an object is missing, an object is 
deployed in the wrong order or the incorrect version. Each database is 
made up of a lot of objects in different environments. When you create an 
object like a table or stored procedure, you need to get this object deployed 
into each environment. Together we will discover how to separate each 
object for proper order deployment while releasing only objects which have 
changed. Deployments can cause you trouble but we will provide a reliable 
deployment and version control process.
Speaker:

Session Type:
Regular Session

Track:
Bonus 2

Level: Intermedia

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you will learn how to provide valuable data insights through data discovery and visualisation with Microsoft’s Power BI capabilities. You'll learn how to connect and discover the world's data to enhance data discovery over your own and externally available datasets and how to combine multiple datasets together. You'll also learn how to use existing and new data visualisation capabilities together using Power View and Power Map in Excel 2013, and get a deep drilldown into the Power BI capabilities.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Advanced

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor.  In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Bonus 1

Level: Beginner

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

Did you know you can design and develop databases from within Visual Studio using SQL Server Data Tools? Attend this session to find out how to take database development to the next level using Visual Studio.  Discover simple ways to manage databases using a tool designed by Microsoft.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev

Level: Intermedia

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

Stop relying on vendors to provide you with performance data.  Between Windows and SQL Server you’ve already got all you need to collect and report on server performance.  And it’s far more flexible than you’ll ever get from a vendor.  This is often called a poor man’s method, but it’s so much more than that.  I’m going to show you what your options are for collecting performance data for free and you’ll even walk away with a framework you can plug into your own environment and start using tomorrow with very little effort.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Bonus 1

Level: Intermedia

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know and love inner join, outer join, in and exists. But, there are a several other TSQL operators that do not get as much press as the rest. Expand your TSQL tool belt with Intersect, Except, Cross Apply, and Outer Apply. You'll get practical examples that you can use on Monday morning!
Speaker:

Session Type:
Regular Session

Track:
Dev

Level: Beginner

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

The hardest part of the analyst's job is finding data to support his or her work.  And once that data is found, it is often in less than ideal shape for our needs.  With Excel Power Query, the analyst now has capabilities to find and cleanse data, resulting in huge time savings.  In this session, you will learn the basics of working with Power Query.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.   This session applies equally to Analysis Services 2008, 2008R2 and 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Bonus 1

Level: Beginner

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Bonus 2

Level: Beginner

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

If your eyes glaze over when you read the terms 'clustered index' or 'non-clustered index', and you think you really ought to know what these are, this may just be the session for you.

This session is designed for those new to database design/development. If you have some idea of how databases and tables are used, but need a (re)grounding in the basic concepts of indexing and how to use them to your advantage, you will benefit from this session. You will leave knowing what a clustered index is, what a non-clustered index is, when to use them, how to use them, their advantages and disadvantages. We will start at a very high level with simple examples and basic definitions, and then go into details of how indexes work and practical examples of index usage in T-SQL.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev

Level: Beginner

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. You’ll want to take notes, or better yet, bring your laptop and start using Powershell immediately. We will get Posh running and then I’ll introduce you to the basic concepts, with examples to make things happen right away. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Bonus 1

Level: Beginner

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

Building off the earlier session, "Finding & Cleansing Data with Excel Power Query", we will explore more advanced techniques for cleansing data using Excel Power Query including the use of Power Query expressions. Armed with these techniques, analysts should feel confident tackling some of the gnarliest data cleansing challenges.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Integration Services provides the ability to nest packages within one another in a parent/child structure.  By creating a multilayer package infrastructure using native elements of SSIS, you can easily encapsulate reusable components of your ETL layer, simplify logging, and make the development process more efficient.

In this session, we'll take a tour through parent/child design architecture within SSIS.  We'll discuss the advantages of using the parent/child architecture while reviewing various design patterns.  We'll review the capabilities within the various versions of SSIS (2005 through 2014) and discuss the buttons and switches that make it work.  Finally, we'll have a number of realistic demonstrations to fully illustrate these concepts.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Dev

Level: Intermedia

Session Code:

Date: August 23

Time: 12:00 AM - 1:00 AM

Room: TBD

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