Nr: 63
SQLSaturday #63 - Dallas 2011
SessionID: 28487
Solid State Storage Deep Dive
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Administrator
Speaker: Wesley Brown
Title: Solid State Storage Deep Dive
Abstract:
SessionID: 28648
Self-Service BI with PowerPivot
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI
Speaker: Anand Pandya
Title: Self-Service BI with PowerPivot
Abstract:
In this session you’ll learn how to use PowerPivot to create self-service BI in your organization. We will learn how to combinie data from heterogenous data sources and then create reports/dashboardsfor end users to consume and collboarate in SharePoint 2010. We will also cover when you should use PowerPivot in comparison with SQl Server Analysis Services (OLAP) so you are equiped to create robust Self Service BI applications in your organization.
SessionID: 28721
Building a Professional Development Plan
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Professional Development
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: 28744
Work past the SQL Connectivity Issues
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Administrator
Speaker: Aparna Vishwamitra
Title: Work past the SQL Connectivity Issues
Abstract:
We will cover some basic and common scenarios of SQL Connectivity issues and how to MS Support troubleshoots and resolves the same
SessionID: 28767
Data Mining in Action: A case study
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI
Speaker: ANDREW MINKIN
Title: Data Mining in Action: A case study
Abstract:
SessionID: 28876
Getting started with Reporting Services
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Beginner
Speaker: Adam Saxton
Title: Getting started with Reporting Services
Abstract:
We will take a look at what needs to be done to get Reporting Services up and running and how the Server actually works. We will also look at what features the different designers provide and how to know which Viewer Control with your application.
SessionID: 29313
Analysis Services Security
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Advanced
Speaker: Bryan Smith
Title: Analysis Services Security
Abstract:
The purpose of this session is to review Analysis Service's security model and explore ways it can be effectively used to deliver complex security requirements. Topics to be addressed include administrative security, dimension data security, cell-data security, and even dynamic security techniques.
SessionID: 29762
T-SQL Programming to Survive a Zombie Database
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Developer
Speaker: David Stein
Title: T-SQL Programming to Survive a Zombie Database
Abstract:
Do you have a Zombie Database? Does your database suffer from roaming hordes of problems like the lack of primary and foreign keys, poor normalization, in place updates and deletes, and an insatiable drive to eat your braaaaaaaaaaaaaains (CPU cycles).
Fear not fellow survivor for in this session, I’ll show you how to fortify your code against zombie infestation. How to deal with the unknown (nulls), how to Restore Order by Joining together in Groups. Flak Jackets are Optional.
SessionID: 29817
What is this cache and why is it so big?
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Advanced
Speaker: Douglas Brendle
Title: What is this cache and why is it so big?
Abstract:
SessionID: 29821
SQL Server FastTrack Data Warehouse
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Futures
Speaker: David Browne
Title: SQL Server FastTrack Data Warehouse
Abstract:
An overview of the FastTrack Data Warehouse Architecture. Learn about the storage design for FastTrack, and data loading an and operational requirements for a FastTrack implementation. When to use FastTrack vs custom storage designs vs Enterprise shared storage for SQL Server Data Warehouse and VLDB applications.
SessionID: 30058
So What Can I Do With PowerShell?
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Beginner
Speaker: Eric Humphrey
Title: So What Can I Do With PowerShell?
Abstract:
SessionID: 30086
Zero to cube in 1 hour
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI
Speaker: Erin Welker
Title: Zero to cube in 1 hour
Abstract:
In this session, we'll walk through the steps for creating a multidimensional schema (star schema) for a subject area we're all familiar with, load the tables we create via SSIS, and build an SSAS cube to facilitate analytical analysis. The session is almost completely demo-driven, and will hopefully inspire you to go home and build your first BI solution to facilitate your own analysis.
SessionID: 30698
Orientation: What is SQL Server,and what's it for?
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Beginner
Speaker: Jennifer McCown
Title: Orientation: What is SQL Server,and what's it for?
Abstract:
SessionID: 30794
Introducing Microsoft's EDIM Products
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Futures
Speaker: Jessica Moss
Title: Introducing Microsoft's EDIM Products
Abstract:
Starting in the SQL Server Denali release, data takes on a new life in the business intelligence world. Often forgotten, data management needs to be an integral part of your reporting systems. Learn how Microsoft has made your life easier by incorporating external parameters, environments, and groupings into Integration Services. They have also included impact analysis and data lineage, which can be tied to tables and SSIS packages. Two additional newcomer products, data quality services and master data services, complete the quartet. This session will use the first Community Technical Preview of SQL Server Denali to describe and demonstrate the enhancements to the four products that make up EDIM.
SessionID: 30795
Adding SSRS Report Bells and Whistles
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI
Speaker: Jessica Moss
Title: Adding SSRS Report Bells and Whistles
Abstract:
Producing a good looking report will wow your business users even if your data isn't all that impressive. If you've ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008 R2. With the knowledge in this session, you won't ever need to show a plain, boring report again!
SessionID: 30999
SQL Server Tips and Tricks
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Beginner
Speaker: John Cook
Title: SQL Server Tips and Tricks
Abstract:
SessionID: 31008
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Advanced
Speaker: Jonathan Clark
Abstract:
SessionID: 32078
Introduction to SQL CLR
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Paul Hunter
Title: Introduction to SQL CLR
Abstract:
Learn how, when and why you may want to incorporate CLR functionality into the database.
SessionID: 32329
SQL Server Denali High Availability
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Futures
Speaker: Prem Mehra
Title: SQL Server Denali High Availability
Abstract:
Please attend to learn and understand next generation high availability and disaster recovery solution architectures from SQL Server. How it will help you in meeting the ever increasing goals to reduce Recovery Point and Recovery Time Options (RPO and RTO) while potentially reducing TCO. To fully benefit from this session it is assumed that you have a basic understanding of the current SQL Server HA/DR functionality.
SessionID: 32473
The BI DBA
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Advanced
Speaker: Randy Dyess
Title: The BI DBA
Abstract:
In this session, you will learn the differences between administering a data warehouse database, or a reporting database, versus a database meant for OLTP operations. This session will cover the basic administration tasks and how they can be different for DBAs working with data warehouse/reporting databases.
SessionID: 32547
ORM's and the ugly truth
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Rob Sullivan
Title: ORM's and the ugly truth
Abstract:
Technologies: I'll be using Entity Framework 4, Linq, MVC2 and a variety of virtual surgical tools.
I ranked this session as beginner with regards to the topic of ORM's. My session makes assumptions you know about execution plans, traces, the optimizer and other non-beginner topics in SQL Server.
SessionID: 32713
Stored procedure tracing using the xml datatype
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Russel Loski
Title: Stored procedure tracing using the xml datatype
Abstract:
When running a stored procedure it is difficult to record what is happening. In this session we will develop logger code in T-SQL to add to your stored procedures. We will use the xml datatype to record parameter values, variable values and debug statements. We will look at the "For xml" statement as well as the xml datatype methods, especially the modify method. Finally we will look at how to read the logs when finished.
SessionID: 32716
SSRS data driven subscription using SSIS
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI
Speaker: Russel Loski
Title: SSRS data driven subscription using SSIS
Abstract:
SessionID: 32735
Mirroring: The Bear Necessities
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Administrator
Speaker: Ryan Adams
Title: Mirroring: The Bear Necessities
Abstract:
SessionID: 32804
How to Master SQL Joins
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Scott Whigham
Title: How to Master SQL Joins
Abstract:
Quick - what’s the difference between LEFT and RIGHT OUTER JOINs? How do you know that a NULL in your result set is from the table data or is the result of the join? If you’ve ever struggled with the ins and outs of joins and join syntax then this presentation is perfect for you. This presentation presents a straight-forward and logical approach to understanding and visualizing joins and focuses heavily on the “how” and “why” of the various join types.
SessionID: 32944
The Modern Resume - Building Your Brand
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Professional Development
Speaker: Steve Jones
Title: The Modern Resume - Building Your Brand
Abstract:
Learn practical ways in this session that you can use to build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral, shares some of the ways in which he has successfully grown his career over the years. Steve will present tips and tricks for using social networking sites, blogging, volunteering, leadership, and more to your advantage. He also has a few resume hints to help you find a great job that fits you.
SessionID: 33133
HELP! I need somebody, HELP me Please!
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Professional Development
Speaker: David Smithey
Title: HELP! I need somebody, HELP me Please!
Abstract:
There are times as a DBA that you need help from other DBA’s, especially if you’re the only DBA around. We will talk about the various ways of getting help (Twitter, SQL Server Central, StackOverflow). We will talk about how to ask for help (and the ways not to).
SessionID: 33141
Whats new in SQL Server Denali
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Futures
Speaker: Sriram Ganapathy
Title: Whats new in SQL Server Denali
Abstract:
SQL Server Denali is the code name for the next major release of SQL Server. This session wil cover the investments in this release specifically focusing on the following areas:
SQL Server AlwaysOn, Column-based Query Accelerator, Unified developer experience, Expanded BI with project crescent and enterprise information management
SessionID: 33187
Turbo charge your DBA career
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Professional Development
Speaker: Sri Sridharan
Title: Turbo charge your DBA career
Abstract:
You have been a DBA for so many years and struggle to decide on what next. Attend this session and find ways to rejuvenate your career to the next step.
SessionID: 33268
Troubleshooting Database availability and recovery
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Advanced
Speaker: Suresh Kandoth
Title: Troubleshooting Database availability and recovery
Abstract:
SessionID: 33330
Parallel Data Warehouse - Architecture Overview
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Futures
Speaker: Ted Tasker
Title: Parallel Data Warehouse - Architecture Overview
Abstract:
This session will overview both the HW and SW architecture of the PDW appliance. It will explain how Microsoft and HP have engineered a solution using commodity HW and SW that can compete with more expensive platforms like TeraData and ExaData. Additionally, SQL DBAs will see where their current skillset is applicable to managing a PDW appliance.
SessionID: 33529
Parallel Query Execution
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Kevin Boles
Title: Parallel Query Execution
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: 33530
SANs and SQL Server
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Administrator
Speaker: Kevin Boles
Title: SANs and SQL Server
Abstract:
SessionID: 33637
Tableau: Delivering Self-Serve BI
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Advanced
Speaker: Tim Costello
Title: Tableau: Delivering Self-Serve BI
Abstract:
SessionID: 33638
Dimensional design 101
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Beginner
Speaker: Tim Costello
Title: Dimensional design 101
Abstract:
SessionID: 33741
An Introduction to Profiler and SQL Trace
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Beginner
Speaker: Trevor Barkhouse
Title: An Introduction to Profiler and SQL Trace
Abstract: