Nr: 96
SQLSaturday #96 - Washington, DC 2011
SessionID: 28385
PowerShell for SQL and New Denali Features
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: SAN/Virtualization/Denali
Speaker: Aaron Nelson
Title: PowerShell for SQL and New Denali Features
Abstract:
This session will cover the new features of PowerShell in SQL Denali. The new module for SQL Server, the new module for SSAS, and the new Replica cmdlets for High Availability databases.
SessionID: 28593
SQL Server XML 101
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Alex Grinberg
Title: SQL Server XML 101
Abstract:
XML processing become more and more a part of our daily life. Today anyone, DBA or Developer, interferes one way or another with XML-based processes. In the SQL Server XML 101 session I'll go over all XML data types from "ground zero" to advanced tricks and tips. Using real life examples I'll show most efficient ways to work with an XML of any complexity and size. I'll cover the problems that you can anticipate to deal with with XML. How to: load the files using T-SQL code, dynamically retrieve and element or attribute, use different XML data types' methods and functions.
SessionID: 28598
Windows Failover Clustering Basics for the DBA
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Allan Hirt
Title: Windows Failover Clustering Basics for the DBA
Abstract:
While you can see how to run through Wizards deploy a failover cluster in 60 minutes in other places, what a DBA really needs is a solid foundation of Windows to truly be able to understand that implementation and its subsequent administration. This session will demystify the Windows layer of clustering and present it from a DBA focus. Using Windows Server 2008 R2, some of the topics that will be shown are: failover cluster validation and its impact on installing SQL Server, a tour of the new Failover Cluster Manager and how it can be used for administration, using the new cluster logs for troubleshooting, and more.
SessionID: 28694
Designing an SSIS Framework
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: BI
Speaker: Andy Leonard
Title: Designing an SSIS Framework
Abstract:
SessionID: 28877
Understanding Indexes
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA/Dev
Speaker: Ashton Hobbs
Title: Understanding Indexes
Abstract:
This session will focus on the internals of index and how they are structured at a physical level. Understanding how indexes are structured can then help understand how they can help improve query performance by reducing lookups, serving as a covering index, etc. The session will use DBCC Page/Ind to look at how different types of indexes are structured and make some suggestions on the best way to structure tables, keys, and indexes to get the best performance from them. Will also cover index options that can affect how indexes are structured and how Index Rebuild/Reorg work at the physical level.
SessionID: 28878
Understanding (B)locking
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA/Dev
Speaker: Ashton Hobbs
Title: Understanding (B)locking
Abstract:
SessionID: 29271
Leadership Coaching: A repeatable methodology...
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Prof. Dev.
Speaker: Brian Moran
Title: Leadership Coaching: A repeatable methodology...
Abstract:
SessionID: 29515
How to get Hired in the first 10 minutes
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Prof. Dev.
Speaker: Chris Skorlinski
Title: How to get Hired in the first 10 minutes
Abstract:
Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. We’ll cover key strategies you can use during the interviews first 10 minutes to increase chances for a new job and new adventure.
SessionID: 29516
Transactional Replication – Follow the Data
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Chris Skorlinski
Title: Transactional Replication – Follow the Data
Abstract:
Okay, you’ve run the Wizard and have Replication up and running; but how does it really work? Learn the behind the scenes for Transactional Replication as we follow the data from Publisher to Subscriber. We’ll look at both design and troubleshooting techniques to ensure your data is moving at near-real-time through your topology.
SessionID: 29824
Getting Spatial with SQL Server 2008
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA/Dev
Speaker: Dan Clark
Title: Getting Spatial with SQL Server 2008
Abstract:
SessionID: 29899
Thwarting Database Defects
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Prof. Dev.
Speaker: Dennis Lloyd Jr
Title: Thwarting Database Defects
Abstract:
It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. This presentation introduces tSQLt, a framework for automated database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain.
SessionID: 30218
Intro to Ranking and Aggregate Window Functions
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Dev
Speaker: Geoff Johnson
Title: Intro to Ranking and Aggregate Window Functions
Abstract:
Window functions greatly simplify the syntax and efficiency of queries that mix scalar with aggregate values. Learn how to add aggregate values to a query result without a GROUP BY clause, how to add row numbers and ranking values to query results, and how to subdivide a set of results evenly into a given number of parts.
SessionID: 30219
Intro to Common Table Expressions
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Dev
Speaker: Geoff Johnson
Title: Intro to Common Table Expressions
Abstract:
Common Table Expressions (CTEs) serve two main functions: first they remove the clutter of subqueries out of the FROM clause while simultaneously making them easy to reference multiple times by alias if need be, and second they make it possible to do recursive queries. Learn the basics of using CTEs to streamline T-SQL code and to query self-referential tables.
SessionID: 30392
(SSIS, TSQL and MDS) - Record Linkage Fuzzy Match
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: BI
Speaker: Ira Warren
Title: (SSIS, TSQL and MDS) - Record Linkage Fuzzy Match
Abstract:
We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). There are many facets to review. I would like to start by drawing concepts from several articles from experienced practitioners, either from academia or the commercial market. They will be footnoted at the end of the session. Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms
SessionID: 30415
Automating Database Source Control
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA/Dev
Speaker: James Gaines
Title: Automating Database Source Control
Abstract:
Track source code changes and manage the synchronization between the source control system and your database. Using SQL Source Control and your favorite source control system, this task can be automated, and you can catch those sneaky developers making changes they forgot to tell you to source.
SessionID: 30416
An intro to Oracle Databases for SQL Server DBAs
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Prof. Dev.
Speaker: James Gaines
Title: An intro to Oracle Databases for SQL Server DBAs
Abstract:
An overview of basic database architecture and operations such as startup, shutdown, backup, redo log, alert log, tablespaces, etc. for SQL Server database professionals. This will provide a broad look at Oracle 11g from a DBA perspective. This session will give you a basic understanding of the terminology and command structure used in daily operations. It is not that complicated, come and see for yourself.
SessionID: 30642
SAN Basics for DBAs
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: SAN/Virtualization/Denali
Speaker: Joseph D'Antoni
Title: SAN Basics for DBAs
Abstract:
SessionID: 30644
Virtualization for SQL DBAs
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: SAN/Virtualization/Denali
Speaker: Joseph D'Antoni
Title: Virtualization for SQL DBAs
Abstract:
Want to know about VMWare and what it means for your databases? This session will go through the hardware and terminology around this technology. Learn how to optimize your SQL Servers for VMs and what to tell your storage engineers.
SessionID: 30772
Build Your SQL Server Career
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Prof. Dev.
Speaker: Jeremy Kadlec
Title: Build Your SQL Server Career
Abstract:
Do you have the needed skills for your SQL Server career? Whether you are looking to land your first job or advance into a managerial position, this session will offer recommendations to you. From interview tips to skills all employers are looking for in SQL Server professionals, this session will benefit you.
SessionID: 30791
How to Increase Development Productivity in SSRS
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: BI
Speaker: Jessica Moss
Title: How to Increase Development Productivity in SSRS
Abstract:
Using SQL Server 2008 R2 Reporting Services and Report Builder 3.0, report writers can store, re-use, and modify pieces of reports using "report parts". Report parts are stored on the report server and are provided to others for collaboration in a report part library to increase initial development productivity and decrease maintenance turn-around time. This presentation will describe how to set up a user-friendly and easily maintained report part library by discussing how to create report parts, how to store them on the report server, and how to import them into a new report.
SessionID: 31199
Model-Driven Database Design
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Dev
Speaker: Karen Lopez
Title: Model-Driven Database Design
Abstract:
Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as "Who does what?", "Why are we doing this?", "Do I have to Use a GUI?" and "Just who do you think you are?". Finally, 10 tips for making model-driven database development successful in your organization's culture and environment.
SessionID: 31366
Change Data Capture in SQL Server 2008
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA/Dev
Speaker: Kevin Goff
Title: Change Data Capture in SQL Server 2008
Abstract:
SessionID: 31372
What's new in Denali - a whirlwind tour
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: SAN/Virtualization/Denali
Speaker: Kevin Goff
Title: What's new in Denali - a whirlwind tour
Abstract:
Have you ever gotten whiplash as you twist your head in fifty directions, trying to research all the new features in a product? In this session, I'll go through all the new features in SQL Server Denali. I won't focus excessively on any one feature - instead, I'll go through as many new features in SQL Server Denali as time permits.
SessionID: 31763
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Dev
Speaker: Mark Hudson
Abstract:
Whether predicting customers, All Stars or concert set lists, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It's easier than you might have thought.
SessionID: 31764
Introduction to Analysis Services
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: BI
Speaker: Mark Hudson
Title: Introduction to Analysis Services
Abstract:
SessionID: 32108
PowerShell: A Tale of Two Checklists
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: SAN/Virtualization/Denali
Speaker: Brian Garraty
Title: PowerShell: A Tale of Two Checklists
Abstract:
It was the worst of times. It was the age of foolishness. I had a long-winded, manual, GUI-intensive checklist for configuring new SQL Server installations. Automating that checklist with PowerShell and SMO ushered in the best of times and an age of wisdom. In this session, we will walk through my new automated checklist, make the case for using PowerShell for such tasks, and point those still mired in the winter of despair and manual drudgery towards the spring of hope that is scripting and automation.
SessionID: 32142
Mining XML Query Plans
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Sebastian Meine
Title: Mining XML Query Plans
Abstract:
SessionID: 32774
Developing Date and Role-Playing Dimensions
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: BI
Speaker: Sandra Mueller
Title: Developing Date and Role-Playing Dimensions
Abstract:
SessionID: 32775
Data Files and Transaction Logs – Beyond the GUIs
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Sandra Mueller
Title: Data Files and Transaction Logs – Beyond the GUIs
Abstract:
SessionID: 32878
Join operations - Explaining Merge,Hash and Loop
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Dev
Speaker: Luke Jian
Title: Join operations - Explaining Merge,Hash and Loop
Abstract:
In this session we’ll look in depth at the three main types of join operations (Nested Loops, Hash and Merge) in order to understand how query plans are computed. We will look at the performance of Hash and Merge joins in different scenarios and explain why they are sometimes associated with poor performing queries.
SessionID: 32879
Optimizing SQL Server I/O with Solid State Drives
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Luke Jian
Title: Optimizing SQL Server I/O with Solid State Drives
Abstract:
Optimal configuration and maintenance of the I/O subsystem is critical and can ultimately be responsible for higher response times of your applications. The HDDs are by design about 1 million times slower than the memory or CPU. In this session we analyze the different options that exist for durable storage, what are their pros and cons . Solid state drives are a viable option and we are going under the covers to see how you can best use them as an alternative to a large and expensive SAN in your infrastructure
SessionID: 33054
Monitoring Databases in a Virtual Environment
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: SAN/Virtualization/Denali
Speaker: Thomas LaRock
Title: Monitoring Databases in a Virtual Environment
Abstract:
SessionID: 33869
Banish RBAR!
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Dev
Speaker: Wayne Sheffield
Title: Banish RBAR!
Abstract:
SessionID: 33870
Table Vars Temp Tables - What you NEED to Know!
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: DBA/Dev
Speaker: Wayne Sheffield
Title: Table Vars Temp Tables - What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 34024
An Overview of PowerPivot
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: BI
Speaker: William E Pearson III
Title: An Overview of PowerPivot
Abstract:
In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. We then provide a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …”
SessionID: 34031
Entity Strategies: Structuring Your Consultancy
Event Date: 05-11-2011 - Session time: 00:00:00 - Track: Prof. Dev.
Speaker: William E Pearson III
Title: Entity Strategies: Structuring Your Consultancy
Abstract: