sqlsathistory

Nr: 63

Back to Main list

SQLSaturday #63 - Dallas 2011

Start Time (24h) Speaker Track Title
00:00:00 Wesley Brown Administrator Solid State Storage Deep Dive
00:00:00 Anand Pandya BI Self-Service BI with PowerPivot
00:00:00 Andy Warren Professional Development Building a Professional Development Plan
00:00:00 Aparna Vishwamitra Administrator Work past the SQL Connectivity Issues
00:00:00 ANDREW MINKIN BI Data Mining in Action: A case study
00:00:00 Adam Saxton Beginner Getting started with Reporting Services
00:00:00 Bryan Smith Advanced Analysis Services Security
00:00:00 David Stein Developer T-SQL Programming to Survive a Zombie Database
00:00:00 Douglas Brendle Advanced What is this cache and why is it so big?
00:00:00 David Browne Futures SQL Server FastTrack Data Warehouse
00:00:00 Eric Humphrey Beginner So What Can I Do With PowerShell?
00:00:00 Erin Welker BI Zero to cube in 1 hour
00:00:00 Jennifer McCown Beginner Orientation: What is SQL Server,and what's it for?
00:00:00 Jessica Moss Futures Introducing Microsoft's EDIM Products
00:00:00 Jessica Moss BI Adding SSRS Report Bells and Whistles
00:00:00 John Cook Beginner SQL Server Tips and Tricks
00:00:00 Jonathan Clark Advanced An Intro to Replication Meta-Data
00:00:00 Paul Hunter Developer Introduction to SQL CLR
00:00:00 Prem Mehra Futures SQL Server Denali High Availability
00:00:00 Randy Dyess Advanced The BI DBA
00:00:00 Rob Sullivan Developer ORM's and the ugly truth
00:00:00 Russel Loski Developer Stored procedure tracing using the xml datatype
00:00:00 Russel Loski BI SSRS data driven subscription using SSIS
00:00:00 Ryan Adams Administrator Mirroring: The Bear Necessities
00:00:00 Scott Whigham Developer How to Master SQL Joins
00:00:00 Steve Jones Professional Development The Modern Resume - Building Your Brand
00:00:00 David Smithey Professional Development HELP! I need somebody, HELP me Please!
00:00:00 Sriram Ganapathy Futures Whats new in SQL Server Denali
00:00:00 Sri Sridharan Professional Development Turbo charge your DBA career
00:00:00 Suresh Kandoth Advanced Troubleshooting Database availability and recovery
00:00:00 Ted Tasker Futures Parallel Data Warehouse - Architecture Overview
00:00:00 Kevin Boles Developer Parallel Query Execution
00:00:00 Kevin Boles Administrator SANs and SQL Server
00:00:00 Tim Costello Advanced Tableau: Delivering Self-Serve BI
00:00:00 Tim Costello Beginner Dimensional design 101
00:00:00 Trevor Barkhouse Beginner An Introduction to Profiler and SQL Trace

SessionID: 28487

Solid State Storage Deep Dive

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Administrator

Speaker: Wesley Brown

Title: Solid State Storage Deep Dive

Abstract:

If you have ever wanted to know how SSD's and Flash memory works this talk is for you. We will cover the fundamentals of Flash in detail. I will also highlight some of the specific vendor implementations and what makes a particular SSD "enterprise ready" vs "Consumer grade". We will also cover SQL Server usage patterns what is a good fit for SSD's and when it may be better to go with hard disks. Solid State Storage isn't a cure-all for every situation, this presentation will give you the tools you need to make the right choice for your SQL Server environment.

SessionID: 28648

Self-Service BI with PowerPivot

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI

Speaker: ANDREW MINKIN

Title: Data Mining in Action: A case study

Abstract:

This session will introduce techniques of integrating algorithm output with production data. Example code and lab will use data sets beyond Adventureworks.Topics include: Applying multiple models Developing a scorecarding system Assessing the most effective model Track population stability and algorithm performance over time.

SessionID: 28876

Getting started with Reporting Services

Back to calendar

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

Back to calendar

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

Back to calendar

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?

Back to calendar

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:

Ever wonder what's in your SQL Plan cache? Wonder why or how it got so big? This session will cover what it is, how it's used, how it can affect performance and how poor application and query design can make it worse. Rather than put participants to sleep with a slide deck we will get down and dirty with lots of demos.

SessionID: 29821

SQL Server FastTrack Data Warehouse

Back to calendar

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?

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Beginner

Speaker: Eric Humphrey

Title: So What Can I Do With PowerShell?

Abstract:

Want to automatically store your database schema in a version control system (VCS)? Want to make changes across your database or server with less labor? Want to compress your backups using 7zip and PowerShell. Figure out memory allocation on an active/active cluster? How about download many files in the background? Come learn what is possible with PowerShell.

SessionID: 30086

Zero to cube in 1 hour

Back to calendar

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?

Back to calendar

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:

What is SQL Server? It's just software. What is SQL Server for? At its simplest, it lets you store data safely, and get it back out again. Is there a right way to say "SQL"? Yes, actually! In this session we will work with the tools to show you around SQL Server, and explore what it can do. If you're looking to get into databases, this is your session.

