sqlsathistory

Nr: 43

SQLSaturday #43 - Redmond 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Buck Woody	Room 2003	SQL Server for the Oracle DBA
00:00:00	CLIFFORD DIBBLE	Room 2003	Utility Control Point in SQL 2008 R2
00:00:00	Sumeet Bansal	Room 2015	Accelerating SQL with Solid State (w/ iPod Raffle)
00:00:00	Dean Richards	Room 2003	Tuna Helper for DBAs and Developers
00:00:00	David Lydston	Room 2011	Auditing your SQL Server
00:00:00	Donabel Santos	Room 2007	SQL Server and PowerShell
00:00:00	Donabel Santos	Room 2007	SQL Server 2008 Reporting from the Ground Up
00:00:00	Doug Wheaton	Room 2011	Heterogeneous Data Integration with SSIS CDC
00:00:00	Greg Larsen	Room 2015	Exploring SQL Server System Information with DMVs
00:00:00	Kalen Delaney	Room 2015	The Compression Session
00:00:00	Matt Masson	Room 2011	SSIS Performance Design Patterns
00:00:00	Remus Rusanu	Room 2015	High Volume Real Time Contiguous ETL and Audit
00:00:00	Rick Morelan	Room 2003	Explicit Transaction Management
00:00:00	Robert Davis	Room 2007	Using SQL Trace/Profiler Effectively
00:00:00	Robert Davis	Room 2007	Adventures in SQL Server Masters Certification
00:00:00	Scott Stauffer	Room 2011	SSIS for the faint of heart
00:00:00	Chuck Lathrope	Room 2015	Replication Performance Tuning and Troubleshooting
00:00:00	Todd McDermid	Room 2011	Data Warehouse Dimension Processing with SSIS

SessionID: 29353

SQL Server for the Oracle DBA

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2003

Speaker: Buck Woody

Title: SQL Server for the Oracle DBA

Abstract:

Come hear Buck Woody, Microsoft's "Real World DBA" give a marketing-free introduction to SQL Server for the Oracle professional. No experience in SQL Server is necessary - we'll cover the basics of SQL Server Architecture using Oracle concepts as a guide. If you're an Oracle professional and you want to add SQL Server to your "knowledge arsenal", come hear this overview. You'll also get a list of resources that will enable you to research further.

SessionID: 29425

Utility Control Point in SQL 2008 R2

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2003

Speaker: CLIFFORD DIBBLE

Title: Utility Control Point in SQL 2008 R2

Abstract:

Learn how the Utility Control Point (UCP) in SQL 2008 R2 can help you with your capacity management and consolidation projects. In this talk, you will learn the key concepts around the UCP and see a demo. This is also your chance to give us feedback about how you want the UCP to evolve in the 11.0 release of SQL Server.

SessionID: 29619

Accelerating SQL with Solid State (w/ iPod Raffle)

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2015

Speaker: Sumeet Bansal

Title: Accelerating SQL with Solid State (w/ iPod Raffle)

Abstract:

Solid-state technologies are changing the way that MS SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies. Solid state is changing the way datacenters look and how MS SQL Servers perform. This session will address: 1) On overview of solid state technology options for SQL Server 2) Why solid state makes a difference? 3) An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each: a. Disk-based SSDs b. Onboard/Embedded PCI Express devices c. Host-based PCI Express devices 4) Customer proof: Wine.com case study 5)Raffle for a Steve Wozniak

SessionID: 29872

Tuna Helper for DBAs and Developers

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2003

Speaker: Dean Richards

Title: Tuna Helper for DBAs and Developers

Abstract:

Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process I use with great success and it will include topics such as: SQL diagramming, wait type data, column selectivity, and others that will help you succeed on future tuning projects.

SessionID: 29913

Auditing your SQL Server

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2011

Speaker: David Lydston

Title: Auditing your SQL Server

Abstract:

New in SQL Server 2008 Enterprise Edition is a feature called SQL Audit. This feature allows you to record statements executed against the SQL Server at the server and database scopes, for database, schema and object classes. Unlike prior features that could be used for capturing these statements, SQL Audit allows the user, greater granularity in statements captured, multiple output targets, and the ability to capture statements previously un-captureable. In this presentation, code will be presented to setup and monitor SQL Audits along with tips and additional code to enhance your SQL Server auditing experience.

SessionID: 29954

SQL Server and PowerShell

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2007

Speaker: Donabel Santos

Title: SQL Server and PowerShell

Abstract:

This session will cover how you can get started with PowerShell, and how you can use PowerShell with SQL Server. Powershell, a scripting language that leverages Microsoft .NET Framework, can help you manage and automate SQL Server. Demos will include common PowerShell tasks and commands, and querying/scripting/automating SQL Server using SMO and applicable .NET Libraries.

SessionID: 29955

SQL Server 2008 Reporting from the Ground Up

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2007

Speaker: Donabel Santos

Title: SQL Server 2008 Reporting from the Ground Up

Abstract:

In this session we will explore the rich reporting features introduced in SQL Server 2008 and 2008 R2 Reporting Services, including Report Builder 3.0. We will walk through how to create basic reports, add parameters, enhance layout, and integrate newvisualization components including sparklines, data bars, gauges and maps.

SessionID: 29963

Heterogeneous Data Integration with SSIS CDC

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2011

Speaker: Doug Wheaton

Title: Heterogeneous Data Integration with SSIS CDC

Abstract:

