sqlsathistory

Nr: 174

Back to Main list

SQLSaturday #174 - Charlotte - BI Edition 2012

Start Time (24h) Speaker Track Title
00:00:00 Ben Adams 7 What DBAs need to know about SharePoint Databases
00:00:00 Julie Smith 3 Data Quality Services--Finally!
00:00:00 Cathy Miller 4 Top new features in Integration Services 2012
00:00:00 Chris Skorlinski 8 Get Hired in 10 minutes
00:00:00 Chris Skorlinski 1 High Availability features in the SQL Server 2012
00:00:00 Christopher Price 3 Integrating DQS, MDS and Your Data Warehouse
00:00:00 Dave Turpin 1 Database Physical File Chemistry for the Non-DBA
00:00:00 David Eichner 6 SRS Report Builder for Business Intelligence
00:00:00 David Botzenhart 6 Expanding Productivity Using BI Data Visualization
00:00:00 Evan Basalik 6 Troubleshooting SSRS Performance
00:00:00 Fendy Huang 3 Explore the Integration Services Catalog
00:00:00 Katherine Fraser 5 What's my xVelocity? All about in-memory analytics
00:00:00 Geoff Hiten 1 Bad SQL
00:00:00 Geoff Hiten 2 Moving Day - SQL Migrations with SharePoint
00:00:00 Ira Warren 4 SSIS Package Realtime Visualzation Analytics
00:00:00 James Herring 2 SQL Server PDW an Introductory view
00:00:00 Jason Howell 3 Data Quality Services - Cleanse Matching intro
00:00:00 Javier Guillen 2 Principles of BISM Tabular Modeling
00:00:00 Joe Dib 7 What's new in 2012 - High Level
00:00:00 Jesse Kraut 4 Programmatically Managing the BI Stack Metadata
00:00:00 Jessica Moss 5 Realizing the Power of Analysis Services
00:00:00 Jessica Moss 6 Exploring your Data with Power View
00:00:00 Jose L. Rivera 5 Predictive Analytics at your fingertips
00:00:00 Kevin Goode 8 Let's Talk Licensing
00:00:00 Kevin Goode 4 Let’s get parallel
00:00:00 Luis Figueroa 3 Extremely Fast Dimension Updates with CDC and CT
00:00:00 Matthew Duffield 8 Build Your Own Dashboard (BYOD) in HTML5
00:00:00 Mark Hudson 6 Put Your Data on the Map
00:00:00 Mike Oryszak 7 Display Line of Business Data in SharePoint
00:00:00 Paul Rizza 4 Upgrading to SSIS 2012
00:00:00 Paul Waters 3 Automating SSIS Development with Biml
00:00:00 Paul Wood 8 Making your Data "sing" with Visio Services
00:00:00 Rafael Salas 4 Waiter, There's a Fly In My Data
00:00:00 Rick Heiges 8 Considering Consulting as a Career?
00:00:00 Rob Kerr 7 Incorporating Hadoop into your DW/BI Strategy
00:00:00 Rob Volk 2 Tame Your Unruly Data...With Constraints!
00:00:00 Russell Christopher 8 Introduction to Tableau: SQL Server's Best Friend
00:00:00 Steven Wright 5 Shade Tree Mechanic's Guide to SSAS
00:00:00 Kevin Boles 2 SQL Server 2012 Column Store Index
00:00:00 Kevin Boles 1 SQL Server Partitioning From A to Z
00:00:00 Wayne Snyder 5 Deeper into Tabular Models - M-to-M and the "W"
00:00:00 Bill Carroll 1 Service Broker Primer
00:00:00 William E Pearson III 7 Overcoming Barriers and Avoiding Mistakes with BI
00:00:00 William E Pearson III 5 Prototype with PowerPivot: External SSAS Groups
00:00:00 Leo Furlong 7 It's a hard Ops life!
00:00:00 Anthony Sammartino 6 Conquer Reporting By Scaling Out SQL Server
00:00:00 Audrey Hammonds 2 Pretty Output: T-SQL for Presentation
00:00:00 Audrey Hammonds 1 Dimensional Modeling 101

SessionID: 10311

What DBAs need to know about SharePoint Databases

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 7

Speaker: Ben Adams

Title: What DBAs need to know about SharePoint Databases

Abstract:

The backbone for SharePoint is a strong SQL Server to support the environment. Let's review how SharePoint Databases behave and how to care and maintain them. What is the proper setup for a SQL Server that is supporting SharePoint? What are some pitfalls to watch out for? We will also review some tools that can help make your life easier in monitoring your SQL Server when it comes to SharePoint Databases.

SessionID: 11108

Data Quality Services--Finally!

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 3

Speaker: Julie Smith

Title: Data Quality Services--Finally!

Abstract:

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.

SessionID: 11227

Top new features in Integration Services 2012

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 4

Speaker: Cathy Miller

Title: Top new features in Integration Services 2012

Abstract:

The newest version of SQL Server 2012 introduces many new BI features. This session will help DBAs and ETL Developers ramp up by demonstrating the major changes in SSIS 2012!

SessionID: 11562

Get Hired in 10 minutes

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 8

Speaker: Chris Skorlinski

Title: Get Hired in 10 minutes

Abstract:

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.

SessionID: 11563

High Availability features in the SQL Server 2012

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 1

Speaker: Chris Skorlinski

Title: High Availability features in the SQL Server 2012

Abstract:

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.

SessionID: 11952

Integrating DQS, MDS and Your Data Warehouse

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 3

Speaker: Christopher Price

Title: Integrating DQS, MDS and Your Data Warehouse

Abstract:

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.

SessionID: 12228

Database Physical File Chemistry for the Non-DBA

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 1

Speaker: Dave Turpin

Title: Database Physical File Chemistry for the Non-DBA

Abstract:

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.

SessionID: 12727

SRS Report Builder for Business Intelligence

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 6

Speaker: David Eichner

Title: SRS Report Builder for Business Intelligence

Abstract:

Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder makes creating executive dashboards easy!

SessionID: 12879

Expanding Productivity Using BI Data Visualization

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 6

Speaker: David Botzenhart

Title: Expanding Productivity Using BI Data Visualization

Abstract:

SessionID: 14002

Troubleshooting SSRS Performance

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 6

Speaker: Evan Basalik

Title: Troubleshooting SSRS Performance

Abstract:

Evan will discuss and demonstrate how to troubleshoot Reporting Services performance issues. This will cover both tools included in the product plus some real-world scenarios he has dealt with in the past.

SessionID: 14235

Explore the Integration Services Catalog

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 3

Speaker: Fendy Huang

Title: Explore the Integration Services Catalog

Abstract:

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.

SessionID: 14332

What's my xVelocity? All about in-memory analytics

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 5

Speaker: Katherine Fraser

Title: What's my xVelocity? All about in-memory analytics

Abstract:

Originally called the Vertipaq engine, SQL Server 2012 uses in-memory column-oriented storage and compression to be able to process millions of rows with sub-second response time on desktop hardware. In this session we'll talk about how xVelocity is used inside PowerPivot and Analysis Services Tabular models to give performance improvements to data warehousing and business intelligence. We'll look at the columnstore index and SSAS/PowerPivot implementations and what the memory limitations are.

SessionID: 14481

Bad SQL

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 1

Speaker: Geoff Hiten

Title: Bad SQL

Abstract:

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.

SessionID: 14482

Moving Day - SQL Migrations with SharePoint

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 2

Speaker: Geoff Hiten

Title: Moving Day - SQL Migrations with SharePoint

Abstract:

Moving day is one of life's most stressful times. Details drown you, critical items consume time and attention, and there is always someone demanding you get something done now. This is true whether you are moving where you live or your data platform. SQL Server migrations are a core competency for a DBA. This presentation will give you a strong structured process for a successful SQL Server migration using examples focused on SharePoint workloads.

SessionID: 15488

SSIS Package Realtime Visualzation Analytics

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 4

Speaker: Ira Warren

Title: SSIS Package Realtime Visualzation Analytics

