Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 48
SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, there are some painful shortcomings that make it difficult to automate package creation, easily reuse patterns and templates, and create packages directly from schema information and other metadata.  The free and open source BIDS Helper Add-In offers support for automatically generating SSIS packages using the Business Intelligence Markup Language (Biml). 
In this session we will start by showing the power of Biml.  We will then step back, and start from the beginning of using BimlScript.  Once we cover the basics, we will cover practical examples using the BIDS Helper add-in to automate SSIS development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Good Code, Bad Code.  It can be the difference between a server running smoothly and an unresponsive piece of junk.  This session digs into what makes some SQL code perform faster and scale better.  Session is almost all interactive demo.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
1

Level: Intermedia

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Need to have some dashboard reports that support cross-platform devices?  Ever wanted to build your dashboard and see it on the iPad or Android, or Windows 8 Surface?  With this session, we will take a look at what it takes to provide simple dashboards using goodness of HTML5.  We will look at using client-side JavaScript to provide our data using Web API and JSON.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
8

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session I will go over how to separate your systems for transactional databases, and for reporting.  I will lightly cover how this can be done with mirroring, replication, which one is right for your situation. Then deep dive into replication, the agents it creates and their purpose, provide tips, best practices, and dispel any fears you may have heard or validate them.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
6

Level: Intermedia

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever thought to yourself, "I could do a better job at this than the consultant we hired"? Or, "I could make so much more money if I were a consultant"? A career in consulting can be alluring. In this interactive session, we'll discuss strategies for how to become a consultant, as well as the pros and cons of the lifestyle. We'll also talk about the different legal and tax-related issues and costs/benefits of being a consultant, as well as details such as how to determine a rate and how to market your services. Join the discussion on these factors and more to help you figure out if you're cut out to be a consultant.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
8

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

If you haven't seen it yet, SQL Server 2012 introduces a new feature called Data Quality Services (DQS for short). Its easy and quick to learn in an hour. DQS is useful for data stewards and IT professionals who seek to improve the quality of their business data. 

In this intro session, we describe the concept and main principles behind Data Quality Services and demo the main capabilities of the product, such as knowledge management, cleansing, matching, profiling, and the Azure Datamarket Reference Data Services.

Most any business user will quickly see the value of DQS and walk away feeling ready to show off their new found smarts to the rest of their team.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Every organization that stores data stores dirty data, and suffers with how best to handle this unpleasant fact.Organizations must rely on people to deal with data problemseither by paying them to clean it or paying them to work around it. Either way it is costly and only becomes more so over time. Finally with the release of SQL Server 2012, there is a tool to help. Learn how to use the key parts of Data Quality Services: how to create Data Cleansing Knowledge Bases to cleanse data both in the DQS client and inside SSIS 2012, and how DQS Matching Knowledge Bases can integrate with Master Data Services for de-duplication of data. Session focuses on DQS, but also explains how DQS, MDS, and SSIS work together.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

As a database developer, BI specialist or just getting started DBA... How many times have you simply run out of space in your database?  How much better would your life be if you were able to assess your database available space, recognize space problems BEFORE they occur, and make recommendations to your DBA proactively before you hit the ugly "can't auto-grow" error on Friday at 4:30?

This session will leap frog your understanding of database physical files.  You will be given the tools and knowledge to monitor and assess your physical space so you can recommend corrective steps BEFORE they happen.
Speaker:

Session Type:
Regular Session

Track:
1

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

You will need to understand how many-to-many relationships work in tabular models. While different than dimensional models, you can be successful in getting many of the behaviors you will need. Understanding how filters propogate is necessary requisite. We will use a "W" diagram to understand how this occurs in tabular models. Then will will learn how to force filter propogation called cross-filtering. The we will cross-filter conditionally, based on what the user has chosen for filters. If time permits we will also learn how to handle large numbers of fact rows, both in development and production.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
5

Level: Intermedia

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

So many names! Data warehouse, data mart, star-schema, snowflake schema, dimensional model, Type 1, Type 2, Type 3... What does it all mean?  Whether you're a data consumer, ETL specialist, or database designer, it pays to understand the vocabulary and design concepts of dimensional models.  In this session, we'll cover the basics of dimensional modeling, including dimensions, facts, and the ways they all come together.  We'll talk about why denormlization isn't necessarily a dirty word, some common design challenges, and a few ETL considerations.  By the end of the hour, you'll be ready to impress your friends and confound your frenemies with your mad dimensional modeling knowledge!   
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

The Business Connectivity Services (BCS) offered in SharePoint provides a robust way to integrate and display your Line of Business Data.  We will provide a full overview of the feature, show how it can be used to connect to different data sources, and then demonstrate the other advantages of using External Content Types instead of a custom developed report including lookup columns and search.  With this session, you will have the information needed to quickly and securely access your Line of Business data in SharePoint.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
7

Level: Intermedia

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

There are a multitude of data visualization options in a Microsoft environment, Reporting Services, Excel Services,  Performance Point, Power View, 3rd party tools...each of these are specialized tools to fill a specialized need.  In this session we will walk through each of these tools.  Focusing on the most popular tool Excel, we will see how we can take this already excellent tool and extend its capabilities further   At the end of the session the attendee will understand the range of data visualization options and how they can use Excel to design reports for both multidimensional, tabular, and relational models for an enhanced user experience on the PC, Web, and Mobile devices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
6

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

What is the Integration Services Catalog?  If you plan to use SQL 2012 SSIS for your next project, you need to know the free, new features of logging, tracing, and statistics data provided by the Integration Services Catalogs. 
In this session we will walk through the steps to configure the catalogs, explore the database objects inside the catalogs, manage the catalogs, and create/deploy custom report to be used in the catalogs.
Speaker:

Session Type:
Regular Session

Track:
3

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and how to use each one.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
6

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Every second counts when you are trying to achieve real time reporting. In this session Luis will demonstrate how to use Change Tracking and Change Data Capture to very quickly update data warehouse dimensions. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3

Level: Intermedia

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. In this personal development session I'll cover key strategies you can use during the interviews first 10 minutes to increase chances for a new job and new adventure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
8

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This sessions provides insight into the high availability (HA) features planned for SQL Server.  I’ll provide a brief look at current HA options, Clustering, Replication, Mirroring, Log Shipping then explore how these were all combined into new AlwaysOn HA feature for SQL 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This session provides a technical overview of Hadoop targeted for Microsoft DW/BI professionals.  Emphasis will be on how Map/Reduce paradigms complement and extend BI architectures. Specifically highlighted will be the Hadoop ecosystem, HDFS, Cloud vs. On-Premise, and various strategies to integrate SQL and NoSQL technologies into cohesive solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
7

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3

Level: Intermedia

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Tableau is the Swiss Army Knife for analytics professionals and compliments SQL Server relational, SSAS, SSAS Tabular, and PowerPivot. It is quickly becoming a "must have" data tool. 

In this session, you'll learn about Tableau Desktop and see it in action against a variety of Microsoft data sources.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
8

Level: Beginner

Session Code:

Date: October 27

Time: 12:00 AM - 1:00 AM

Room: TBD

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