Nr: 91
SQLSaturday #91 - Omaha 2011
SessionID: 29035
Kama Sutra of SSIS: A guide to loving ETL
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence - RM117
Speaker: Bill Fellows
Title: Kama Sutra of SSIS: A guide to loving ETL
Abstract:
Slow running packages? SSIS consuming all your resources? No idea what it's doing?
After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. Additionally, you will be armed with a list of transformations and perfmon counters to
SessionID: 29036
Getting started with CLR for fun and profit
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM120
Speaker: Bill Fellows
Title: Getting started with CLR for fun and profit
Abstract:
This session will provide an overview of the five SQL CLR objects available for SQL Server 2005-2008 and demonstrate how to create, deploy and use these objects for fun and profit.
SessionID: 29188
Best Practices Every SQL Server DBA Must Know
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM118
Speaker: Brad McGehee
Title: Best Practices Every SQL Server DBA Must Know
Abstract:
The focus of this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. This session focuses on key fundamentals, such as: Installing Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation.
SessionID: 29189
Introduction to SQL Trace
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM118
Speaker: Brad McGehee
Title: Introduction to SQL Trace
Abstract:
SessionID: 29908
Virtualizing SQL Server Deep Dive
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM118
Speaker: David Klee
Title: Virtualizing SQL Server Deep Dive
Abstract:
Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and this session will provide a deep dive into how to properly prepare for and implement a successful virtualization campaign for ALL your SQL Server environments.
SessionID: 30025
Seven Benefits of Virtualization
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM118
Speaker: David Welch
Title: Seven Benefits of Virtualization
Abstract:
The time to virtualize your entire datacenter is now. The seven primary benefits of virtualization will be discussed: OpEx reductions from improved manageability, near 100% reliable disaster recoverability, product release cycle optimization, high availability, license optimization and hardware-based software licensing, production error capture, and security considerations. Tier-1 virtualization should be embraced, and virtualization is ready. High availability for the C-level and our observation of the current virtualization trends will also be examined.
SessionID: 30919
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM118
Speaker: Joe Ferry
Abstract:
SessionID: 31314
Top Ten DBA Mistakes
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM119
Speaker: Kevin Kline
Title: Top Ten DBA Mistakes
Abstract:
Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen? There are a short list of mistakes that, if you know of them in advance, will make your life much easier.
SessionID: 31315
End-to-End Troubleshooting
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM119
Speaker: Kevin Kline
Title: End-to-End Troubleshooting
Abstract:
SessionID: 31316
SQL Server Internals Architecture
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM119
Speaker: Kevin Kline
Title: SQL Server Internals Architecture
Abstract:
SessionID: 31756
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM122
Speaker: Mark House
Abstract:
SessionID: 31757
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM119
Speaker: Mark House
Abstract:
SessionID: 31895
Continuous Integration for Databases
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM122
Speaker: Mike Douglas
Title: Continuous Integration for Databases
Abstract:
SessionID: 32201
Data to Dashboards:Back to Basics
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM121
Speaker: Pete Ceplecha
Title: Data to Dashboards:Back to Basics
Abstract:
SessionID: 32212
SSIS in Denali: What's new
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence - RM117
Speaker: Phil Brammer
Title: SSIS in Denali: What's new
Abstract:
SSIS has some drastic changes coming in the next version of SQL Server, code-named "Denali." This session will touch on the major changes and will demonstrate how they are used.
SessionID: 32213
Database Monitoring with Event Notifications
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM120
Speaker: Phil Brammer
Title: Database Monitoring with Event Notifications
Abstract:
Trying to manage many database instances is no easy task. SQL Server Service Broker and Event Notifications are just one way to get near-real time feedback of what is occurring across all instances. This session will demonstrate how Blue Cross and Blue Shield have implemented Event Notifications to monitor database changes, logins, permission changes, log/data file growths, etc...
SessionID: 32385
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM122
Speaker: Randy Knight
Abstract:
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production and how this can be avoided.
SessionID: 32386
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM121
Speaker: Randy Knight
Abstract:
SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
SessionID: 33218
Report Lockdown: Implementing SSRS Security
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence - RM117
Speaker: Steve Hughes
Title: Report Lockdown: Implementing SSRS Security
Abstract:
When working with Reporting Services, you need to consider all aspects of security from access to the report server to filtering the report data. This session will delve into the various techniques used to secure reports throughout the architecture and the nuances of integrating with SharePoint security as well.
SessionID: 33219
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence - RM117
Speaker: Steve Hughes
Abstract:
SessionID: 33220
Using SQL Azure in Application Development
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM121
Speaker: Steve Hughes
Title: Using SQL Azure in Application Development
Abstract:
SessionID: 33261
What's new and exciting in SQL Server 'Denali'
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM121
Speaker: Sudhir Gajre
Title: What's new and exciting in SQL Server 'Denali'
Abstract:
Attend this session to learn the new and exciting things coming the next release of SQL Server codenamed 'Denali'. Denali is just round the corner and bring some amazing improvements in the core engine, HA, DR, BI, and DW space. You do not want to miss this discussion on the new and exciting features of Denali. This session will help you decide on how to leverage the new featurses of Denali.
SessionID: 33403
Parallel Query Execution Deep Dive
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM122
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: 33404
SANs and SQL Server
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM119
Speaker: Kevin Boles
Title: SANs and SQL Server
Abstract:
SessionID: 33408
Fundamentals of Join Operations
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DB Development - RM122
Speaker: Kevin Boles
Title: Fundamentals of Join Operations
Abstract:
This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples.
SessionID: 33409
Common TSQL Mistakes
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM120
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
We are going to examine a variety of oopsies MANY developers fall prey too, some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I have given this talk over a dozen times now and it is always very highly rated!
SessionID: 33581
High-Availability and DR Options for SQL Server
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM120
Speaker: Tim Plas
Title: High-Availability and DR Options for SQL Server
Abstract:
A comparison of SQL HA DR options, by a practitioner who has implemented managed all the SQL HA and DR approaches ( various combinations thereof). Tim is an operational SQL DBA, who keeps SQL servers up running optimized for managed-services customers. We will compare trade-offs between the various SQL HA DR options: for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features.
SessionID: 34695
Denali and T-SQL
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: DBA - RM120
Speaker: Kathi Kellenberger
Title: Denali and T-SQL
Abstract:
Denali has something for everyone: new HA/DR flexibility, an SSIS overhaul, unmatched data warehouse query speeds and much more. Have you heard about all the new T-SQL features and functions that will be delivered with Denali? Attend this session to learn how you will benefit from Microsoft's continued investment in T-SQL!
SessionID: 34696
Women in Technology Panel Discussion
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence - RM117
Speaker: Kathi Kellenberger
Title: Women in Technology Panel Discussion
Abstract:
Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more young women to consider a career in technology? Join Kathi and other dynamic Women in Technology to discuss this important and hot topic. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well.