Abstract:

Implement an SSIS Framework to track the progress of SSIS production packages similar to how you can in the BIDS Designer, and explore your package withs windows explorer like capability.Utilizing the “out of the box” SSIS Logging with no changes required to the existing logic or packages. The new framework will also use SSIS to scan existing packages and automatically discover Master / Child package relationships and providing a capability for package restartability. This design pattern can be use to replace earlier “Stored Proc” version of SSIS Framework greatly reducing the code required. This functionality is complementary to the 2012 Package Tracking capability.

SessionID: 15550

SQL Server PDW an Introductory view

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 2

Speaker: James Herring

Title: SQL Server PDW an Introductory view

Abstract:

This session is designed to introduce the audience to Microsoft Parallel Data Warehouse (PDW) and how an MPP Architecture can be useful to them in their current BI Environment.

SessionID: 15913

Data Quality Services - Cleanse Matching intro

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 3

Speaker: Jason Howell

Title: Data Quality Services - Cleanse Matching intro

Abstract:

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.

SessionID: 15995

Principles of BISM Tabular Modeling

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 2

Speaker: Javier Guillen

Title: Principles of BISM Tabular Modeling

Abstract:

Although the Tabular framework is based on simple one-to-many relationships, there are important rules to follow when modeling business scenarios: DAX direction of context propagation, Lookup vs Base tables, disconnected tables and calculated aggregate tables are some of the things to consider when delivering real life Analysis Services models. This session reviews some of the most important 'gotchas' encountered when doing developing SSAS models.

SessionID: 16245

What's new in 2012 - High Level

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 7

Speaker: Joe Dib

Title: What's new in 2012 - High Level

Abstract:

You have heard the news. You could not escape the buzz. It is coming. It is coming. SQL Server 2012 (denali) is here! What is in it? This session will survey SQL Server 2012 at a high level focusing on BI components. This session is perfect for managers or anyone who is looking into SQL Server 2012 for the first time.

SessionID: 16645

Programmatically Managing the BI Stack Metadata

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 4

Speaker: Jesse Kraut

Title: Programmatically Managing the BI Stack Metadata

Abstract:

This session will dive into the the SSIS toolkit by creating SSIS Custom Components in SQL Server 2008 and 2012. Discuss how to register the custom components and add to the SSIS Toolbox. Demonstrate a method to open an SSIS package with a C# script and read or make changes to the package design. The start of data driven design and programmatically creating packages, scan an entire BIDS Solution all cubes, dimensions, and connections in SSAS using Analysis Management Objects (AMO) with C#. This allows us to create a metadata mart and full documentation of our SSAS cubes.

SessionID: 16647

Realizing the Power of Analysis Services

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 5

Speaker: Jessica Moss

Title: Realizing the Power of Analysis Services

Abstract:

Once you’ve loaded your data into a star schema and built an Analysis Services 2008 R2 cube around it, you are ready to harness the power of multi-dimensional analysis. Then, what are your next steps? You need to decide how to create and display reports, to change your cube design based on your choice of reporting outlet, and determine any additional special considerations. This session will answer these questions and explore the different reporting options, such as Reporting Services and PerformancePoint Services, when deriving business intelligence from an Analysis Services cube.

SessionID: 16648

Exploring your Data with Power View

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 6

Speaker: Jessica Moss

Title: Exploring your Data with Power View

Abstract:

SessionID: 16946

Predictive Analytics at your fingertips

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 5

Speaker: Jose L. Rivera

Title: Predictive Analytics at your fingertips

Abstract:

SessionID: 18144

Let's Talk Licensing

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 8

Speaker: Kevin Goode

Title: Let's Talk Licensing

Abstract:

Being a DBA is not all smiles and sunshine; sometimes you have to deal with the tedious topic of licensing. As a DBA, developer, or consultant, you are responsible for ensuring that your company or client is in compliance and can pass software audits. As with any Microsoft product license, there are complicated nuances of the SQL Server licensing program with many new twists added in 2012. This session will help you understand what you can and cannot do with various license types, and, how you could save your company some serious money.

