Nr: 174
SQLSaturday #174 - Charlotte - BI Edition 2012
SessionID: 10311
What DBAs need to know about SharePoint Databases
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!
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 3
Speaker: Julie Smith
Title: Data Quality Services--Finally!
Abstract:
SessionID: 11227
Top new features in Integration Services 2012
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
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
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
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
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
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
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
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 6
Speaker: Evan Basalik
Abstract:
SessionID: 14235
Explore the Integration Services Catalog
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
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:
SessionID: 14481
Bad SQL
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 1
Speaker: Geoff Hiten
Title: Bad SQL
Abstract:
SessionID: 14482
Moving Day - SQL Migrations with SharePoint
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 2
Speaker: Geoff Hiten
Title: Moving Day - SQL Migrations with SharePoint
Abstract:
SessionID: 15488
SSIS Package Realtime Visualzation Analytics
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
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
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
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
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
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 4
Speaker: Jesse Kraut
Abstract:
SessionID: 16647
Realizing the Power of Analysis Services
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 5
Speaker: Jessica Moss
Title: Realizing the Power of Analysis Services
Abstract:
SessionID: 16648
Exploring your Data with Power View
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
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 5
Speaker: Jose L. Rivera
Title: Predictive Analytics at your fingertips
Abstract:
The Business Intelligence adoption over the last few years has grown dramatically to the point where organizations require business insights, not only from what has already happened (typical data warehousing), but from real-time performance and how will the future be, based on the business and market trends. In this session we will explore and demonstrate the main decision-making capabilities in SQL Server 2012 using Analysis Services, Data Mining and the power behind PowerPivot and PowerView hosted within Excel.
SessionID: 18144
Let's Talk Licensing
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
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
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
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 8
Speaker: Matthew Duffield
Title: Build Your Own Dashboard (BYOD) in HTML5
Abstract:
SessionID: 20219
Put Your Data on the Map
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 6
Speaker: Mark Hudson
Title: Put Your Data on the Map
Abstract:
Columbus demonstrated the world was not flat. Our Address table suggests events occurred at a particular location. SQL Server 2008 supports geospatial data. SQL Server 2008 R2 provides the United States map gallery. Come see how Reporting Services leverages those knowns to present our data in a geographical way.
SessionID: 21413
Display Line of Business Data in SharePoint
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
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
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 3
Speaker: Paul Waters
Title: Automating SSIS Development with Biml
Abstract:
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
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
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?
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
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!
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
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:
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
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 5
Speaker: Steven Wright
Title: Shade Tree Mechanic's Guide to SSAS
Abstract:
SessionID: 26251
SQL Server 2012 Column Store Index
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 2
Speaker: Kevin Boles
Title: SQL Server 2012 Column Store Index
Abstract:
SessionID: 26252
SQL Server Partitioning From A to Z
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"
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
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
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
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:
SessionID: 34711
It's a hard Ops life!
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
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
Event Date: 27-10-2012 - Session time: 00:00:00 - Track: 2
Speaker: Audrey Hammonds
Title: Pretty Output: T-SQL for Presentation
Abstract:
SessionID: 9963
Dimensional Modeling 101
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!