Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 23
Power Map, formerly called GeoFlow, is one of Microsoft’s latest releases in the BI spectrum. It provides for 3D geospatial and temporal visualization of data. In this session we’ll first compare and contrast the geospatial reporting capabilities of SSRS, Power View, and Power Map. We’ll then quickly learn the Power Map tool and create some interactive geospatial animated tours. We’ll also discuss the concept of datums, which is relevant for those using latitude and longitude. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Bonus

Level: Beginner

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever wonder what should go in a fact table and what belongs in a dimension?  Have a suspicion that you’re forgetting important dimensions?  Wouldn't it be great if somehow your design was self-documenting?  In this session I’ll give you a couple new tools and show you a new way to look at your star schema.  We’ll go past ‘why’ to see ‘how’ dimensional design is a great fit with the agile principles.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you starting to plan for high availability and curious to see how clustering can keep your databases online and mitigate downtime during patching? Have you heard about clustering but have no idea what is required to build a successful cluster? If so, this session is for you.  During this session we will compare the pros and cons of Failover Cluster Instances to ensure you implement the best solution to handle you’re HA requirements. We will build a windows cluster from scratch and go over all the requirements including failover cluster manager, nodes, shared storage, active directory, client access points, quorums and installing a SQL Server clustered instance.  Finally, we will go over a basic framework to help you quickly perform a root cause analysis to determine why your SQL services went down.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

From the expect disasters of failed hardware, malicious and unintentional data corruption, to the more unusual disasters of HVac failures, water main breaks, and fire, we will walk through case studies of each type, discuss what went right and what went wrong with the disaster recovery plan and how to plan better in the future. This session is intended to be interactive, to have you thinking about your own environment and what you need to put into place to help you successfully recover from disasters.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL provides many ways to move data from an OLTP source system to a data warehouse server, however choosing the most efficient and scalable ETL solution can be challenging. Various 
ETL architectures will be explored by analyzing their strengths and weaknesses with data warehouse workloads. Best practices based on having developed ETL systems that load 1+ TB/hr. will be presented.  
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Many data professionals understand the basics of Data Warehouse design, including Dimension and Fact Tables, slowly changing Dimensions, and the use of meaningless surrogate keys. However, it isn’t until you’ve created a dimensional model and put it into production, that you realize just how much of an impact seemingly trivial mistakes can make. They can hobble performance, allow inaccuracy, and perhaps worst of all, inhibit adoption and usage of the new system. 

Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Bonus

Level: Intermedia

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Designing databases from User requirements is an art form even when you focus on implementing a strict ANSI compliant system. There is more to the database design then table structures and T-SQL statements.  In this session you will learn how to translate user requirements into a database design which utilizes the new and existing features to create an efficient and manageable system.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Developer

Level: Intermedia

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI.  In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model ("BISM").  He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”).  Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Even in the most reliable ETL system, it's eventually going to happen: A package will fail, an output row count won't match what is expected, a data anomaly will force a forensic search of the package infrastructure... In this session, we'll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we'll cover various ways to keep your ETL flowing when problems arise.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

You’ve got data to load into an already existing table, perhaps a slowly changing dimension, and need a method that is simple, supportable, and performs well. The T-SQL Merge statement, introduced in SQL 2008, can do all of this and more. Many DBAs investigate it, but find it unintuitive, time consuming, or they couldn’t get it to perform well. This doesn’t need to be difficult; after attending this session you’ll thoroughly understand the fundamentals of the merge statement and how to write them. You will also leave with scripts which automatically write well formed merge statements for you in less than 1 minute, guaranteed. Come see how. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Developer

Level: Intermedia

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

If you have ever had a Kerberos or SSPI context error, then you won't want to miss this session.  SQL Server has a large surface area and Active Directory can influence a big part of it.  I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server.  By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.
Speaker:

Session Type:
Regular Session

Track:
Bonus

Level: Advanced

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft has provided some great tools for creating and editing SSIS packages.  First Business Intelligence Development Studio (BIDS) then SQL Server Data Tools (SSDT).  However, when creating an SSIS package you frequently repeat the same steps over and over.  BIML is an XML markup language designed for representing the structure of an SSIS package.  BIML Script takes that structure and generates an SSIS package.In this session we will use BIDS Helper to create a simple SSIS package using BIML.  We will handle a couple SSIS scenarios with BIML and BIML Script.  
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

XML is all over the place.  But how do you get that data into SQL Server?  SSIS provides an XML Source, but it is not easy to use.  In this session we will handle increasingly complex XML documents.  After an introduction to using the XML Source with a single set of elements, we will look at how to work with multiple element sets.  This includes hierarchically structured XML documents.Attendees will be able to import simple XML using SSIS.  They will be able to create import routines that pull data from different elements of more complex XML.  They will understand the role the XML Schema plays in defining the XML data they import. 
Speaker:

Session Type:
Regular Session

Track:
Developer

Level: Intermedia

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

This session provides a demonstration-rich introduction to the fundamentals of Hadoop and the Microsoft implementation, HDInsight.  If you have heard of Hadoop but have struggled to get started with the technology, this session is for you. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Bonus

Level: Beginner

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server MVP and Business Intelligence Architect Bill Pearson leads an introduction to using Excel 2013 to deliver self-service business intelligence.  The focus of this session is to help those unfamiliar with the BI features that debut in Excel 2013 to become familiar with the assembly of data from diverse sources into models that deliver BI upon demand.  We’ll discuss accessing and relating data, and employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise.  Moreover, we will overview other BI-related features, including Data Mining and the exciting new Power View reporting capabilities.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Bonus

Level: Beginner

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how to architect a data warehouse that gets predictable and reliable performance into the HUNDREDS of terabytes. This presentation will focus on both hardware and software best practices for data warehouse specific workloads and will also provide and introduction to Parallel Data Warehouse V2 which scales into multi-petabytes.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session get an overview of the basics of sharing a SQL table as a 'List' using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users dynamic PowerPivot analysis in a dashboard.
Speaker:

Session Type:
Regular Session

Track:
Developer

Level: Beginner

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever wanted to know what happens in SQL Server when you use PowerShell and SMO to manage a SQL Server?  How fast can your automation really go? I will take you through the most common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency.  We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce.  Come peek behind the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO.  You'll be glad you did.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Advanced

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Security is a very broad and scary topic, one which
many days could be dedicated to speaking on it.  In this session Matt will
give a high level overview of what Database Security is, what tools
Microsoft gives you to accomplish it and some simple things that you can do
to shrink your attack surface.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: August 24

Time: 12:00 AM - 1:00 AM

Room: TBD

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