sqlsathistory

Nr: 10

Back to Main list

SQLSaturday #10 - Tampa 2009

Start Time (24h) Speaker Track Title
00:00:00 Andreas Etelkozi Track 1 Data Scrambling
00:00:00 Andy Warren Track 1 SQL Server Statistics
00:00:00 Arie Jones Track 6 Reporting Services 2008 Unleashed!
00:00:00 Arie Jones Track 3 CLR within SQL Server 2008
00:00:00 Brian Knight Track 5 Introduction to SSAS
00:00:00 Brian Knight Track 4 SSIS for DBAs
00:00:00 Nikita Polyakov Track 3 SQL Compact Data Sync
00:00:00 Chad Miller Track 5 Using RSS for System Administration
00:00:00 Chris Rock Track 6 ASP.NET Databinding 101
00:00:00 Kent Waldrop Track 1 Transact SQL Frequently Asked Questions
00:00:00 David Hayden Track 3 SQL Server Data Access Tips and Techniques
00:00:00 Dean Richards Track 2 Wait-Time Based SQL Server Performance Management
00:00:00 Eric Wisdahl Track 4 SSIS: Configurations, Expressions and Constraints
00:00:00 James McAuliffe Track 2 Using Visual Studio Database Edition GDR-RTM
00:00:00 Jean-Claude Armand Track 1 SQL Server Roadmap Beyond SQL Server 2008
00:00:00 Jeffrey Garbus Track 2 Understanding Indexes for Single-Table Queries
00:00:00 Jessica Moss Track 6 Enhance your .NET Application with SSRS
00:00:00 Jessica Moss Track 6 Make Reporting Services Work For You
00:00:00 John Magnabosco Track 2 Securing Sensitive Data with SQL Server
00:00:00 Jonathan Kehayias Track 2 Automating DBA Tasks with SQL Agent Jobs
00:00:00 Maximo Trinidad Track 3 SQL Server and PowerShell
00:00:00 Mike Wells Track 5 The New World of Microsoft Certifications
00:00:00 Michael Antonovich Track 1 Identifying and Removing Duplicate Records
00:00:00 Plamen Ratchev Track 2 T-SQL Enhancements in SQL Server 2008
00:00:00 Roger Doherty Track 1 Monitoring Massive Scale Web Applications
00:00:00 Rushabh Mehta Track 4 Building an SSIS Management Framework - Part 1
00:00:00 Rushabh Mehta Track 4 Building an SSIS Management Framwork - Part 2
00:00:00 Rodney Landrum Track 4 Bulk Loading SQL in Space (drive space)
00:00:00 Ronald Dameron Track 3 Why DBAs Should Learn PowerShell
00:00:00 Ryan Dorrell Track 5 Test Data Generation Practices
00:00:00 Sam Nasr Track 3 SQL Server 2008 for Developers
00:00:00 Suzanne Meehle Track 6 Legal Liability Data Retention
00:00:00 Tim Mitchell Track 4 Unconventional ETL Using SSIS Scripting
00:00:00 Vikas Hawaldar Track 5 Data Mining and Predictive Analysis using SSAS,SQL

SessionID: 34918

Data Scrambling

Back to calendar

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

Back to calendar

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!

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Using RSS for System Administration

Back to calendar

Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 5

Speaker: Chad Miller

Title: Using RSS for System Administration

Abstract:

Provide an overview using simple tools that generate standard RSS feeds containing information regarding SQL Server jobs; ad-hoc queries and database size and space allocation information. This session will demonstrate using RSS to automate a daily DBA morning checklist by aggregating error logs, backup and additional information across multiple servers/databases.

SessionID: 35065

ASP.NET Databinding 101

Back to calendar

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

Back to calendar

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

Back to calendar

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

Wait-Time Based SQL Server Performance Management

Back to calendar

Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 2

Speaker: Dean Richards

Title: Wait-Time Based SQL Server Performance Management

Abstract:

SessionID: 35114

SSIS: Configurations, Expressions and Constraints

Back to calendar

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

Back to calendar

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:

Bring application changes and database changes together at last! This session will discuss the tools recently provided in the newest Visual Studio Database Edition GDR - RTM for comparing schemas and data, and building deployment scripts. The recent architectural changes made for this release make it a brand new product, and bring a little bit of Rosario to the 2008 team system today.

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

Back to calendar

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

Back to calendar

Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 2

Speaker: Jeffrey Garbus

Title: Understanding Indexes for Single-Table Queries

Abstract:

This session describes everything you ever wanted to know about physical index structures, as well as how the optimizer chooses indexes for performance. (Join performance in separate session!)

SessionID: 35201

Enhance your .NET Application with SSRS

Back to calendar

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

Back to calendar

Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 6

Speaker: Jessica Moss

Title: Make Reporting Services Work For You

Abstract:

Are you frustrated with building reports in SQL Server Reporting Services? Tired of telling your users that you can't give them the perfect report due to limitations in the product? If so, this session will calm your nerves and make you a guru by showing how to utilize custom code and expressions to shine up your new or existing reports. Specifically, we will show how to create dynamic data groups, use paging techniques, add color and formatting, and more. This session is best suited for people with some knowledge of either SSRS 2005 or SSRS 2008.

SessionID: 35218

Securing Sensitive Data with SQL Server

Back to calendar

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

Back to calendar

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:

Being a DBA consists of a number of repetative tasks that are both monotonous and mundane. Learn how to automate a number of the tasks a DBA does on a daily database to simplify management of large environments and free time up for other important tasks such as planning upgrades and identifying performance problems before they actually occur.

SessionID: 35301

SQL Server and PowerShell

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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)

Back to calendar

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:

This session will demonstrate the numerous ways to quickly and efficiently import and export large data volumes to SQL Server. Using BCP, BULK INSERT, OPENROWSET and third party tools, you will learn how to "minimally" log transactions to avoid run away log file growth as well as the best method to backup and restore large databases, 300GB or more. We will see how much we can fill a database in the course of the hour and discuss why we (or your business) would want to store so much data in the first place.

SessionID: 35408

Why DBAs Should Learn PowerShell

Back to calendar

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

Back to calendar

Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 5

Speaker: Ryan Dorrell

Title: Test Data Generation Practices

Abstract:

Adding test data into your database can be a time-consuming, boring exercise - but you need valid data scenarios, a range of inputs, and the ability to easily generate large volumes of test data rapidly. With Visual Studio 2008 Database Edition ("Data Dude") find out how you can leverage the powerful tools available to fine-tune your test data, and rapidly generate the data you need to fully test your apps!

SessionID: 35420

SQL Server 2008 for Developers

Back to calendar

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

Back to calendar

Event Date: 24-01-2009 - Session time: 00:00:00 - Track: Track 6

Speaker: Suzanne Meehle

Abstract:

SessionID: 35479

Unconventional ETL Using SSIS Scripting

Back to calendar

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

Back to calendar

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