Nr: 10
SQLSaturday #10 - Tampa 2009
SessionID: 34918
Data Scrambling
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Andreas Etelkozi
Title: Data Scrambling
Abstract:
Data Scrambling is aimed to assist DBA-s to represent schema, data volume and characteristics of data without divulging PII and other real data. Data scrambling provides a realistic data environment for demonstration, training or testing purposes. This presentation will give an understanding of the levels, problems and possible solutions of Data Scrambling, together with a practical demonstration.
SessionID: 34945
SQL Server Statistics
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Andy Warren
Title: SQL Server Statistics
Abstract:
This is a beginner to intermediate level session that will show you how and why statistics are created, how the impact query plans, how to maintain statistics, and what to do when statistics works against you due to uneven data distribution.
SessionID: 34957
Reporting Services 2008 Unleashed!
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 6
Speaker: Arie Jones
Title: Reporting Services 2008 Unleashed!
Abstract:
With the release of SQL Server 2008 this year Microsoft also releases its flagship reporting system piece, SQL Server Reporting Services, with more of the oh so delightful reporting features we have been craving. Come see some of the new features and interacting with some of the web services to allow you to take your reporting services skills to the next level!
SessionID: 34962
CLR within SQL Server 2008
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: Arie Jones
Title: CLR within SQL Server 2008
Abstract:
Running .NET code within SQL Server 2008 has been a major controversy in the past couple of years. Do you allow it or not? What are the implications? Does this mean that the .NET developers can run amok in my database?! Don’t miss out on a golden opportunity to implement this within your infrastructure because you simply don’t know the answers! This session will go over everything that you need to know in order to implement SQLCLR code within your database environment as well as showing you how to create your own user-defined functions, types, and aggregates. Along the way, I will show you some tips and tricks that will ensure you have a successful implementation.
SessionID: 34995
Introduction to SSAS
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 5
Speaker: Brian Knight
Title: Introduction to SSAS
Abstract:
Learn how to use Analysis Services 2008 to better analyze and visual your data. In this session, Brian will introduce you quickly to data warehousing and then dive quickly in SSAS and how to present your data as cubes.
SessionID: 34996
SSIS for DBAs
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 4
Speaker: Brian Knight
Title: SSIS for DBAs
Abstract:
In this session, you'll see common ways that DBAs can use SSIS to make their lives easier. In one example, Brian shows how to gather common metrics from your servers using SSIS and in another example, you'll see how to create an archiving solution for your backups.
SessionID: 35055
SQL Compact Data Sync
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: Nikita Polyakov
Title: SQL Compact Data Sync
Abstract:
SQL Compact Data Sync. Windows Mobile and beyond to a laptop or server near you.
Come find out why SQL Compact and Sunc Services are your ticket to quick and easy local data cache.
SessionID: 35060
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 5
Speaker: Chad Miller
Abstract:
SessionID: 35065
ASP.NET Databinding 101
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 6
Speaker: Chris Rock
Title: ASP.NET Databinding 101
Abstract:
This session will show the attendee how easy it is to quickly display your data on a web page with a minimum amount of code. We will cover displaying, editing, deleting and inserting data.
SessionID: 35077
Transact SQL Frequently Asked Questions
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Kent Waldrop
Title: Transact SQL Frequently Asked Questions
Abstract:
MVP Kent Waldrop takes a quick tour of a few of the SQL issues that come up frequently in the MSDN Transact SQL forum. Some of the topics covered include set oriented processing, pitfalls of user defined functions, working with string lists, filtering by date and time and more.
SessionID: 35079
SQL Server Data Access Tips and Techniques
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: David Hayden
Title: SQL Server Data Access Tips and Techniques
Abstract:
You have optimized and tuned your SQL Server Database and now you need to access the data from your application. Learn and explore the variety of ways you can access the data using the Data Access Application Block, LINQ To SQL, ADO.NET Entity Framework, ADO.NET Data Services, Subsonic, and the ASP.NET 3.5 Dynamic Data Framework. In this session we will walk-thru and build several examples for each technique as well as discuss tips, strengths, and weaknesses. Come with your questions and explore the wonderful world of data access to SQL Server!
SessionID: 35095
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: Dean Richards
Abstract:
SessionID: 35114
SSIS: Configurations, Expressions and Constraints
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 4
Speaker: Eric Wisdahl
Title: SSIS: Configurations, Expressions and Constraints
Abstract:
This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. A short tutorial will show the users how to build up a package structure to allow logging to a remote location determined through configurations as well as capturing errors, destroying the error file if no errors are present and emailing a configurable user if any errors are found.
SessionID: 35144
Using Visual Studio Database Edition GDR-RTM
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: James McAuliffe
Title: Using Visual Studio Database Edition GDR-RTM
Abstract:
The following areas will be explored:
• Schemas, DML and metadata can be versioned
• Build and deploy as separate processes.
• DDL code can be automatically reviewed using static analysis
• Unit tests can be created and executed to ensure data quality and integrity
• Comparisons can be made with test and production systems prior to deployment
• Tool
SessionID: 35157
SQL Server Roadmap Beyond SQL Server 2008
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Jean-Claude Armand
Title: SQL Server Roadmap Beyond SQL Server 2008
Abstract:
This session will cover SQL Server 2008 adoption momentum in addition to the scheduled 2 SQL Server release that are currently schedule to be release during the next 36 months. As part of this session we will discuss in details of the upcoming release of SQL Server Kilimanjaro release and schedule around SQL11.
SessionID: 35165
Understanding Indexes for Single-Table Queries
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: Jeffrey Garbus
Title: Understanding Indexes for Single-Table Queries
Abstract:
SessionID: 35201
Enhance your .NET Application with SSRS
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 6
Speaker: Jessica Moss
Title: Enhance your .NET Application with SSRS
Abstract:
Improving the experience for users of your .NET application can be as simple as adding a SQL Server Reporting Services report. In a few easy steps, you can create an SSRS report, embed the report, and allow users to interact with it. This session will discuss best practices and show demos for different reporting and application scenarios.
SessionID: 35202
Make Reporting Services Work For You
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 6
Speaker: Jessica Moss
Title: Make Reporting Services Work For You
Abstract:
SessionID: 35218
Securing Sensitive Data with SQL Server
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: John Magnabosco
Title: Securing Sensitive Data with SQL Server
Abstract:
Databases often contain sensitive data. Without protection this data can fall into the hands of those who have less than honorable intentions. This can be disastrous for not only the business but also the client.
In this session the encryption and hashing features of SQL Server will be explored as well as some guidance in determining what data should be considered sensitive.
SessionID: 35224
Automating DBA Tasks with SQL Agent Jobs
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: Jonathan Kehayias
Title: Automating DBA Tasks with SQL Agent Jobs
Abstract:
SessionID: 35301
SQL Server and PowerShell
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: Maximo Trinidad
Title: SQL Server and PowerShell
Abstract:
Learn some differences between PowerShell and the SQLPS "SQL Server PowerShell". See how you can use PowerShell to manage, and/or manipulate data in your SQL Engine and their Databases.
SessionID: 35317
The New World of Microsoft Certifications
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 5
Speaker: Mike Wells
Title: The New World of Microsoft Certifications
Abstract:
Are you looking to get certified in 2005 or 2008? Do you want to upgrade a certification you already have? Join us for this dive into the new MS Certification paths for Visual Studio 2005 and SQL Server 2005 and see what's changing for 2008.
SessionID: 35319
Identifying and Removing Duplicate Records
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 1
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: 35358
T-SQL Enhancements in SQL Server 2008
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 2
Speaker: Plamen Ratchev
Title: T-SQL Enhancements in SQL Server 2008
Abstract:
SessionID: 35381
Monitoring Massive Scale Web Applications
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 1
Speaker: Roger Doherty
Title: Monitoring Massive Scale Web Applications
Abstract:
Hear how the Media Advertising Platform Initiatives team at Microsoft used technology and a key hosting partner to monitor the health of the largest online video event in history, the 2008 Summer Olympic Games on NBCOlympics.com. Learn how we used dynamic instrumentation in Silverlight 2 to monitor application and video quality health information for 400,000 simultaneous users, how we leveraged a hosting partner to rapidly deploy and manage an episodic data center, and how we built the data collection and analysis components using Windows Server 2008, Visual Studio 2008, .NET Framework 3.5, and SQL Server 2008.
SessionID: 35387
Building an SSIS Management Framework - Part 1
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 4
Speaker: Rushabh Mehta
Title: Building an SSIS Management Framework - Part 1
Abstract:
As more and more organizations and teams within organizations have started adopting SQL Server Integration Services for data processing and other management task automation, there is increasing need for standardization early in the process to avoid common management problems that arise from lack of standardization and good management techniques. In this session, we will help you identify areas of standardization and pitfalls that arise from lack of standards, reviews some common standardization approaches and best practices and finally walk you through a standardized template example that can be customized, deployed and used as a starting point for an SSIS project.
SessionID: 35388
Building an SSIS Management Framwork - Part 2
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 4
Speaker: Rushabh Mehta
Title: Building an SSIS Management Framwork - Part 2
Abstract:
As more and more organizations and teams within organizations have started adopting SQL Server Integration Services for data processing and other management task automation, there is increasing need for standardization early in the process to avoid common management problems that arise from lack of standardization and good management techniques. In this session, we will help you identify areas of standardization and pitfalls that arise from lack of standards, reviews some common standardization approaches and best practices and finally walk you through a standardized template example that can be customized, deployed and used as a starting point for an SSIS project.
SessionID: 35402
Bulk Loading SQL in Space (drive space)
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 4
Speaker: Rodney Landrum
Title: Bulk Loading SQL in Space (drive space)
Abstract:
SessionID: 35408
Why DBAs Should Learn PowerShell
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: Ronald Dameron
Title: Why DBAs Should Learn PowerShell
Abstract:
I will detail my reasoning why a DBA would benefit from learning PowerShell. I will demonstrate how a DBA can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage their workload.
SessionID: 35412
Test Data Generation Practices
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 5
Speaker: Ryan Dorrell
Title: Test Data Generation Practices
Abstract:
SessionID: 35420
SQL Server 2008 for Developers
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 3
Speaker: Sam Nasr
Title: SQL Server 2008 for Developers
Abstract:
SQL Server has been around for many years with each version bringing more features, and for 2008 it's no different. The latest version has many new features specific for developers aimed at producing more efficient code. Some of those features include Table Value Parameters, Hierarchy ID, and Grouping sets. Attend this session and be among the first to leverage the new features of SQL Server 2008.
SessionID: 35442
Legal Liability Data Retention
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 6
Speaker: Suzanne Meehle
Title: Legal Liability Data Retention
Abstract:
Damned If You Do, Damned If You Don't: Legal Liability Data Retention. You may be liable for the data you keep. You will be liable for the data you destroy. We will discuss the brave new world of e-discovery, liability, and effective database and data retention policies. In addition, you will receive practical guidance on protecting yourself and your company from legal liability and your data from theft and inadvertent disclosure.
SessionID: 35479
Unconventional ETL Using SSIS Scripting
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 4
Speaker: Tim Mitchell
Title: Unconventional ETL Using SSIS Scripting
Abstract:
SessionID: 35499
Data Mining and Predictive Analysis using SSAS,SQL
Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 5
Speaker: Vikas Hawaldar
Title: Data Mining and Predictive Analysis using SSAS,SQL
Abstract:
Introduction to Data Mining using SQL Server
Basic concepts and lifecycle of a Data Mining project using SQL Server 2005/2008