Nr: 26
SQLSaturday #26 - Redmond 2009
SessionID: 28613
Failover Clustering with Windows Server 2008
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Allan Hirt
Title: Failover Clustering with Windows Server 2008
Abstract:
Forget a good portion of everything you know about clustering - Windows Server 2008 changes the game. Come see how the changes and improvements affect clustered SQL Server deployments. In addition to Windows, both SQL Server 2005 and SQL Server 2008 will also be discussed. The focus will be on SQL Server 2008 and how its changes to the setup, upgrade, and patching processes (among other things) impact the configuration and administration of a clustered SQL Server 2008 instance. Live demos will be shown, and one copy of Allan’s new book, Pro SQL Server 2008 Failover Clustering, will be given away.
SessionID: 28758
SQL Server Full Text Searching - An Introduction
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: Robert Cain
Title: SQL Server Full Text Searching - An Introduction
Abstract:
Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it's as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server.
SessionID: 28759
Introduction to SQL Server Integration Services
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: Robert Cain
Title: Introduction to SQL Server Integration Services
Abstract:
SessionID: 28760
Introduction to Data Warehousing / BI
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: Robert Cain
Title: Introduction to Data Warehousing / BI
Abstract:
SessionID: 28863
Simple Solutions for Vexing T-SQL Problems
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: Arnie Rowland
Title: Simple Solutions for Vexing T-SQL Problems
Abstract:
Several problems that many folks encounter in their daily work, problems that are often difficult to conceptualize, will be discussed and then Arnie will demonstrate how to find a simple solution.
SessionID: 29962
PowerShell for the Data Professional
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Don Watters
Title: PowerShell for the Data Professional
Abstract:
SessionID: 31169
DBA Basic Checklist
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Kalen Delaney
Title: DBA Basic Checklist
Abstract:
Are you new to managing database systems, or are you wondering if you’re covering all of the bases? Come hear Buck Woody, Microsoft’s “Real World DBA” explain a basic checklist for SQL Server, and what each element means. You’ll also see a few examples of how to implement it, and how you can modify it to fit your installation. Part of our “DBA 101” series.
SessionID: 32486
Asynchronous T-SQL processing
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: Remus Rusanu
Title: Asynchronous T-SQL processing
Abstract:
Many times an application needs to launch into execution a T-SQL script, but it is not interested in waiting until the script is finished. Traditionally such a task would be accomplished using a SQL Agent job. I will present an approach that leverages SQL Service Broker Activation mechanism and go over the advantages and disadvantages of this alternative.
SessionID: 32557
Exploring SQL 2008’s Transparent Data Encryption
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Rob Garrison
Title: Exploring SQL 2008’s Transparent Data Encryption
Abstract:
On the surface, Transparent Data Encryption seems to be a security “silver bullet”. The most important feature (besides securing the data) is that it does not require any changes to your application code.
This session will explain the basics of TDE and show detailed performance test results. You will leave with an understanding of what it takes to implement TDE and what the cost will likely be. This is a very valuable new feature that you should know about.
SessionID: 32558
Exploring SQL Server Column-Level Encryption
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Rob Garrison
Title: Exploring SQL Server Column-Level Encryption
Abstract:
SQL Server 2005 and 2008 support column-level data encryption in many ways. We will start with some of the basics and quickly move to how to use Encrypt/DecryptByKey and ByCert.
This session will include significant information that is not available in Books Online. It will also discuss Message Authentication Codes and how to use them to support efficient searches of encrypted data.
SessionID: 32608
Database Mirroring: Maximizing Availability Throug
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: Robert Davis
Title: Database Mirroring: Maximizing Availability Throug
Abstract:
Database Mirroring is often thought of as a “set and forget it” technology. But what happens if there are problems and the one person on your team that knows mirroring inside and out is not there? You can have a prolonged outage or you can be prepared ahead of time and set up automation procedures for all of your database mirroring needs.
This session will cover setting up processes to detect problems with database mirroring and setting up processes to automate the maintenance and disaster recovery tasks for database mirroring. Included in the session will be detecting a single database failure and automatically failing over all mirrored databases in response.
SessionID: 32609
Using SQL Trace/Profiler Effectively:
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: Robert Davis
Title: Using SQL Trace/Profiler Effectively:
Abstract:
This session will cover how to use SQL Trace/Profiler effectively. Topics include converting trace templates into T-SQL scripts, running server side traces (and why you should do so), reading trace files via T-SQL. Demo will include creating a SQL job that detects high CPU utilization and starts and stops a custom SQL trace when CPU utilization crosses a predefined threshold.
SessionID: 32902
BI Dashboards in Sql Reporting Services
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: Shalu Goel
Title: BI Dashboards in Sql Reporting Services
Abstract:
SessionID: 34975
Hacking SQL / SQL Injection
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: Arnie Rowland
Title: Hacking SQL / SQL Injection
Abstract:
SessionID: 35049
The SQL Server Resource Governor
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Buck Woody
Title: The SQL Server Resource Governor
Abstract:
SQL Server 2008 introduces a new feature called the "Resource Governor". It allows you to set limits (both minimum and maximum) on your SQL Server Instance's use of CPU and Memory - helping to prevent runaway queries, shoring up your Service Level Agreements, and aiding in consolidating your SQL Server databases onto fewer Instances or even in Virtualization. Come hear Buck Woody, Microsoft's "Real World DBA", present an introduction to this feature, and show you an overiew of it's functionality and flow.
SessionID: 35131
T-SQL Best Practices
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: Greg Larsen
Title: T-SQL Best Practices
Abstract:
This session will cover T-SQL coding best practices. The basics on how to code T-SQL statements to optimize your queries will be covered. In this session you will discover some of the common pitfalls that can cause T-SQL statements to run slow. A number of demos will be done to show how by making slight changes in your code will minimize the resources used to process your queries. From this session you will be able to take home a list of T-SQL coding guidelines to help your code more efficient T-SQL statements.
SessionID: 35410
Table Partitioning Scenarios
Event Date: 03-10-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: Ron Talmage
Title: Table Partitioning Scenarios
Abstract:
This session will cover various scenarios for implementing table partitioning, along with anlysis of pro's and con's for each. We will start with a brief review of table partitioning basics.