SessionID: 30794

Introducing Microsoft's EDIM Products

Back to calendar

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

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI

Speaker: Jessica Moss

Title: Adding SSRS Report Bells and Whistles

Abstract:

SessionID: 30999

SQL Server Tips and Tricks

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Beginner

Speaker: John Cook

Title: SQL Server Tips and Tricks

Abstract:

Learn tips and tricks to make more effective use of SSMS. Use portable applications to get your work done without installing applications on a server. Use free tools to simplify your life.

SessionID: 31008

An Intro to Replication Meta-Data

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Advanced

Speaker: Jonathan Clark

Title: An Intro to Replication Meta-Data

Abstract:

We will cover some basics about setting up simple replication tests and dive into what happens to the underlying meta-data when changes are replicated. A good opporunity to see a demonstration style explanation of what goes on 'under the hood' during replication. Scripts will be provided.

SessionID: 32078

Introduction to SQL CLR

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Developer

Speaker: Rob Sullivan

Title: ORM's and the ugly truth

Abstract:

In this session, we are going to take a surgical approach to why I as a DBA fear ugly ORM's. Even though you can use views and stored procs as plastic surgery for an ugly case of ORM, there is only so much you can do if it is ugly on the inside. Slides generally bore me, so we will only be looking at a couple before we put on our scrubs and hit the OR(M) to perform an uglyectomy to create an ORM we can live with.

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

Back to calendar

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

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI

Speaker: Russel Loski

Title: SSRS data driven subscription using SSIS

Abstract:

SQL Server Reporting Services provides a powerful tool to render report based on information in a database table. But in order to use this feature, you are required to purchase an Enterprise license of SQL Server. In this session, we will create an SSIS package that renders reports based on the results of a query.

SessionID: 32735

Mirroring: The Bear Necessities

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Administrator

Speaker: Ryan Adams

Title: Mirroring: The Bear Necessities

Abstract:

Mirroring can be an integral part of your high availability and disaster recovery planning. We’ll cover what mirroring is, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to not only give you an overview of mirroring, but to also walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it.

SessionID: 32804

How to Master SQL Joins

Back to calendar

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

Back to calendar

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!

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Advanced

Speaker: Suresh Kandoth

Title: Troubleshooting Database availability and recovery

Abstract:

Troubleshooting Database availability and recovery problems: Do you want to become proficient in troubleshooting some of the common database availability problems? Do you want to know what are the common causes of these problems? Do you want to understand some of the internals of how SQL Server generates these errors? Come and listen to this talk from Microsoft CSS team on how they troubleshoot and resolve these problems first hand. You can also learn about all the tools you need to keep ready when you need to use them for a disaster recovery situation. We will also cover best practices to avoid encountering these type of situations.

SessionID: 33330

Parallel Data Warehouse - Architecture Overview

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Futures

Speaker: Ted Tasker

Title: Parallel Data Warehouse - Architecture Overview

Abstract:

In Nov.2010, Microsoft officially released SQL Server 2008 R2 PDW Edition. Parallel Data Warehouse is a true MPP (massive parallel processing) platform featuring an ultra shared nothing architecture. PDW is capable of delivering very fast query performance and can house up to 500 TB of data.

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

Back to calendar

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

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Administrator

Speaker: Kevin Boles

Title: SANs and SQL Server

Abstract:

Simple title says it all. Lets get down and dirty on some fundamentals and then numerous details of how SANs work and how we can best utilize and tune them to improve SQL Server's IO performance and reliability.

SessionID: 33637

Tableau: Delivering Self-Serve BI

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Advanced

Speaker: Tim Costello

Title: Tableau: Delivering Self-Serve BI

Abstract:

rapid-fire visual analysis. ad hoc query capability. easy interactive dashboard building. No, this insn't going to be an hour of buzzword bingo. This time we will actually deliver on the promise of self service BI. Using SQL in conjunction with a visual analysis tool like Tableau we can help our users find the questions they didn't know they wanted to answer. This session will be demo heavy and will highlight best practices in data visualization and dashboard design.

SessionID: 33638

Dimensional design 101

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Beginner

Speaker: Tim Costello

Title: Dimensional design 101

Abstract:

In this session we'll cover all the pieces of a classic Kimball style data mart (Star schema, fact tables, dimension tables). We'll talk about the data warehouse bus architecture and how it can be used to quickly create data marts with conformed dimensions. We'll talk about what it means to have conformed dimensions and why it's important.

SessionID: 33741

An Introduction to Profiler and SQL Trace

Back to calendar

Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Beginner

Speaker: Trevor Barkhouse

Title: An Introduction to Profiler and SQL Trace

Abstract:

Profiler (and its underlying subsystem, SQL Trace) is a tool for recording a SQL Server instance's activity. This diagnostic and performance data is valuable for troubleshooting and characterizing a system's workload. Like any powerful tool, misuse can be quite harmful, so great care must be exercised. This session will teach you how to efficiently configure, run, and analyze the data from traces, while minimizing the overhead of the data collection and avoiding common pitfalls.