Nr: 131
SQLSaturday #131 - Phoenix 2012
SessionID: 10132
What's New in SQL Server 2012 SSIS Development
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: SSIS
Speaker: Brad Baker
Title: What's New in SQL Server 2012 SSIS Development
Abstract:
in SQL Server 2012 Integration Services. These changes can be organized into the categories of development, deployment and administration. This presentation will be focused on what's new in SQL Server 2012 SSIS development.
SessionID: 11318
Real-time Data Warehouse and Reporting
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: Carlos Bossy
Title: Real-time Data Warehouse and Reporting
Abstract:
SessionID: 11321
Fast-track to BI Analytics with SQL Server 2012
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: Carlos Bossy
Title: Fast-track to BI Analytics with SQL Server 2012
Abstract:
SessionID: 11747
Backup Basics - Know your options
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Meredith Ryan-Smith
Title: Backup Basics - Know your options
Abstract:
Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one.
SessionID: 11748
Replication Basics
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev / DBA
Speaker: Meredith Ryan-Smith
Title: Replication Basics
Abstract:
Let's cover the basics of setting up and monitoring SQL server Replication. I will focus on configuring transactional replication including options for the distributor, and where to run your log reader agents - but rest assured we will touch on merge and snapshot replication as well.
SessionID: 11758
Powershell for the DBA
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Colin Smith
Title: Powershell for the DBA
Abstract:
This will be a 100 level class that discusses the basics of powershell, how to set it up, how to use it, and how it will help the DBA be more productive. This will also include examples for SQL Server 2012.
SessionID: 12817
Introduction to SQL Server 2012 AlwaysON
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Microsoft
Speaker: David Ikeda
Title: Introduction to SQL Server 2012 AlwaysON
Abstract:
SessionID: 12818
Training Certifications for SQL Server 2012
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Professional Development / Azure
Speaker: David Ikeda
Title: Training Certifications for SQL Server 2012
Abstract:
SessionID: 13092
“BEGIN…COMMIT” is Not Enough
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev / DBA
Speaker: Denise McInerney
Title: “BEGIN…COMMIT” is Not Enough
Abstract:
Understanding Transactions
Transactions are essential to maintaining data integrity. Getting transactions right means understanding both how they work and the business rules that govern your data. This session will explain the fundamentals of transactions and how they behave in SQL Server. It will delve into ACID properties, isolation levels and nested transactions. The session will also review how to structure transactions to satisfy business rules and ensure efficient performance.
SessionID: 14862
SQL Server 2012 Memory Manager Changes
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Microsoft
Speaker: Gus Apostol
Title: SQL Server 2012 Memory Manager Changes
Abstract:
SessionID: 14863
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Microsoft
Speaker: Gus Apostol
Abstract:
SessionID: 15524
SSRS 2012 and SharePoint 2010 Integration
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Delivery
Speaker: Jacob Wilson
Title: SSRS 2012 and SharePoint 2010 Integration
Abstract:
No more SSRS report database??? Learn about the new SSRS architecture in SQL 2012 for SharePoint 2010 integration and how the architecture has been pushed away from SQL into SharePoint.
SessionID: 16357
Transact-SQL does Windows
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev
Speaker: Jeff Jones
Title: Transact-SQL does Windows
Abstract:
According to Itzik Ben-Gan: “Windowing functions are the best thing to happen since sliced bread”. In SQL Server 2005, Microsoft introduced SQL Windowing into Transact-SQL with new ranking functions and existing aggregate functions. This gave the Transact-SQL developer the ability to easily generate row numbers and compute sums, averages, etc. while returning detailed data rows. But the ANSI/ISO SQL standard had defined additional windowing functionality and SQL Server 2012 now supports more of it. This includes the ability to frame the scope of the window and new functions like LAG, LEAD, FIRST_VALUE and LAST_VALUE. These enhancements extend the set-based functionality of Transact-SQL.
SessionID: 17502
SSAS - Usage Based Optimization
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: Josh Sivey
Title: SSAS - Usage Based Optimization
Abstract:
SessionID: 17503
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: Josh Sivey
Abstract:
In this talk, we discuss how to use the LastNonEmpty AggregateFunction available in SSAS Enterprise Edition to enable "point in time" reporting and analysis. We'll also discuss point in time reporting strategies if you don't have SSAS Enterprise Edition.
SessionID: 17808
How To Create A BI Semantic Model
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: Jason Volpe
Title: How To Create A BI Semantic Model
Abstract:
This session will demonstrate how a BI semantic model is created, how it's used once it's created, and how to maintain it once it's deployed. The BI semantic model is a critical component in the new SQL 2012 BI capabilities.
SessionID: 17809
The Ins and Outs of PowerView
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Microsoft
Speaker: Jason Volpe
Title: The Ins and Outs of PowerView
Abstract:
SessionID: 17810
What Does SQL 2012 Mean For SharePoint
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Microsoft
Speaker: Jason Volpe
Title: What Does SQL 2012 Mean For SharePoint
Abstract:
SessionID: 17966
Agile modeling and reporting with BISM and Azure
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Professional Development / Azure
Speaker: Kathrine Lord
Title: Agile modeling and reporting with BISM and Azure
Abstract:
SessionID: 17967
Best Practices for Monitoring Databases on VMware
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Kathy Gibbs
Title: Best Practices for Monitoring Databases on VMware
Abstract:
SessionID: 18980
Migrating Oracle to SQL Server
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Microsoft
Speaker: Lou Carbone
Title: Migrating Oracle to SQL Server
Abstract:
Session will cover overall method to migrate from an Oracle database to a SQL Server database. Will address architecture. Key components:
Methodology, Demonstration of SSMA (Reports, potentially data migration itself, time permitting) (Using Oracle 11i database(data warehouse structure) to SQL Server 2012.)
SessionID: 19339
What's this columnstore index thing all about?
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: Matt Smith
Title: What's this columnstore index thing all about?
Abstract:
SessionID: 19744
Temporal Fact Tables: The Road Less Traveled
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: Martin Schoombee
Title: Temporal Fact Tables: The Road Less Traveled
Abstract:
Snapshot fact tables are a common approach when a point-in-time reference is required. In some cases though, even snapshots are not an option due to the amount of data it will generate.
In this session we will walk through a practical example of when and how to implement temporal fact tables, and how these can be a viable alternative to snapshots in certain situations.
SessionID: 19745
DW Architecture: More than just Facts Dimensions
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: Martin Schoombee
Title: DW Architecture: More than just Facts Dimensions
Abstract:
Facts and Dimensions are the essence of any Data Warehouse, but there are many other components required to make the environment scalable, flexible and fully automated.
There are lots of decisions to be made: Should you have a separate database for staging or not? How do you fully automate the ETL sub-system and parameterize it?
In this session we will discuss a practical approach to designing the Data Warehouse back-end, based on personal experience.
SessionID: 22481
Understanding SQL Server XML Features
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev / DBA
Speaker: Randy Knight
Title: Understanding SQL Server XML Features
Abstract:
The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server.
SessionID: 22482
But it worked great in Dev! Perfomance for Devs
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev
Speaker: Randy Knight
Title: But it worked great in Dev! Perfomance for Devs
Abstract:
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.
SessionID: 22483
Become Bilingual! Oracle for the SQL Server DBA
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev / DBA
Speaker: Randy Knight
Title: Become Bilingual! Oracle for the SQL Server DBA
Abstract:
SessionID: 22903
Advanced SQL Server Integration Services
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: SSIS
Speaker: Jeff Renz
Title: Advanced SQL Server Integration Services
Abstract:
This is a demo intensive deep dive showing a variety of SSIS methods that you can use to load unstructured text files, gigabyte size files, images, XML, Excel, email, and binary files. I will share techniques that allow files to be loaded in real time with a queue system to load small files separate from large files, file merging for fast loading, and parallel file loading using master/child packages and custom SSIS objects. Finally, I will share useful C# code for parsing complex strings, data manipulation and file archival.
SessionID: 22904
The 2012 Data Warehouse Architecture Debate
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: Jeff Renz
Title: The 2012 Data Warehouse Architecture Debate
Abstract:
Data vault is a compelling new architecture for an enterprise data warehouse. Star schema data warehouses are the most well-known design pattern in the industry. Are hub, link and satellite tables your cup of tea or are you more of a fact and dimension type of person? Come with an open mind to our session and cast your vote for the architecture that you prefer. No matter which way you vote, you will come away with a deeper understanding of the data vault and star schema architectures, the pros and cons of both, and new implementation techniques to leverage new features of SQL Server 2012.
SessionID: 22905
The Best Dashboard on the Block
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Delivery
Speaker: Jeff Renz
Title: The Best Dashboard on the Block
Abstract:
SessionID: 23087
Using TVPs in .Net applications
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev
Speaker: Robert Miller
Title: Using TVPs in .Net applications
Abstract:
SessionID: 23088
Using Change Tracking and Change Data Capture
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev
Speaker: Robert Miller
Title: Using Change Tracking and Change Data Capture
Abstract:
Review and compare Change-Tracking and Change Data Capture functionality.
SessionID: 23108
SSIS 2012 Mgmt Considerations Best Practices
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: SSIS
Speaker: Rushabh Mehta
Title: SSIS 2012 Mgmt Considerations Best Practices
Abstract:
SessionID: 23919
Automation and Monitoring for the DBA
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Samuel greene
Title: Automation and Monitoring for the DBA
Abstract:
SessionID: 24031
What is this cache and how did it get so big?
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Doug Brendle
Title: What is this cache and how did it get so big?
Abstract:
Ever wonder what's in your SQL Plan cache? Wonder why or how the plan cache got so big? This session will cover what the cache is, how it is used, and how poor application and query design can make it worse. Rather than put participants to sleep with dozens of slides we will get down and dirty with lots of demos including .Net code and some cool DMVs to guide the way.
SessionID: 24450
Branding Yourself for a Dream Job
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Professional Development / Azure
Speaker: Steve Jones
Title: Branding Yourself for a Dream Job
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
SessionID: 24451
Encryption in SQL Server
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev
Speaker: Steve Jones
Title: Encryption in SQL Server
Abstract:
There are a number of encryption options in SQL Server and this session will talk about many of them, looking briefly at TDE, hashing, encryption keys, and SSL encrpytion.
SessionID: 24719
(Way Too Much) Fun with Reporting Services
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Delivery
Speaker: Stacia Varga
Title: (Way Too Much) Fun with Reporting Services
Abstract:
SessionID: 24720
Data Visualization in Reporting Services
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Delivery
Speaker: Stacia Varga
Title: Data Visualization in Reporting Services
Abstract:
Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what's new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.
SessionID: 24721
Power View: A Peek Behind the Curtain
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Delivery
Speaker: Stacia Varga
Title: Power View: A Peek Behind the Curtain
Abstract:
SessionID: 26942
Stupid SQL and the Programmers that Write it
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev
Speaker: Mark Bosley
Title: Stupid SQL and the Programmers that Write it
Abstract:
You work with smart people, but there you are in a code review of a co-worker's SQL ready to be rushed into production and it is so elaborately stupid that you don't know where to start. How did we get here? Why is the level of SQL literacy so low?
There are two goals in the session. First, we will look at lot's of stupid SQL. Second, we will talk about how to encourage co-workers to write better SQL.
Looking at stupid SQL can help even experienced programmers as we examine why something is wrong. Along the way, we note where SQL Server itself is stupid (e.g. the IsNumeric function)
We will also look at some places where some subtleties of SQL can trip even an experienced Pro.
SessionID: 26986
"Ad Hoc Analytics – Can my customer do that?”
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Delivery
Speaker: Tom Marek
Title: "Ad Hoc Analytics – Can my customer do that?”
Abstract:
In a customer service based business world the newest feature being offered to clients in many industries is access to their data for ad hoc analytics. Agile players in many industries are stealing away market share because of this additional feature they can offer and in turn is forcing big players in every industry to just keep up to hold their ground. SQL Server 2012 will be in the middle of this battle and will give us the ability to deliver this feature without building the entire system from scratch. This feature is brought to us by using the new Power View and Business Intelligence Semantic Model all surfaced using SharePoint 2010.
*** This session will be co-presented by Jacob Wilson who is a SharePoint MCM ***
SessionID: 26988
BISM Partitions, Security and Hierarchies
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: Tom Marek
Title: BISM Partitions, Security and Hierarchies
Abstract:
PowerPivot took end users a long way towards creating some amazing self-service data models that we are starting to find are very valuable to the business. Now how do we take these models to the next level and truly allow enterprise access to something that may have just lived in a team site previously? This is where the new features of Business Intelligence Semantic Models (BISM) come into play. We will take a BISM model from its baseline roots of a PowerPivot and drive it to the enterprise level showcasing partitioning, security, and hierarchies while explaining how these will come into play in a real world business scenario.
SessionID: 27039
T-SQL Utilities for Serious DBAs
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: App Dev / DBA
Speaker: Tom Kallal
Title: T-SQL Utilities for Serious DBAs
Abstract:
Don’t miss this useful six pack of production-quality, system-level stored procedures.
Source code is fully documented, and contains many valuable tips for querying SQL Server system views.
The author will demonstrate each utility, and offer suggestions for extending it.
SessionID: 27884
Beyond Plateaux: Optimize SSAS with Best Practices
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: William E Pearson III
Title: Beyond Plateaux: Optimize SSAS with Best Practices
Abstract:
SessionID: 27887
Documenting Your Integrated Microsoft BI Solution
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Professional Development / Azure
Speaker: William E Pearson III
Title: Documenting Your Integrated Microsoft BI Solution
Abstract:
Having implemented BI solutions for years, I have found documentation to be a task too often resisted until late in the project, when it is hastily and incompletely prepared in remaining hours. Because the integrated Microsoft BI solution comprises multiple application layers, it is challenging to generate documentation about the whole solution in a single, unified document. In this presentation I will share approaches I’ve come to use in assembling documentation that “covers all the bases.”
SessionID: 27890
Many-to-Many: Multiple Calendars in a Single Cube
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Architecture
Speaker: William E Pearson III
Title: Many-to-Many: Multiple Calendars in a Single Cube
Abstract:
Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes' date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson leads an examination into a way we can accomplish this by implementing a SQL Server Analysis Services "many-to-many" dimension scenario.
SessionID: 28168
5 SSIS Tricks to Take You from Beginner to Awesome
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: SSIS
Speaker: Wil Sisney
Title: 5 SSIS Tricks to Take You from Beginner to Awesome
Abstract:
You know how to create a connection manager, and you can extract data to a flat file. So how do you get past basic package creation? This presentation will cover 5 high-level techniques you can use to become the "go-to" person for SSIS in your organization. This session will be packed with demos of packages you can use to achieve SSIS Awesomeness!
SessionID: 28169
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: Professional Development / Azure
Speaker: Wil Sisney
Abstract:
SessionID: 34631
Dynamic MDX: Packing a Punch into One .rdl
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Delivery
Speaker: Erika Bakse
Title: Dynamic MDX: Packing a Punch into One .rdl
Abstract:
Dynamic MDX can be a great way to reuse, reduce, and recycle .rdls and simplify report maintenance. Have a lot of reports that are practically the same, minus a few pesky exceptions? Dynamic MDX could be the answer! In this session we’ll walk through how to create a basic .rdl that can support a variety of MDX queries that will be generated dynamically. We will also discuss the pros and cons of this approach so that you can make an informed decision of when and if Dynamic MDX is the solution for you.
SessionID: 34632
Think Outside the Group! Take MDX to the next leve
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Delivery
Speaker: Erika Bakse
Title: Think Outside the Group! Take MDX to the next leve
Abstract:
SessionID: 9434
Data Cleansing Using the "Scrubbing Bubbles" of SS
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: SSIS
Speaker: Amy Lewis
Title: Data Cleansing Using the "Scrubbing Bubbles" of SS
Abstract:
Got data that is a mess that you have been asked to clean up before loading into your data warehouse? Come learn from this demo packed session the various components and techniques in SSIS for cleaning messy data including removing duplicates, removing unwanted characters and words. Become less "fuzzy" about the cleansing powers of fuzzy grouping and fuzzy lookups.
SessionID: 9485
SQL Considerations for SharePoint 2010 Farms
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Delivery
Speaker: Andrew Thornton-Smith
Title: SQL Considerations for SharePoint 2010 Farms
Abstract:
SharePoint is to be hosted on your SQL farm... Now what?
In this session, we will cover the basic need to know for SQL administrators who are now responsible for SharePoint's DBs.
In our journey, topics we will cover will be, Farm sizing's architecture to considerations for Enterprise Search and considerations for crawling the dreaded G:, H:\ Z:\ drives, To the myriad of SharePoint Databases and which to watch out for.
And finally what tasks in SharePoint are the heavy weights in terms of IOPS, CPU RAM.
SessionID: 9655
Mobile BI with SSRS and SharePoint
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: BI Delivery
Speaker: Angel Abundez
Title: Mobile BI with SSRS and SharePoint
Abstract: