Nr: 85
SQLSaturday #85 - Orlando 2011
SessionID: 28527
Analysis - 0 to PowerPivot
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: Adam Jorgensen
Title: Analysis - 0 to PowerPivot
Abstract:
In this session, the attehdees will learn how to drive and build a PowerPivot solution and reports as they rotate through the podium as volunteers.
SessionID: 28704
Building a Professional Development Plan
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Misc
Speaker: Andy Warren
Title: Building a Professional Development Plan
Abstract:
A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.
SessionID: 29033
Advancing Data Storage for Databases
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: Chris Wolfley
Title: Advancing Data Storage for Databases
Abstract:
Nimble Storage, launched by the co-founders of NetApp and Data Domain, has built a purpose-built storage architecture that integrates flash memory and high-capacity disk for the first time, combining primary storage, backup, replication, and disaster recovery in a single "converged" solution. Join this informative session where you will review the evolution of data storage and protection, learn about Nimble Storage's breakthrough solution for SQL Server environments, and review real-world case studies that demonstrate its performance and reliability.
SessionID: 29068
0 to SSRS Presentation
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: David Liebman
Title: 0 to SSRS Presentation
Abstract:
In this presentation I will show you how to create a simple report and deploy the report to the Report Server using SQL Server Business Intelligence Development Studio(BIDS).
SessionID: 29096
Reporting Services Deep Dive
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: Brian K McDonald
Title: Reporting Services Deep Dive
Abstract:
SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. ** This session is SQL Saturday favorite and is always packed full. Don't miss it **
SessionID: 29135
Page Row Compression Deep Dive
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Bradley Ball
Title: Page Row Compression Deep Dive
Abstract:
Page and Row Compression are powerful new tools. Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. We can turn it on, we can turn it off, but we want more! What are Access Methods and how in the SQL Engine do they affect Compression? What are the “Gotchas” of Page Compression? How does Compression differ in the way it treats Non-Leaf Leaf Level pages? What additional functionality did we get in DBCC Page, DMV’s, Perfmon Counters, and Extended Events to support our usage of Compression? How do complex query plans affect Compression? Come find out!
SessionID: 29321
Introduction to SSIS
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: SSIS
Speaker: Bradley Schacht
Title: Introduction to SSIS
Abstract:
In this session we will help get you past the learning curve of SSIS. We will cover the basics of the development environment, the control flow and data flow. We will show you how to create an end to end package to demonstrate best practices and illustrate design concepts. This is a great session for anyone who is new to SSIS.
SessionID: 29322
Dynamic SSIS: Configs, Expressions and Variables
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: SSIS
Speaker: Bradley Schacht
Title: Dynamic SSIS: Configs, Expressions and Variables
Abstract:
SessionID: 29355
From Ground to Cloud for Databases
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Buck Woody
Title: From Ground to Cloud for Databases
Abstract:
SessionID: 29576
Storing PowerShell Output
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Misc
Speaker: Chad Miller
Title: Storing PowerShell Output
Abstract:
You’ve run PowerShell scripts and need to store the output . In this session we’ll look at sending Powershell output to text, CSV, HTML, Excel, and SQL Server data sources.
SessionID: 29628
Upgrade Roadmap: Taking YOU to R2
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Craig Purnell
Title: Upgrade Roadmap: Taking YOU to R2
Abstract:
A Review of the upgrade process to SQL Server 2008 R2. A checklist of considerations for things a company would likely encounter coming from SQL Server 2000 or 2005. The Pros and Cons of in-place upgrades vs. the Build-out-new approach. There will also be some lessons learned sprinkled in as the presenter has personally led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor. Enterprise interfaces and stuff you will see in the real world, deprecated features and how to test for them
SessionID: 29699
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Daniel Taylor
Abstract:
SessionID: 29921
Data Sharding in OLTP Systems
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Dmitri Korotkevitch
Title: Data Sharding in OLTP Systems
Abstract:
This session demonstrates several data sharding techniques that can be used to partition the data across multiple database servers focusing on the task of separating production and historical data in OLTP systems
SessionID: 29946
The Fundamentals of DBA-ism
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Don Stevic
Title: The Fundamentals of DBA-ism
Abstract:
When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”. As much as it frustrated me, he was right. There is a core set of knowledge that DBA. Correct SQL installation and configuration, how’s and whys of backups, how to make your role proactive, and many other things fall under that heading. This session is for the “freshly minted” DBA to help them find and define their own set of best practices.
SessionID: 30076
You’re My Density: Making Sense of Statistics
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Erin Stellato
Title: You’re My Density: Making Sense of Statistics
Abstract:
The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge.
SessionID: 30139
SSIS Data Flow Buffer Breakdown
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: SSIS
Speaker: Eric Wisdahl
Title: SSIS Data Flow Buffer Breakdown
Abstract:
SessionID: 30152
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Eddie Wuerch
Abstract:
SessionID: 30300
Introduction to Execution Plan
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Nathan Heaivilin
Title: Introduction to Execution Plan
Abstract:
Every wonder what the database engine does when you run a proc? Want to know what is causing the procedure or sql statement to run really slow? This session with provide you with a start to understanding both of these.
SessionID: 30328
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Herve Roggero
Abstract:
SessionID: 30459
Sql Server On VMware???
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Janis Griffin
Title: Sql Server On VMware???
Abstract:
More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
SessionID: 30460
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Janis Griffin
Abstract:
SessionID: 30662
Rewriting Bad Code
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: Jeffrey Garbus
Title: Rewriting Bad Code
Abstract:
SessionID: 30867
SSIShare The Code Man
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: SSIS
Speaker: James McAuliffe
Title: SSIShare The Code Man
Abstract:
For many SSIS scenarios, a desired outcome is to implement logic or rules that are used in existing enterprise applications, only to do so in an a bulk data loading scenario. Many times the logic being applied is complex and multi-step. We will examine various scenarios where complex logic from shared code sources can be applied in SSIS processing scenarios.
1 How to use code from shared enterprise sources
2. How to implement external code in script component
3. How to implement external code in sql CLR
4. Performance comparison.
SessionID: 31041
Policy-Based Management in a Nutshell
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Misc
Speaker: Jorge Segarra
Title: Policy-Based Management in a Nutshell
Abstract:
We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Server environment using this awesome new feature!
SessionID: 31056
Mission Possible: Pervasive BI
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: Bob Abernethy
Title: Mission Possible: Pervasive BI
Abstract:
Making Business Intelligence pervasive throughout an organization has proven to be the “Holy Grail” for many companies – recognized as of immense value but also difficult to attain. In this session we will take a look at the definition, benefits, obstacles, and requirements of Pervasive BI, as well as techniques and technologies which have made SQL Server-based Pervasive BI a “Mission Possible” for many organizations. We will then take a look at a case study of a large internal corporate deployment of Pervasive BI built on SQL Server Analysis Services.
SessionID: 31277
Working With XML In SQL Server
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Kendal Van Dyke
Title: Working With XML In SQL Server
Abstract:
SessionID: 31480
SSRS Subscriptions
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: Kyle Walker
Title: SSRS Subscriptions
Abstract:
Join Kyle's session on SSRS subscriptions! In this session, you will get a chance to see some real world subscription requests and how to implement them. Some requests, which are common across a lot of businesses, fall outside of the functionality of Reporting Services so this session will also require some knowledge of SSIS.
SessionID: 31637
Extend your T-SQL Scripting with PowerShell
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Misc
Speaker: Maximo Trinidad
Title: Extend your T-SQL Scripting with PowerShell
Abstract:
I’ll be covering some of the different way we can use PowerShell to extend our T-SQL scripting. This session will include a mix of using SMO, .NET classes, and SQLPS to help you understand the power for new scripting technology. At the end we’ll be creating a solution that put together all this techniques.
SessionID: 31654
Using Script Task and Components in SSIS
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: SSIS
Speaker: Mike Davis
Title: Using Script Task and Components in SSIS
Abstract:
SessionID: 31655
SQL Smackdown SSIS vs T-SQL
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: SSIS
Speaker: Mike Davis
Title: SQL Smackdown SSIS vs T-SQL
Abstract:
In this session, you’ll learn how to load a Data Warehouse using SQL Server Integration Services (SSIS) and T-SQL. You'll see a battle between two database experts (Mike Davis and Luis E Figueroa), attempting to load the data warehouse in the fastest, simplest, and most reliable way. You'll see side-by-side solutions developed in each language. In the end you decide which works best for you and who wins the SQL Smackdown.
SessionID: 31777
Rapidly Deploying SQL Server with PowerShell
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Misc
Speaker: Michael Wells
Title: Rapidly Deploying SQL Server with PowerShell
Abstract:
As much as you love SQL Server, do you cringe anytime you hear that you’ll need to stand up yet another SQL Server instance? Sure it’s fun, but who has the time? Maybe you’ve thought there must be a better way of doing this? Sure, you have the ability to generate an unattended install file, but what about all the other things that will need to be done? In this talk, we will explore a process that was created to truly automate not just the SQL Server install, but all of the configurations and the deployment of your organizations standard objects, all using a set of PowerShell scripts that you can download and use today. This session will review the process that has saved hundreds of hours for one organization and can do the same for yours.
SessionID: 31808
Introduction to PowerPivot for Excel
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: Michael Antonovich
Title: Introduction to PowerPivot for Excel
Abstract:
This session focuses on the basics of how to use PowerPivot with Excel to create simple pivot tables (cubes) and pivot charts using both data already in Excel as well as how to connect to SQL tables as your data source. It will also cover how add slicers, how to add calculated columns and how to define hierarchies in your pivot tables.
SessionID: 32097
Data Conversions: Steps, Tips and Best Practices
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Norm Bowen
Title: Data Conversions: Steps, Tips and Best Practices
Abstract:
SessionID: 32155
Where to with NoSql
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: patrick thompson
Title: Where to with NoSql
Abstract:
The session will look at ways that the Sql and NoSql worlds can fit together. It will cover some of the major NoSql offerings such as Cassandra, MongoDb and Hadoop, and present some idea on how Sql fits with these non-Sql stores. It will particularly emphasize hadoop and some of the problems and opportunities offered by mixing hadoop and sql.
SessionID: 32247
T-SQL Enhancements in Denali
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Plamen Ratchev
Title: T-SQL Enhancements in Denali
Abstract:
Take a look in the future of SQL Server and experience the new T-SQL features in SQL Server 11 (code named Denali). This session is a deep dive into the new OFFSET option for paging, error handling improvements with THROW, sequences, enhancements to EXECUTE for results sets, and new features to describe query and procedures result sets and parameters. You will see practical code demos describing the use cases for these T-SQL extensions.
SessionID: 32541
Loading a Data Warehouse with SSIS
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: Robert Biddle
Title: Loading a Data Warehouse with SSIS
Abstract:
SessionID: 32551
PowerPivot: BI Massive Data Analysis for Humans
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: Rob Collie
Title: PowerPivot: BI Massive Data Analysis for Humans
Abstract:
The paradox of Business Intelligence: it's one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow? In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience ( range of applications). The only prereqs: curiosity, and fondness for numbers :) I will explain how PowerPivot impacts benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q's as you can muster :)
SessionID: 32587
Revenge: The SQL!
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Rob Volk
Title: Revenge: The SQL!
Abstract:
Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance!
SessionID: 32626
T-SQL Alphabet Soup
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Rodney Landrum
Title: T-SQL Alphabet Soup
Abstract:
Come see the quick brown fox jump over the lazy dog in creative T-SQL coding ways and possibly learn a few obscure commands you were not familiar with. This session will show 26 unique quries using T-SQL keywords that start with every letter of the alphabet.
SessionID: 32644
Powershell by Example
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Misc
Speaker: Ronald Dameron
Title: Powershell by Example
Abstract:
SessionID: 32648
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: Phillip E Rosen
Abstract:
I will demonstrate how to develop MS Excel BI Dashboards in the following ways:
- Workbook style with Office data connections stored on local PC or networked document drive
- excel services style using Reports Library SP 2007 for storage of the Office data connections workbook that excel services will render
- Convert excel pivot table into excel OLAP formulas
- Discuss SP 2010 BI Center
- Discuss references to cap off session.
SessionID: 32684
Reporting in Silverlight
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Russell Fustino
Title: Reporting in Silverlight
Abstract:
Join Russ Fustino as he takes a tour of the new ActiveReports 6 Silverlight Report Viewer. Now all the power of reporting the award winning ActiveReports for Windows and ASP.NET, is now available in Silverlight!
He will show how this component is designed for reporting in Microsoft Silverlight 4 and higher. See how the Silverlight Report Viewer is simple, lightweight, flexible, localizable, and easy to customize for quick end user deployment. It includes these features:
?Preview reports loaded from a file, document stream, ASPX page, RPX Handler, or WCF service.
?End-user toolbar with Table of Contents (TOC), Thumbnails, Print, Search, Zoom, and Navigation buttons, plus you can add your own custom buttons.
*And More!
SessionID: 33389
Transaction Log Deep Dive
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Kevin Boles
Title: Transaction Log Deep Dive
Abstract:
Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine.
SessionID: 33391
Parallel Query Execution Deep Dive
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Kevin Boles
Title: Parallel Query Execution Deep Dive
Abstract:
What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.
SessionID: 34069
Becoming DAX: An Introduction ...
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 1
Speaker: William E Pearson III
Title: Becoming DAX: An Introduction ...
Abstract:
SessionID: 34075
Getting Started with MDX
Event Date: 24-09-2011 - Session time: 00:00:00 - Track: BI 2
Speaker: William E Pearson III
Title: Getting Started with MDX
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.