This session will focus on Microsoft and partner technologies that enable high performance, efficient and real-time data integration using SQL Server Integration Services (SSIS), and that work with data from Oracle, Teradata, and other heterogeneous sources. You will learn how Microsoft high-speed Connectors by Attunity can be leveraged with change-data-capture (CDC) technologies integrated with SSIS to enable data replication. Use cases highlighting real-time data warehousing and operational reporting, as well as maintenance of data consistency between operational databases and applications will also be outlined.

SessionID: 30282

Exploring SQL Server System Information with DMVs

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2015

Speaker: Greg Larsen

Title: Exploring SQL Server System Information with DMVs

Abstract:

This session will explore different DMV and how they can be used to obtain information about your SQL Server environment. There will be a number of demo's. In these demos different DMV's will be used provide different infomation about how your SQL Server instance is running. Peeking under the covers is now only a DMV away.

SessionID: 31170

The Compression Session

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2015

Speaker: Kalen Delaney

Title: The Compression Session

Abstract:

SQL Server 2008 allows you to compress your data in several different ways. Your tables can be compressed using row compression or page compression, and your can also choose to compress your backups. In this session we'll look at what kinds of data give you the most space savings when compressed, and we'll also discuss the algorithms SQL Server uses to compress your data. Knowing how SQL Server performs compression will allow us to evalutate when the space savings will be worth the cost, and when you might want to avoid compression.

SessionID: 31607

SSIS Performance Design Patterns

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2011

Speaker: Matt Masson

Title: SSIS Performance Design Patterns

Abstract:

Need a fast data integration solution, but don't have the time or budget for heavy performance tuning? Come learn how to maximize your ROI by applying trusted design patterns to your Integration Services packages. We talk about how to set performance expectations, and how to put together a simple framework to record benchmarks for your ETL process. We go over the basics of smart package design, and then look at a number of design patterns for common data warehousing problems, such as Slowly Changing Dimension processing, Range Lookups, and Change Detection.

SessionID: 32487

High Volume Real Time Contiguous ETL and Audit

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2015

Speaker: Remus Rusanu

Title: High Volume Real Time Contiguous ETL and Audit

Abstract:

High volume contiguous ETL is always problematic, and even more so when near-real-time is desired.

This presentation goes through a solution collects and aggregates security audit data for nearly 400000 machines, a contiguous 24x7 stream of nearly 200 events per second, using a budget tight solution that involves SQL Express, Service Broker and Database Mirroring.

SessionID: 32515

Explicit Transaction Management

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2003

Speaker: Rick Morelan

Title: Explicit Transaction Management

Abstract:

Learn the basics and a few tricks to help your more advanced SQL transactions make sense. Concepts from chapter nine of Beginning SQL Joes 2 Pros are explained by author Rick Morelan. Isolation levels and table hints can be narrowed down to a few easy rules around just two questions. 1) What should SQL check before it allows data changes? 2) What should SQL show when someone else is making changes?

SessionID: 32610

Using SQL Trace/Profiler Effectively

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2007

Speaker: Robert Davis

Title: Using SQL Trace/Profiler Effectively

Abstract:

SessionID: 32611

Adventures in SQL Server Masters Certification

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2007

Speaker: Robert Davis

Title: Adventures in SQL Server Masters Certification

Abstract:

The Microsoft Certified Master for SQL Server program is a 3 week program of in-depth training by the foremost experts in the field and certification.

Come find out what the MCM:SQL is all about. Speaker is going through the March rotation of the MCM program. Get his take on what the program was like. Is it easy or hard? Is it intense or laid back? Is it worth the effort and expense?

SessionID: 32813

SSIS for the faint of heart

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2011

Speaker: Scott Stauffer

Title: SSIS for the faint of heart

Abstract:

Scott's gentle introduction to SQL Server Integration Services (or SSSIS) will primarily be demonstrating how to you can use the tool in the real world to get work done. READ: very little PowerPoint time. SSIS is a high performance ETL solutions introduced in SQL Server 2005 to replace SQL Server's DTS functionality. ETL? It's okay, Scott will briefly cover some of these concepts too. Relax, sit back and learn how to simplify your "Extract, Transform, and Load" processes.

SessionID: 33042

Replication Performance Tuning and Troubleshooting

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2015

Speaker: Chuck Lathrope

Title: Replication Performance Tuning and Troubleshooting

Abstract:

This session is for users who want to improve their throughput using Replication Profiles and Server/Networking tweaks. I will also cover custom monitoring stored procedures that don't require you to keep replication monitor on all the time. Last item covered are some queries you can use to see replication errors and common solutions to them. It is expected that you know how to setup replication. Session will be focused towards SQL 2005/08 and transactional replication. But can apply towards SQL 2000 and merge replication.

SessionID: 33761

Data Warehouse Dimension Processing with SSIS

Back to calendar

Event Date: 12-06-2010 - Session time: 00:00:00 - Track: Room 2011

Speaker: Todd McDermid

Title: Data Warehouse Dimension Processing with SSIS

Abstract:

The SCD Wizard included in Integration Services is easy to use, and has all the features you need for smaller, simple dimension processing. However, it is not the easiest component to adjust, and doesn't perform very well with larger dimensions. This session will cover three alternative techniques for processing changes to dimension tables within SSIS: "rolling your own SCD" with Lookups and Conditional Splits, using the T-SQL MERGE statement, and the Kimball Method SCD component. The strengths and weaknesses of each technique will be described and demonstrated.

This site is open source. Improve this page.