SessionID: 18146

Let’s get parallel

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 4

Speaker: Kevin Goode

Title: Let’s get parallel

Abstract:

Have you ever wondered how Microsoft and Unisys loaded 1TB of data in 30 minutes? They used as many parallel processes as possible. This session will walk through a solution that makes heavy use of parallel processing. We will look at the use of scope to isolate threads and script tasks to determine and spread the workload across multiple threads. Additionally, we will look at how to determine how many parallel processes should be run on a single server and techniques to spread loads over multiple servers.

SessionID: 19002

Extremely Fast Dimension Updates with CDC and CT

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 3

Speaker: Luis Figueroa

Title: Extremely Fast Dimension Updates with CDC and CT

Abstract:

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.

SessionID: 19823

Build Your Own Dashboard (BYOD) in HTML5

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 8

Speaker: Matthew Duffield

Title: Build Your Own Dashboard (BYOD) in HTML5

Abstract:

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.

SessionID: 20219

Put Your Data on the Map

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 6

Speaker: Mark Hudson

Title: Put Your Data on the Map

Abstract:

SessionID: 21413

Display Line of Business Data in SharePoint

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 7

Speaker: Mike Oryszak

Title: Display Line of Business Data in SharePoint

Abstract:

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.

SessionID: 21783

Upgrading to SSIS 2012

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 4

Speaker: Paul Rizza

Title: Upgrading to SSIS 2012

Abstract:

As the newest version of SQL Server, 2012 is introducing many new BI features. This session will look at what has changed in SSIS 2012 and how to best leverage these new features to get the most for your ETL effort!

SessionID: 21818

Automating SSIS Development with Biml

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 3

Speaker: Paul Waters

Title: Automating SSIS Development with Biml

Abstract:

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.

SessionID: 22406

Making your Data "sing" with Visio Services

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 8

Speaker: Paul Wood

Title: Making your Data "sing" with Visio Services

Abstract:

With the SharePoint 2010 and Visio 2010 releases, the ability to quickly create and share powerful, intuitive, automatically-refreshing dashboard visualizations of both your critical IT and business data has never been easier to accomplish. We will cover a quick overview of SharePoint Visio Services, Visio 2010 tips and tricks, and connecting Visio diagrams to data in varios common data sources like Excel, SharePoint and SQL Server. Several demos of how to do this will enable you to leave this session with the knowledge needed to immediately start using Visio Services to make your existing data tell a real story in your organization.

SessionID: 22951

Waiter, There's a Fly In My Data

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 4

Speaker: Rafael Salas

Title: Waiter, There's a Fly In My Data

Abstract:

Dealing with bad data is a painful and expensive experience.  In this session we will jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with  SQL Server Data Quality Services (DQS) and Integrations Services (SSIS). We will dive into DQS knowledge-driven approach, reusability, cleansing and matching, and explore the collaboration opportunities between data stewards and IT professionals.  You will demonstrate how to create a knowledge base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component.

SessionID: 22972

Considering Consulting as a Career?

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 8

Speaker: Rick Heiges

Title: Considering Consulting as a Career?

Abstract:

SessionID: 23082

Incorporating Hadoop into your DW/BI Strategy

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 7

Speaker: Rob Kerr

Title: Incorporating Hadoop into your DW/BI Strategy

Abstract:

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.

SessionID: 23302

Tame Your Unruly Data...With Constraints!

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 2

Speaker: Rob Volk

Title: Tame Your Unruly Data...With Constraints!

Abstract:

Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!

SessionID: 23605

Introduction to Tableau: SQL Server's Best Friend

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 8

Speaker: Russell Christopher

Title: Introduction to Tableau: SQL Server's Best Friend

Abstract:

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.

SessionID: 25941

Shade Tree Mechanic's Guide to SSAS

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 5

Speaker: Steven Wright

Title: Shade Tree Mechanic's Guide to SSAS

Abstract:

This is a session for the SQL DBA that has SSAS in their environment, but is not sure what happens under the hood when it queried, much less how to tell if it's performing at its best. This is not a session on query optimization. But, this session will help you better understand if there is room for query optimization or if some basic configuration changes might provide that needed boost. We'll discuss the basic architecture of SSAS and cover some of the most pertinent metrics to give you a quick and easy view into your SSAS server's performance.

SessionID: 26251

SQL Server 2012 Column Store Index

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 2

Speaker: Kevin Boles

Title: SQL Server 2012 Column Store Index

Abstract:

Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.

SessionID: 26252

SQL Server Partitioning From A to Z

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 1

Speaker: Kevin Boles

Title: SQL Server Partitioning From A to Z

Abstract:

SQL Server Partitioning from A to Z We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.

SessionID: 27675

Deeper into Tabular Models - M-to-M and the "W"

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 5

Speaker: Wayne Snyder

Title: Deeper into Tabular Models - M-to-M and the "W"

Abstract:

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.

SessionID: 27778

Service Broker Primer

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 1

Speaker: Bill Carroll

Title: Service Broker Primer

Abstract:

Introduction to the service broker feature and what is new for service broker in SQL Server 2012

SessionID: 28028

Overcoming Barriers and Avoiding Mistakes with BI

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 7

Speaker: William E Pearson III

Title: Overcoming Barriers and Avoiding Mistakes with BI

Abstract:

A Dynamic Dialog session: Whether you’re considering implementing business intelligence for the first time, have completed projects in the past (and are perhaps looking at later phases), or are somewhere in between, an investment in this session will likely pay dividends. Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog about common pitfalls or traps that we can encounter in designing and implementing BI. We’ll discuss, as a group, environmental and other challenges we have experienced, and share ways to avoid or minimize them, in our ongoing efforts with BI.

SessionID: 28031

Prototype with PowerPivot: External SSAS Groups

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 5

Speaker: William E Pearson III

Title: Prototype with PowerPivot: External SSAS Groups

Abstract:

Once the enterprise implements SSAS, immediate reporting benefits appear as the power of OLAP is unleashed in the speed of aggregations, the support of organization-wide ad hoc analysis and reporting, and myriad other advantages. A common need that then often arises is the capability to perform extra-hierarchy groupings. In this session, BI Architect and MVP Bill Pearson presents an approach to accomplishing external grouping with PowerPivot. We examine ways to accomplish a stated, example business need for such grouping via the addition of PowerPivot to an integrated Microsoft BI solution. Moreover, we discuss ways to design a scalable solution with PowerPivot that we can then entrain into the base warehouse / mart / cube structure.

SessionID: 34711

It's a hard Ops life!

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 7

Speaker: Leo Furlong

Title: It's a hard Ops life!

Abstract:

MDM isn't just about technology implementation, but about going through the real pain, trials, and tribulations of addressing core issues the company has in the areas of Organization, Process, Data Management/Data Governance, and Technology.

Join John Head and Leo Furlong as they discuss the process of trying to discover a company’s operational MDM issues, set up a program for addressing the real problems, and trying to make real organization change to not only clean up the data, but prevent it from getting dirty in the first place.

http://www.youtube.com/watch?v=s4sQI8Evfhcfeature=fvst

SessionID: 9910

Conquer Reporting By Scaling Out SQL Server

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 6

Speaker: Anthony Sammartino

Title: Conquer Reporting By Scaling Out SQL Server

Abstract:

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.

SessionID: 9962

Pretty Output: T-SQL for Presentation

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 2

Speaker: Audrey Hammonds

Title: Pretty Output: T-SQL for Presentation

Abstract:

So you've got your data in the database? That's great! Now... how about getting it back out? Sometimes complex reports call for complex queries, and this session is all about that. Want to pivot your rows into columns? Sure. Want to format that self-referencing hierarchy? Got it. Ranking? Windowing? No problem. In this session we'll cover some common data formatting issues and the T-SQL solutions that make them a little less scary.

SessionID: 9963

Dimensional Modeling 101

Back to calendar

Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 1

Speaker: Audrey Hammonds

Title: Dimensional Modeling 101

Abstract:

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!