SQLSaturday #43 - Redmond 2010
Event Date: 06/12/2010 00:00:00
Event Location:
- The MIXER building
- 15255 NE 40th Street
- Redmond, Washington
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
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
Speaker(s):
- Sumeet Bansal
Track and Room: Room 2015 - N/A
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.
Speaker(s):
- Donabel Santos
Track and Room: Room 2007 - N/A
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.
Speaker(s):
- Chuck Lathrope
Track and Room: Room 2015 - N/A
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.
Speaker(s):
- Donabel Santos
Track and Room: Room 2007 - N/A
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.
Speaker(s):
- Scott Stauffer
Track and Room: Room 2011 - N/A
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.
Speaker(s):
- David Lydston
Track and Room: Room 2011 - N/A
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.
Speaker(s):
- Remus Rusanu
Track and Room: Room 2015 - N/A
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?
Speaker(s):
- Rick Morelan
Track and Room: Room 2003 - N/A
Title: Using SQL Trace/Profiler Effectively
Abstract: The session will cover the difference between SQL Trace and SQL Profiler, and why we recommend using SQL Trace in a production environment. Topics covered will be how and when to use SQL Profiler vs SQL Trace, how to create a trace template and convert it to a SQL script, and how to start a SQL Trace running in response to a performance event. Demos will include creating a trace template and converting it to a script and an example of how SQL Profiler can bring your whole server to a crawl.
Speaker(s):
- Robert Davis
Track and Room: Room 2007 - N/A
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.
Speaker(s):
- Doug Wheaton
Track and Room: Room 2011 - N/A
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?
Speaker(s):
- Robert Davis
Track and Room: Room 2007 - N/A
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.
Speaker(s):
- CLIFFORD DIBBLE
Track and Room: Room 2003 - N/A
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.
Speaker(s):
- Kalen Delaney
Track and Room: Room 2015 - N/A
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.
Speaker(s):
- Dean Richards
Track and Room: Room 2003 - N/A
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.
Speaker(s):
- Buck Woody
Track and Room: Room 2003 - N/A
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.
Speaker(s):
- Matt Masson
Track and Room: Room 2011 - N/A
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.
Speaker(s):
- Greg Larsen
Track and Room: Room 2015 - N/A
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.
Speaker(s):
- Todd McDermid
Track and Room: Room 2011 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Scott Stauffer
Twitter: - @SQLSocialite
LinkedIn: Scott Stauffer
Contact: http://scottstauffer.ca
Scott Stauffer (@SQLSocialite) is very PASSionate about data and enjoys meeting with like-minded data geeks. He started the Vancouver PASS Chapter in 2004. In 2008, Scott was recognized by Microsoft with a SQL Server MVP award. In 2009, Scott started a PASS BI Chapter in Vancouver, and was also at one time the PASS Regional Chapter Mentor for Canada. For over 10 years he has been an independent consultant working with clients to solve their data woes and extract insight from their business data.
Matt Masson
Twitter: - @mattmasson
Contact: http://www.mattmasson.com/
Matt Masson is a Program Manager in the Information Management and Machine Learning (IMML) organization. Matt has worked on multiple data integration products, including Power Query, SSIS, DQS, MDS, and the Data Management Gateway for Power BI. He has authored two books on SSIS (Apress, and MS Press), and is a frequent presenter at Microsoft conferences. You can find his blog at http://www.mattmasson.com/.
Robert Davis
Contact: http://www.sqlservercentral.com/blogs/robert_davis/default.aspx
Robert started his career working with SQL Server as a database developer in February 2000. In 2003, he accepted his first DBA job. Robert worked as a Data architect/DBA. In 2007, Robert started working as a contractor at Microsoft. He worked contracts at Microsoft as both a production DBA on operations teams and as a development DBA on an engineering team.
In 2009, he accepted an FTE position with the PQO Ops team as an Ops Engineer (DBA). He is the technical lead for the PQO Ops SQL V-Team.
Kalen Delaney
Twitter: - sqlqueen
Kalen Delaney is a Data Platform MVP who has worked with SQL Server for more than 32 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for decades. She is the primary author of SQL Server Internals and the Inside SQL Server series. Kalen is also one of the primary editors for the Red Gate SQL Server Stairways tutorials.
Doug Wheaton
Doug Wheaton is a CDC expert and has over 20 years of experience in the content, workflow management and data integration space. He has written numerous related articles and has presented at many Microsoft conferences, SQLSaturdays and user groups throughout the US on the topics of BI and data integration using Microsoft SSIS.
Sumeet Bansal
Sumeet Bansal is Principal Solutions Architect for Fusion-io. He designs architectural solutions with Fusion-io products that deliver unprecedented levels of scalability, performance and simplicity.
Sumeet has more than 11 years IT and database-infrastructure experience, including work as vice-president of information technology at MS SQL-based Internet retailer Wine.com, senior database architect for MS SQL-based eVineyard inc., and systems analyst for Akiba Bank Limited.
Rick Morelan
Rick has worked more than 12 years at Microsoft and has attained over 30 Microsoft technical including certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for NW University, Volt Technical Education, The DigiGirlz, and Microsoft. Rick is the Author of the 5 volume SQL Joes 2 Pros book series.
Donabel Santos
Contact: http://www.sqlmusings.com
Donabel Santos (MCITP, MCT) is a SQL Server MVP and is the senior SQL Server Consultant/Trainer at QueryWorks Solutions in Vancouver, BC. She has worked with SQL Server since version 2000 in numerous development, tuning, reporting, and integration projects with ERPs, CRMs, SharePoint, and other custom applications. She is the author of SQL Server 2012 with PowerShell V3 Cookbook from Packt Publishing.
Todd McDermid
Twitter: - @Todd_McDermid
LinkedIn: Todd McDermid
Contact: https://toddmcdermid.blogspot.com
Todd McDermid is a local BC developer who’s turned into a data warehouse and business intelligence evangelist. He started out programming DBase, VB6, and C# - but is now passionate about the SQL Server BI stack. He’s concentrated on using Integration Services to build the backbone of BI delivery – a dimensional warehouse. Todd has been known to blog, forum troll, code open-source extensions, and present on BI topics across the continent.
CLIFFORD DIBBLE
Contact: http://www.linkedin.com/pub/clifford-dibble/5/20b/23b
Clifford has been a program manager in SQL Server since 2002. Among other things, he was the active PM for “system views”, “DMVs”, ”DDL triggers”, and “resource database” during the 9.0 release. During the 10.0 release, Clifford was off working on an incubation project. For the 10.5 and 11.0 releases, he is focused on multi-instance manageability and SQL management packs.
Remus Rusanu
Twitter: - rusanu
LinkedIn: Remus Rusanu
Contact: http://rusanu.com
Remus Rusanu is a former SQL Server team member. For 12 years he worked on such features as Service Broker, Columnstore Indexes, Query Store and many more. In April 2016 he left Microsoft to found DBHistory.com, a simplified SQL Server monitoring and auditing product.
Chuck Lathrope
Twitter: - @sqlguychuck
LinkedIn: Chuck Lathrope
Contact: http://www.sqlwebpedia.com
Chuck Lathrope is a data architect for Limeade, a SaaS health and wellness platform. Chuck is a two-time SQLSaturday event speaker on replication, was a Top 5 nominee of Red-Gate Exceptional DBA Award in 2009 and often shares his 20 years of IT knowledge on twitter under the name @SQLGuyChuck and his website www.sqlwebpedia.com.
Donabel Santos
Contact: http://www.sqlmusings.com
Donabel Santos (MCITP, MCT) is a SQL Server MVP and is the senior SQL Server Consultant/Trainer at QueryWorks Solutions in Vancouver, BC. She has worked with SQL Server since version 2000 in numerous development, tuning, reporting, and integration projects with ERPs, CRMs, SharePoint, and other custom applications. She is the author of SQL Server 2012 with PowerShell V3 Cookbook from Packt Publishing.
Dean Richards
LinkedIn: Dean Richards
Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.
Robert Davis
Contact: http://www.sqlservercentral.com/blogs/robert_davis/default.aspx
Robert started his career working with SQL Server as a database developer in February 2000. In 2003, he accepted his first DBA job. Robert worked as a Data architect/DBA. In 2007, Robert started working as a contractor at Microsoft. He worked contracts at Microsoft as both a production DBA on operations teams and as a development DBA on an engineering team.
In 2009, he accepted an FTE position with the PQO Ops team as an Ops Engineer (DBA). He is the technical lead for the PQO Ops SQL V-Team.
David Lydston
Contact: http://www.apollodatatech.com/
David Lydston is the Lead Systems Engineer for Apollo Data Technologies in Bellevue, WA. He holds MCITP Database Administrator certification for SQL Server 2005, and an MS in Information Systems Management. David has worked with SQL Server in the healthcare field since 2002; specializing in securing PHI and change management/monitoring.
Buck Woody
Twitter: - BuckWoodyMSFT
LinkedIn: Buck Woody
Contact: http://buckwoody.wordpress.com/
Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.
Greg Larsen
Twitter: - GregoryALarsen
LinkedIn: Greg Larsen
Greg Larsen has been working with SQL Server since 1999. He has authored 100’s of articles related to SQL Server. He holds a MCSE Data Management and Analytics. Greg also a SQL Server Consultant, adjunct professor and technical writer.
Sponsors
The following is a list of sponsors that helped fund the event: