Nr: 21
SQLSaturday #21 - Orlando 2009
SessionID: 28505
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSAS (V111A)
Speaker: Adam Jorgensen
Abstract:
SessionID: 28662
Database Design
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Design (V101)
Speaker: Andy Leonard
Title: Database Design
Abstract:
Based on the popular Example of Test-Driven Development series at SQL Server Central, this session focuses on Database Development as part of the Application Lifecycle Management (ALM) process. Examples demonstrate how to test, but the session focuses on the benefits of testing database scripts. T-SQL error trapping, database projects, test artifacts, and source control are also discussed.
SessionID: 29082
Introduction to SQL Server Analysis Services
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSAS (V111A)
Speaker: Brian Knight
Title: Introduction to SQL Server Analysis Services
Abstract:
SessionID: 29083
Introduction to MDX
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSAS (V111A)
Speaker: Brian Knight
Title: Introduction to MDX
Abstract:
The MDX query language is one of the toughest and most powerful languages in your arsenal as a business intelligence developer. In this session, you’ll start from the ground-up learning how to create a basic MDX statement and then quickly how do you solve complex business problems with this well-structured language.
SessionID: 29095
It’s All About the Requirements - MINI
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administration (V006)
Speaker: Bob Blaydes
Title: It’s All About the Requirements - MINI
Abstract:
Requirements elicitation is often where success in a Business Intelligence (BI) deployment lives or dies.
In this Mini session we will take a quick look at how business process driven requirements can mean the difference between standard reporting and true BI.
SessionID: 29276
Introduction To Reporting Services 2008
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSRS (V107)
Speaker: Brian McDonald
Title: Introduction To Reporting Services 2008
Abstract:
Reporting Services Rocks! If you haven't seen it yet, this is one you will not want to miss. In this session, I will introduce the audience to Reporting Services 2008. An overview of the new and improved architecture will be given. Demo's will show how to create a report using the built in wizard and from scratch with a blank report canvas. I will also show the user how to deploy the report for general usage.
SessionID: 29342
T-SQL - English Requests to SQL Queries
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 2 (V105)
Speaker: Brandie Tarvin
Title: T-SQL - English Requests to SQL Queries
Abstract:
Beginning T-SQL, part 1. The things every DBA needs to know to translate a user request into a workable Select statement.
SessionID: 29343
T-SQL - Subqueries and Joins
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 2 (V105)
Speaker: Brandie Tarvin
Title: T-SQL - Subqueries and Joins
Abstract:
Beginning T-SQL part 2. This session builds on the lessons of "English Requests to SQL Query", teaching beginners how to filter their result sets with some of the most common T-SQL constructs.
SessionID: 29352
SQL Server Resource Governor
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administration (V006)
Speaker: Buck Woody
Title: 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 overview of its functionality and flow.
SessionID: 29528
SSIS and Slowly Changing Dimensions
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSIS (J105)
Speaker: Christian Loris
Title: SSIS and Slowly Changing Dimensions
Abstract:
An explanation of Slowly Chaning DImensions in a data model and how SSIS can help you maintain them.
SessionID: 29869
Tuna Helper - Proven Process for Tuning SQL
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 1 (J108)
Speaker: Dean Richards
Title: Tuna Helper - Proven Process for Tuning SQL
Abstract:
SessionID: 30119
SSIS - A Beginning Framework Part 1
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSIS (J105)
Speaker: Eric Wisdahl
Title: SSIS - A Beginning Framework Part 1
Abstract:
Most developers would agree that every SSIS solution will have the same fundamental outline. A basic framework will expedite the process by handling the common tasks between the systems while allowing the developer to concentrate on the task at hand. This framework will consist of many items, including but not limited to setting up package configurations, logging, audit trails, error handling, naming standards, etc. This session will present an example framework which can be used as the basis for future SSIS Package development.
SessionID: 30120
SSIS - A Beginning Framework Part 2
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSIS (J105)
Speaker: Eric Wisdahl
Title: SSIS - A Beginning Framework Part 2
Abstract:
Most developers would agree that every SSIS solution will have the same fundamental outline. A basic framework will expedite the process by handling the common tasks between the systems while allowing the developer to concentrate on the task at hand. This framework will consist of many items, including but not limited to setting up package configurations, logging, audit trails, error handling, naming standards, etc. This session will present an example framework which can be used as the basis for future SSIS Package development.
SessionID: 30407
SQL 101 - MINI
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 1 (J108)
Speaker: Delbert James
Title: SQL 101 - MINI
Abstract:
An introduction to the SQL for a beginner. The session will cover the basic DML (Data Manipulation Language) statements = INSERT, SELECT, UPDATE, and DELETE. This will be a demo driven session.
SessionID: 30584
Celko on SQL
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Performance (V003)
Speaker: Joe Celko
Title: Celko on SQL
Abstract:
This is a placeholder, final topic description coming soon!
SessionID: 30677
Catalog Views and the Art of Template Creation
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Design (V101)
Speaker: Jonathon Moorman
Title: Catalog Views and the Art of Template Creation
Abstract:
A look at the Sql Server catalog views to understand the contents of your database. From there we'll utilize the catalog views to generate templates that help uncover potential issues within our database. We will also use the catalog views to create useable templates and enforce local T-SQL coding standards.
SessionID: 30837
Database change management using Team System 2008
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 2 (V105)
Speaker: Jim Blizzard
Title: Database change management using Team System 2008
Abstract:
Ever make a bunch of changes to your database then lose track of what you’ve changed? Frustrated with trying to come up with consistent, “meaningful” test data to test your applications? Wish you could unit test your database? Ever forget to make a backup copy of your stored procedure before you made that one line change (that happens to crash the system)? Tired of feeling like you’re not part of the team? We’ll take a look at how Team System can help ease the pain of database development and change management.
SessionID: 30878
Auditing User Activity 101
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Security (J107)
Speaker: Jonathan Kehayias
Title: Auditing User Activity 101
Abstract:
Auditing user activity in SQL Server has become a hot topic lately. From SOX and PCI to HIPPA, the security of personal data, and the ability to track who accessed the data and how has become extremely important. In this session, SQL Server MVP Jonathan Kehayias covers the various methods available in SQL Server 2000, 2005, and 2008 to accomplish this task including SQL Trace in SQL Server 2000 and 2005, and the new Server Audits in SQL Server 2008.
SessionID: 30879
Wait Statistics: A Troubleshooting Methodology
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 2 (V105)
Speaker: Jonathan Kehayias
Title: Wait Statistics: A Troubleshooting Methodology
Abstract:
SessionID: 30914
Creating Data-Driven Subscriptions in SSRS
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSRS (V107)
Speaker: Joe Webb
Title: Creating Data-Driven Subscriptions in SSRS
Abstract:
SessionID: 30915
Locking Blocking Made Simple
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Performance (V003)
Speaker: Joe Webb
Title: Locking Blocking Made Simple
Abstract:
SessionID: 30922
Encrypting SSIS Connection String - MINI
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Design (V101)
Speaker: John O'Shea
Title: Encrypting SSIS Connection String - MINI
Abstract:
When storing SSIS connection strings using SQL accounts in a database, how do you keep the passwords secure? One method is to encrypt the column in the table SSIS Configurations are stored in present that table to your users as a view with built-in logic to either show or obscure the password data based on their role. This session will take you through a complete solution, including code to encrypt or not based on whether a password is present.
SessionID: 31012
Twitter and SQL: A Perfect UNION MINI
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 2 (V105)
Speaker: Jorge Segarra
Title: Twitter and SQL: A Perfect UNION MINI
Abstract:
SessionID: 31253
Configuring SQL Access for the Web Developer
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Security (J107)
Speaker: Kendal Van Dyke
Title: Configuring SQL Access for the Web Developer
Abstract:
- Learn when to use SQL logins and when to use Windows Authentication
- Understand the concept of impersonation
- Learn how ASP and ASP.NET applications can be configured to use impersonation to make secure connections to SQL Server
- Learn how to configure IIS 5, 6, 7 and Windows XP, 2003, and 2008 to support impersonation
SessionID: 31254
Getting started in blogging and technical speaking
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Security (J107)
Speaker: Kendal Van Dyke
Title: Getting started in blogging and technical speaking
Abstract:
Are you thinking of starting a blog? Or are you interested in presenting at events like SQL Saturday but not sure what to do to get started? This panel style session, featuring SQL bloggers Andy Warren, Jack Corbett, and Kendal Van Dyke, will give you tips on bloging platforms, choosing topics, techniques for giving presentations, and sage advice from years of experience.
SessionID: 31256
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Performance (V003)
Speaker: Kendal Van Dyke
Abstract:
SessionID: 31257
Demo of Red Gate SQL Backup (MINI)
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Security (J107)
Speaker: Kendal Van Dyke
Title: Demo of Red Gate SQL Backup (MINI)
Abstract:
SessionID: 31302
End to End Troubleshooting
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administration (V006)
Speaker: Kevin Kline
Title: End to End Troubleshooting
Abstract:
SessionID: 31404
No Better Time to Start Your Own Tech Business!
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Security (J107)
Speaker: Kathy Malone
Title: No Better Time to Start Your Own Tech Business!
Abstract:
There may never have been a better time since the start of the Internet to launch that technology business you've always wanted! With Microsoft having the largest product launch in its history between now and next April, plus awesome Microsoft support tools for startups, students, and partners, you have no excuse not to! Whether you are thinking part or full time, software, SaaS, S+S, consulting, hosting, or any other variation, there is something new on the horizon to help your new business take off! Come hear about the free tools Microsoft is making available, hear about "gotchas" you need to think about as you go forward, and hear about different business models. Focus is on building a business sustainably.
SessionID: 31667
Dynamic SSIS Packages
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSIS (J105)
Speaker: Mike Davis
Title: Dynamic SSIS Packages
Abstract:
Learn how to make your SSIS packages dynamic, by using Configuration Files, Configuration Tables, Parent to Child Package Relationships. You will see how to use variables and expression together in all areas of a package and understand how to update multiple packages with a single change without having to redeploy packages multiple times.
SessionID: 31803
Identifying and Removing Duplicate Records
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 1 (J108)
Speaker: Michael Antonovich
Title: Identifying and Removing Duplicate Records
Abstract:
Perhaps you inherited a database with one or more tables having duplicate potential keys or maybe even entire duplicate records or maybe you generated a recordset from a SELECT statement that has duplicate records. In any case, you have a problem. You need to identify which tables have duplicate records or duplicate index values, isolate those records, and then delete only the duplicate records from the table. This session will focus on the functions and methods that you can use to identify and remove duplicate data from your tables
SessionID: 31964
SQL 2008 DataMining
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSAS (V111A)
Speaker: Michael Mollenhour
Title: SQL 2008 DataMining
Abstract:
In this session I will demonstrate datamining with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine, and show how these can be integrated with Reporting Services and Excel.This session will mainly focus on new features available for SQL 2008
SessionID: 32154
Sql and the Cloud
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Design (V101)
Speaker: patrick thompson
Title: Sql and the Cloud
Abstract:
This talk will look at the implications of cloud computing for Sql databases. Topics covered will include: What’s in the cloud, data processing or both? Running Sql in the cloud. Sql alternatives in the cloud, SimpleDB, DIY indexing. Stuff that definitely won’t work in the cloud (not at the moment anyway). The talk will be focused mostly on the use of Amazon’s S3, SimpleDB and EC2 with a bit of Rackspace Mosso thrown in. It will demo setting up S3 buckets and EC2 instances. What’s involved in getting Sql Server running on them (including licensing implications) and discuss some of the speaker’s experience in working with the Amazon environment.
SessionID: 32281
Using the CLR to Monitor Disk Space
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 1 (J108)
Speaker: Patrick LeBlanc
Title: Using the CLR to Monitor Disk Space
Abstract:
In this session I will demonstrate how to use a couple of CLR Stored Procedures and the SQL Server Agent to monitor disk space in an Enterprise with several SQL Servers.
SessionID: 32349
Tips Tricks for dynamic Reporting Services Repor
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSRS (V107)
Speaker: Pam Shaw
Title: Tips Tricks for dynamic Reporting Services Repor
Abstract:
SessionID: 32617
Taking Control of SQL Server Error Logs
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administration (V006)
Speaker: Rodney Landrum
Title: Taking Control of SQL Server Error Logs
Abstract:
The SQL Server Error Logs contain vital information for the day to day DBA. For 1 to 10 servers, reviewing the error logs can be an enlightening experience done manually. For 200+ servers it is more than a chore and automating the consolidation and analysis of the error log contents is essential to be a successful DBA. From failed login attemtps to data corruption, this session will show you how to maintain error log history, raise errors in code that will write to the error log and most importantly, centralize and report on specific errors across multiple servers. The solution will use several different technologies including SSIS and the MERGE statement, new to SQL Server 2008.
SessionID: 32637
Database Hardening - Standardization, Optimization
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Performance (V003)
Speaker: Ronald Dameron
Title: Database Hardening - Standardization, Optimization
Abstract:
Database Hardening - Standardization, Optimization, and Automation. I will cover how I handle these issues in a very large environment that has over 500 database servers and 3600 databases. My talk will touch on my use of PowerShell, Policy Based Management, the Enterprise Policy Management Framework, and an internally development DBA utility database to manage this inventory.
SessionID: 32834
Introduction to SQL XML
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSAS (V111A)
Speaker: Scott Klein
Title: Introduction to SQL XML
Abstract:
TBA
SessionID: 33365
SQL Server 2008 - Beyond Relational
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 1 (J108)
Speaker: Telmo Sampaio
Title: SQL Server 2008 - Beyond Relational
Abstract:
Learn about the new features in SQL Server 2008 that support non-structured and semi-structured data. You will learn about filestreams, sparse columns, hierarchy ids, and geo spatial data and be exposed to these technologies with comprehensive demos of each as well as technical insight on when and how to use them. This session is based on a real project and how it took advantages of the new technology in SQL 2008 compared to its first version in SQL 2005.
SessionID: 33486
SANs and SQL Server
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administration (V006)
Speaker: Kevin Boles
Title: SANs and SQL Server
Abstract:
SessionID: 33758
Backup Basics MINI
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Performance (V003)
Speaker: Todd Holmes
Title: Backup Basics MINI
Abstract:
This session will review recovery models, backup types and restore procedures.
SessionID: 33802
Database Partitioning, The Basics
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Design (V101)
Speaker: Elijah Baker
Title: Database Partitioning, The Basics
Abstract:
SessionID: 34484
Building a Data Warehouse using SQL Server 2008
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSAS (V111A)
Speaker: Wes Dumey
Title: Building a Data Warehouse using SQL Server 2008
Abstract:
SessionID: 34932
Social and Not so Social Networking for the DBA
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSRS (V107)
Speaker: Andy Warren
Title: Social and Not so Social Networking for the DBA
Abstract:
Should you be networking? In this session we'll talk about why you should be building a network now, how to build it, and how to keep track of and quantify your network. Along the way we'll talk about the most common social networks, why you should consider blogging, and some exercises you can do to strengthen your networking skills.
SessionID: 35059
SQL Server PowerShell Extensions
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 2 (V105)
Speaker: Chad Miller
Title: SQL Server PowerShell Extensions
Abstract:
SessionID: 35062
Dive into the Default Trace
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSRS (V107)
Speaker: Jack Corbett
Title: Dive into the Default Trace
Abstract:
SessionID: 35070
Automating Routine Maintenance
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administration (V006)
Speaker: Ken Simmons
Title: Automating Routine Maintenance
Abstract:
In order to sustain a SQL Server instance that provides optimum performance, it requires constant maintenance. Luckily, you can use the same tools within SQL Server to automate maintenance tasks that you use to meet the business needs of the organization. This session will cover the tasks you need to perform in order to maintain a healthy instance of SQL Server as well as the tools you can use to automate them.
SessionID: 35100
Database design of Highly Loaded OLTP systems
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Design (V101)
Speaker: Dmitri Korotkevitch
Title: Database design of Highly Loaded OLTP systems
Abstract:
The session shows some tips and tricks useful for the database design of the highly loaded OLTP systems.
SessionID: 35133
Introduction to Execution Plan
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Security (J107)
Speaker: Nathan Heaivilin
Title: Introduction to Execution Plan
Abstract:
An introductory session on the different types of execution plans, how to generate each of them, the pro's and cons of each of them, and how to read an execution plan.
SessionID: 35137
Deep Dive in SQL Server Encryption
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Security (J107)
Speaker: Herve Roggero
Title: Deep Dive in SQL Server Encryption
Abstract:
This presentation will focus on SQL Server security, specifically focusing on encryption. We will first take a tour of different encryption methods including hashing and encryption then move into specific examples on how to implement encryption at different levels. Parts of this presentation will include C# code.
SessionID: 35177
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Performance (V003)
Speaker: Jeffrey Garbus
Abstract:
Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
SessionID: 35178
Indexing for Join Optimization
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Performance (V003)
Speaker: Jeffrey Garbus
Title: Indexing for Join Optimization
Abstract:
Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections
SessionID: 35209
Cloud Computing: SQL Azure and Beyond
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Design (V101)
Speaker: Joe Homnick
Title: Cloud Computing: SQL Azure and Beyond
Abstract:
SessionID: 35234
Policy Based Management 101
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administration (V006)
Speaker: Jorge Segarra
Title: Policy Based Management 101
Abstract:
We will be learning an overview of this powerful new feature in SQL 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers!
SessionID: 35286
Introduction to SSIS Part 1
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSIS (J105)
Speaker: Devin Knight
Title: Introduction to SSIS Part 1
Abstract:
This is part 1 of a session that will get you past the learning curve of SSIS. Devin will cover the basics of the development environment that is used to build SSIS packages. He will show how to create an end to end package that covers many of the concepts in SSIS. This session will be great for anyone who is a beginner to SSIS.
SessionID: 35287
Introduction to SSIS Part 2
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: SSIS (J105)
Speaker: Devin Knight
Title: Introduction to SSIS Part 2
Abstract:
This is part 2 of a session that will get you past the learning curve of SSIS. Devin will cover additional beginner level SSIS topics. You will learn the basics of using variables/expressions and different deployment techniques. This session will be great for anyone who is a beginner to SSIS.
SessionID: 35290
RESTful Data
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 1 (J108)
Speaker: Chris Eargle
Title: RESTful Data
Abstract:
REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With ADO.NET Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE. This session will describe RESTful Data, the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly.
SessionID: 35300
PowerShell and SQL Server (More SMO)
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 2 (V105)
Speaker: Maximo Trinidad
Title: PowerShell and SQL Server (More SMO)
Abstract:
SessionID: 35311
SQL Server 2008 Spatial Data
Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Development 1 (J108)
Speaker: Michael Stark
Title: SQL Server 2008 Spatial Data
Abstract:
A walkthru of the Geometry and Geography Data Types in SQL Server 2008. Demonstration will include Geographic points and shapes. After discussing the features in SQL Server there will be a demonstration of using Virtual Earth to display the data from SQL Server interactively.