Nr: 97
SQLSaturday #97 - Austin 2011
SessionID: 28503
Central Management Server - Fundamentals
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: AJ Mendo
Title: Central Management Server - Fundamentals
Abstract:
We'll cover the basics of setting up your CMS, including: "What you need to consider when planning your CMS", "How to find SQL Servers in your environment", "How to get the servers you find into CMS" and "How CMS can help you proactively manage your environment".
SessionID: 29555
Data Orchestration with System Center + SQL
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Charles Joy
Title: Data Orchestration with System Center + SQL
Abstract:
This session will explore various options for data and process management leveraging System Center Orchestrator, System Center Service Manager, PowerShell, SQL 2008 R2, SSRS, as well as other Microsoft offerings. One of the demonstrations will highlight an existing production infrastructure where managed data is remotely collected from various sources (Hyper-V, Windows Host OS, Storage, Network, and Security, even Guest Virtual Machine SQL databases), stored in SQL 2008 R2, reported via SSRS, and presented via an intranet SharePoint portal.
SessionID: 29593
New Features in Denali: Apollo Columnar Data Store
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: BI
Speaker: Conor Cunningham
Title: New Features in Denali: Apollo Columnar Data Store
Abstract:
One of the most talked about features slated for the next release of SQL Server, a whole new way of storing data, speeding up some queries ten fold. Come listen to Conor Cunningham talk about this new feature.
SessionID: 29756
SSIS Done Right With Package Configurations
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Bonus
Speaker: David Stein
Title: SSIS Done Right With Package Configurations
Abstract:
Everyone starts creating SSIS Packages the same way. We hard code connection strings, file locations, etc. Package Configurations are a powerful way to control your packages at run time. This allows you to seamlessly move packages between servers, dynamically assign data sources and destinations, cycle through data sources, and create reusable code.
In this presentation, I’ll demonstrate an easy to understand three step process which you can use with all of your packages to increase your productivity in SSIS.
SessionID: 29757
Data Warehouse Mistakes You Can’t Afford to Make
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: BI
Speaker: David Stein
Title: Data Warehouse Mistakes You Can’t Afford to Make
Abstract:
Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them.
SessionID: 30089
Zero to cube in 1 hour
Event Date: 01-10-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: 30578
Advanced Table Constraints
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Bonus
Speaker: Joe Celko
Title: Advanced Table Constraints
Abstract:
The goal of Good SQL is to avoid procedural. The more taht can be put into declarative code, the better the optimizer can do its job. This will cover the use of CASE expressions, overlapping UNIQUE constraints, state transition constraints, and Kusnetsov's temporal constraints.
SessionID: 30579
Nested Sets model for Trees in SQL
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Joe Celko
Title: Nested Sets model for Trees in SQL
Abstract:
Start with the basic method for modeling a hierarchy with sets instead of mimicking pointer chains. Then we will get to some fancier tricks with the model. Finally, spend some time on data integrity.
SessionID: 30711
Code Sins
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Jennifer McCown
Title: Code Sins
Abstract:
It’s impossible to follow every best practice all the time. “Code sins” are those things we do to our code that are either so horrendous that they can’t be borne, or that have such tremendous consequences that your stored procedures wish they’d never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.
SessionID: 30713
T-SQL Brush-up:The Best Things You Forgot You Knew
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Bonus
Speaker: Jennifer McCown
Title: T-SQL Brush-up:The Best Things You Forgot You Knew
Abstract:
You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool, and that FOR XML isn’t as scary as it looks. This session is chock full of code examples.
SessionID: 30838
Denali AlwaysOn - Finally, A usable 'mirror'!
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Jim Murphy
Title: Denali AlwaysOn - Finally, A usable 'mirror'!
Abstract:
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. Denali AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic ConnectionString fail-over using a real web app to see how well that feature works.
SessionID: 31004
Adventures in Project Management
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Bonus
Speaker: Jonathan Gardner
Title: Adventures in Project Management
Abstract:
Join Jonathan Gardner in a discussion about the project management process and how understanding the process can help increase the chances of delivering a top quality work product. Learn the questions to ask to prevent scope creep and manage stakeholders from a DBA and highly experience project manager.
SessionID: 31165
Visual Studio 2010 SQL 2008 Database Projects
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Justin Mason
Title: Visual Studio 2010 SQL 2008 Database Projects
Abstract:
How many change scripts does it take to upgrade your database? How do you keep those scripts in-synch from version to version?
I will be covering the new approach Microsoft has provided through the Visual Studio Database Project and how this can simplify development and deployment for the multiple environments in an enterprise. I'll show you how to set up a database project and create a TFS build that automates the deployment to any target environment.
SessionID: 31652
Nuts and Bolts of Table Compression
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Mike Byrd
Title: Nuts and Bolts of Table Compression
Abstract:
Objective of session is to show with examples when and what and how and if to implement table compression. Session will review table compression as implemented for SQL Server and then dive into many examples including benchmarking. Come to the session to see the results -- they were surprising to me!
SessionID: 31755
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Bonus
Speaker: Mike Hotek
Abstract:
SessionID: 32045
Managing SQL Server in the Enterprise with TLAs
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Nancy Hidy Wilson
Title: Managing SQL Server in the Enterprise with TLAs
Abstract:
Technologists are overwhelmed with TLAs (Three-Letter Acronyms) in their everyday life. This session will introduce several SQL Server 2008 and 2008 R2 features designed to make a DBA’s life easier. If you aren’t using CMS, PBM, EPM, MDW, UCP or DAC – come learn what they are and the potential benefits for managing your environment.
SessionID: 32476
Virtualization and Consolidation best practices
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Bonus
Speaker: Reinaldo Kibel
Title: Virtualization and Consolidation best practices
Abstract:
In this session you will learn from one of the largest deployments of Microsoft SQL Server with over 5000 servers. Join the experts from Dell Services to learn how, when, and what to do when faced with the question “what is the best virtualization solution to save money on database infrastructure?” Virtualization is knocking on every ones door, including DBAs. Recent economic challenges have forced us all to do more with less.
You will learn how we managed our internal consolidation efforts. We will cover the best practices for configuring the database engine, Analysis Services and Reporting Services. We also touch on the best practices on virtualization, consolidation and achieving up to 100 to 1 reduction in SQL Servers.
SessionID: 32607
Expand your TSQL: Intersect, Except, and Apply
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Roudy Rodarte
Title: Expand your TSQL: Intersect, Except, and Apply
Abstract:
SessionID: 32685
Architecting no downtime databases.
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Russell Johnson
Title: Architecting no downtime databases.
Abstract:
Do you have a highly visible online application where you cannot sustain a database outage? How do you handle the planned outages needed for basic maintenance such as patching? In this session I will share some methods utilizing SQL Server features to provide 100% up-time. We will also discuss issues with using clusters as part of an uptime strategy. Finally we will spend some time discussing how Denali can help improve this up-time by utilizing “Always On” features.
SessionID: 32688
SSRS data driven subscription using SSIS
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: BI
Speaker: Russel Loski
Title: SSRS data driven subscription using SSIS
Abstract:
SessionID: 32741
Mirroring: The Bare Necessities
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Ryan Adams
Title: Mirroring: The Bare Necessities
Abstract:
SessionID: 32858
The Backup Tune-up
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Sean McCown
Title: The Backup Tune-up
Abstract:
Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups.
SessionID: 32921
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: BI
Speaker: Sid Atkinson
Abstract:
This session will go into details on how to configure a performance monitoring environment, how to gather data and then interpret results into actionable steps, allowing attendees to answer these questions. Assumes some experience with Analysis Services and MDX
SessionID: 33055
SQL Server Memory Management
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Thomas LaRock
Title: SQL Server Memory Management
Abstract:
SessionID: 33236
SQL Server Amnesia
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: Steven Ormrod
Title: SQL Server Amnesia
Abstract:
When I started as a DBA I didn't know much about SQL Server internals. I inheirited quite a few servers and they were experiencing performance problems. Over time I learned more about the internals and how to troubleshoot systems. I'll share some stories with you and talk about some of the methods I use to look at how SQL Server is using its memory. Then we'll look at some examples and demo code.
SessionID: 33604
It is TEMPDB, Why Should You Care?
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Tim Radney
Title: It is TEMPDB, Why Should You Care?
Abstract:
TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.
SessionID: 33627
Pro Tips: Tuning the data flow in ssis
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: BI
Speaker: Tim Costello
Title: Pro Tips: Tuning the data flow in ssis
Abstract:
SessionID: 33683
Data File Sizes – How much is enough, if you don’t
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 2
Speaker: TJay Belt
Title: Data File Sizes – How much is enough, if you don’t
Abstract:
SessionID: 33744
An Introduction to Profiler and SQL Trace
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: DBA 1
Speaker: Trevor Barkhouse
Title: An Introduction to Profiler and SQL Trace
Abstract:
SessionID: 33819
Introduction to Common Table Expressions
Event Date: 01-10-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Vicky Harp
Title: Introduction to Common Table Expressions
Abstract:
Introduced in SQL 2005, Common Table Expressions, or CTEs, are temporary result sets that offer increased flexibility in your T-SQL coding and provide a simple syntax for recusive queries. In this session for intermediate T-SQL coders, learn how to use CTEs to improve the readability and maintainability of your most complex queries.