SQLSaturday #68 - Olympia 2011

Event Date: 04/09/2011 00:00:00

Event Location:

  • South Puget Sound Community College
  • 2011 Mottman Road SW
  • Olympia, Washington

PDF of Schedule

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).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Visual Report Design: Bringing Sexy Back

Abstract: Do your users have the same old, mundane table reports they’ve been using for decades? Stop living in the past and make your reports pop. Learn to use design patterns, best practices and visuals that pack more usable information into fewer, more usable reports. Use Reporting Services and other Microsoft BI tools to create dynamic, browse-able reports that answer important business questions at a glance and then let business users explore the details to gain insight and take action. Sure, Business Intelligence is all the rage but you don’t have to invest in an entire BI platform to have fresh, usable reports. With a little simple programming code, these design techniques apply to big analytic solutions smaller-scale operational reports.


  • Paul Turley

Track and Room: 151 - N/A

Title: Women in Technology

Abstract: Most women working in technology keep a low profile, rarely standing out, rarely pushing the extra effort that typically denotes excellence. Women are constantly juggling to find the balance between career and family –with added complexity when children are involved. Come and learn about the three essential career considerations for Women in Technology. Understanding and applying these considerations can help you get to the next level of excellence in your career and family life. Men who understand these considerations can better support the women members in their life. I will share some of my own experiences, challenges, and lessons learned as I have learned how to balance career, family, and life in general.


  • Sopheap Suy

Track and Room: 351 - N/A

Title: Row Level Security and SQL-CLR integration

Abstract: RLS (Row Level Security) is often integral part of EDW (Enterprise Data Warehouse) design. There are many ways to implement RLS. This is the story about our evolution of RLS implementation and how SQL-CLR integration helped us solve technical difficulty.


  • Toshi Watanabe

Track and Room: 151 - N/A

Title: Self Service BI in SQL Server 2008 R2 (PowerPivot)

Abstract: There are many IT pros who know all the snazzy tools to create fantastic reports. The users who know the data inside and out may not know those tools, but odds are that they know Excel. Microsoft has released PowerPivot which seems to bridge the gap between the two worlds. These power users can now create their own fantastic reports within PowerPivot. We will explore what PowerPivot is and how can use it to create a self-service business intelligence solution.


  • Hope Foley

Track and Room: 151 - N/A

Title: Strategies for Working with VLDBs

Abstract: Very large databases (VLDBs) are just like regular databases, right? There’s just more of them to love. Working with very large databases can be difficult and tricky at times. Everything takes longer and minor issues become major very quickly. In this session you will learn some strategies for working with VLDBs such as how to speed up backups and restores, how to minimize your maintenance window requirements, and how to efficiently and quickly set up failover partners and replicas. Demos will include how I set up a log shipping secondary and a replica of a 2 TB database in less than half an hour.


  • Robert Davis

Track and Room: 352 - N/A

Title: A DBA Looks at Relational Data Warehouses

Abstract: This session focuses on some surprising lessons learned and insights gained from applying DBA practices to relational data warehouses. Scenarios covered include use of table schemas versus synonyms, database chaining, managing user security, logical separation of user work from the data, backup and restore strategies, index maintenance, and change control.


  • Ron Talmage

Track and Room: 352 - N/A

Title: Solving Real Life Production Issues

Abstract: A real life application of solving one companies serious production issues. This session will touch on many SQL Server tools, Third Party Tools, disciplines and resources and bring them all together into a synergy of useful index generation, and interpreting execution plans to get real performance measurements.


  • Dale Cunningham

Track and Room: 351 - N/A

Title: Basic Performance Tips and Gotchas

Abstract: Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do – when it comes to the most common types of indexes so you always make the right move. We will use lessons from SQL Programming Joes 2 Pros.


  • Rick Morelan

Track and Room: 352 - 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 this 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.


  • Scott Stauffer

Track and Room: 352 - N/A

Title: Managing Sparse Resources with Resource Governor

Abstract: A large majority of a modern DBA’s workload consists of managing the resources on their systems in order to ensure that they are being followed and resources are accessible when needed. SQL Server 2008 provides Resource Governor, which allows the DBA to discretely manage system resources in a very structured way. In this session, we will show you how to configure, monitor, and administer these features as well as demonstrate some of the pitfalls and helpful hints that you will need in order to successfully implement this fascinating tool.


  • Arie Jones

Track and Room: 151 - N/A

Title: Through the Looking-Glass

Abstract: “Through the Looking-Glass, and What Alice Found There” - When your world is SQL Server, you need a looking-glass to determine server health, diagnosis problems, and tune performance. In this session will we follow Alice through the looking-glass to determine what she finds in SQLServerLand. Alice will be using dynamic management views and functions (DMVs) to explore the land behind the looking-glass. She will find statistics, poorly performing queries, and much more. Follow Alice and her new friends, as she traverses across SQLServerLand and provides you with snippets of T-SQL code that you can use to explore your own SQLServerLand.


  • Greg Larsen

Track and Room: 252 - N/A

Title: Inside and out of Transactional Replication

Abstract: Replication in SQL Server is great tool for scaling out your master database(s) onto other servers for reporting and remote site access with near real-time data propagation. In this session, I will cover LAN and WAN data replication tricks-of-the-trade to offload work from your master servers. Using these techniques, you can improve your performance and monitoring of your existing installations or gain knowledge and confidence to implement new solution for your company.


  • Chuck Lathrope

Track and Room: 252 - N/A

Title: Powershell: Are you checking out my profile?

Abstract: Powershell is a very powerful management tool and you can spend hours writing magical scripts to do all the things you want. Frequently forgotten is the Powershell profile, a place you can add your own functions which can provide you lightening fast access to information. We’ll talk about the power a profile puts at your fingertips. I will also demo (and share) a bunch of short functions that I use frequently for common tasks. I’ll show you my Powershell profile if you show me yours.


  • Nicholas Cain

Track and Room: 351 - N/A

Title: Query Plans

Abstract: This session is written to help developers to read query plans, understand commonly seen operators and properties in the plan. at the end, I will explain how SQL Server estimates the cost of operators and how SQL Server make decisions to choose a plan out of numerous alternatives


  • John Huang

Track and Room: 352 - N/A

Title: Get the most out of SQL Server Standard Edition

Abstract: How can you get the most out of SQL Server Standard Edition? The SQL Server Enterprise Edition (EE) is far more expensive than the Standard Edition (SE). Many small office applications use SE. What features do you really need for your database system? Many features that are only available in EE, such as partitioning and data compression, are specific to managing larger databases. If you do not have very large databases, perhaps SE will be sufficient. Find out what actually improves performance for SE.


  • Diane Robey

Track and Room: 351 - N/A

Title: Cloud computing for the Data Professional

Abstract: The term “Cloud Computing” has become so polluted that it has come to mean “web”. How do you de-tangle all the hype and vendor terms and determine when and where you can use it? Buck Woody, a Senior Technical Specialist in Distributed Computing at Microsoft will explain your options – and describe the information you need to take back to your organization.


  • Buck Woody

Track and Room: 252 - N/A

Title: Monitoring Data Changes with Change Data Capture

Abstract: Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment.


  • Arie Jones

Track and Room: 252 - N/A

Title: Load-balancing architectures for Online Reporting

Abstract: We will describe some of the different architectures (focusing on the db side) that Microsoft Adserving has used to Load Balance ever growing user reporting loads, data refreshes, and database maintenance across multiple reporting servers. The focus will be on the DB side, with minor context given to the web and middle tier pieces necessary for each system to work. Note that this is reporting in the sense of generating end user reports (not using SSRS).


  • John Halunen Aubra Moore

Track and Room: 252 - N/A


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Diane Robey

Diane Robey is a Database Administrator for Economic Research Institute in Redmond, WA and has been in IT since 1984. She became familiar with the SQL language using Informix, and then Oracle as a Certified Oracle DBA. Diane has developed data models and databases for several web sites and now specializes in SQL Server, primarily as a DBA.

As Vice President of the Pacific Northwest SQL Server User Group (PNWSQL), Diane enthusiastically promotes SQL Server and encourages DBAs and developers to embrace SQL Server. She has presented at PNWSQL and SQLSaturday #68 in Olympia, Washington.

Arie Jones

Twitter: - @programmersedge

LinkedIn: Arie Jones

Contact: http://www.programmersedge.com

Arie Jones (quot;AJquot;) is one of the owners and Vice President of Emerging Technologies for Indy Data Partners, Inc. in Indianapolis, IN. AJ is a frequent speaker at national conferences and local user groups. With over 15 years of experience in application development and database administration on various platforms, he specializes in developing cross-platform solutions with an emphasis on .NET and SQL Server technologies. He blogs extensively at http://www.programmersedge.com.

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.

Hope Foley

Contact: http://hopefoley.com/

Hope has over 12 years experience in the IT world, she has worked across many industries from small business enterprises to Fortune 500 companies. She has a vast knowledge of database design, administration and support, data warehousing and data mining, and custom database solutions. Hope joined PTI in 2007 as a SQL Server Database Administrator/Analyst, and took over as Principal Microsoft Consultant, where she now leads a team of expert DBAs and developers. She is also a SQL Server MVP.

Robert Davis

Twitter: - @SQLSoldier

LinkedIn: Robert Davis

Contact: http://www.sqlsoldier.com

Robert is a SQL Server Certified Master, MVP, and has spent 17+ years honing his skills in security, performance tuning, SQL development, high availability, and disaster recovery. He served as PM for the SQL Server Certified Master Program at Microsoft Learning, and in various roles at Microsoft specializing in SQL Server administration, development, and architecture. He currently works as a Database Engineer at BlueMountain Capital Management where he spends a vast majority of his time tuning massively parallel queries. Robert feeds his passion for security by acting as co-leader of the PASS Security Virtual Chapter.

Dale Cunningham

Twitter: - https://twitter.com/fly_scuba

LinkedIn: Dale Cunningham

Contact: http://www.dalecunningham.com

Dale Cunningham is a Sr. Database Administrator and has worked for enterprises both large and small. Performance tuning, Clustering, High Availability and Disaster Recovery are his preferred fields of focus in the MS SQL arena. In his spare time, Dale enjoys flying as a private pilot and playing racquetball. As a father of 5 children and grandfather to 4, family is an important part of his life. Dale enjoys visiting foreign countries and exploring the world. He has recently been married to a wonderful woman from Ukraine and they enjoy traveling the world together. Dale desires to build a home that is energy self-sufficient by using solar, wind and hydro electric power. He enjoys Call of Duty on XBox under the handle XO UEG Barricuda.

John Huang

Twitter: - @sqlnotes

LinkedIn: John Huang

Contact: http://www.sqlnotes.info

John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning.

Nicholas Cain

Contact: http://sirsql.net

Nicholas Cain is a Microsoft Certified Master with over 12 years of enterprise database administration experience. He has worked with all versions of SQL Server since 7.0 in critical highly available production environments. He has not hired dozens of DBAs over the last few years.

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.

John Halunen Aubra Moore

John is a Senior DBA with 8 years working on large Online Reporting and OLTP systems for Microsoft Advertising, Atlas/aQuantive, and thePlatform, all in the online space. Currently he is working at one of the larger video over IP providers (thePlatform), a subsidiary of Comcast. Aubra Moore is currently a DBA with Microsoft Advertising. Manages the primary ETL and reporting systems for Microsoft Adserving’s Media Console systems collecting and Online Reporting systems.

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.

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.

Paul Turley

Twitter: - paul_turley

LinkedIn: Paul Turley

Contact: http://www.sqlserverbiblog.com

Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.

Sopheap Suy

Sopheap Suy is a SQL Server Developer at WebMD with 14 years in SQL Server Database technologies. She enjoys making things run better and faster. She is passionate about SQL Server technologies and always looking for ways to learn and share her knowledge. She is actively involved in her local PASS chapter and her interests include SQL Server Development, Administration, and Data Architecture. She lives in Portland, OR with her husband, and 3 children.

Rick Morelan

Contact: http://www.joes2pros.com/About-Author

use same bio as Redmond workshop.

Ron Talmage

LinkedIn: Ron Talmage

Ron Talmage is database administrator with B3 Group, Inc, on a major healthcare data warehouse. He is also a mentor and co-founder with SolidQ. He is a former SQL Server MVP and chapter leader of the Pacific Northwest SQL Server Users Group. He has authored numerous SQL Server white papers and contributes to SQL Server technical publications.

Toshi Watanabe

Toshi Watanabe currently holds a position of Senior DBA at Gates Foundation. He has been working on diverse database technologies including SQL server since 6.5. The primary focus at the Foundation is EDW (Enterprise Data Warehouse) development and support. He also operates his own database consulting business.

Arie Jones

Twitter: - @programmersedge

LinkedIn: Arie Jones

Contact: http://www.programmersedge.com

Arie Jones (quot;AJquot;) is one of the owners and Vice President of Emerging Technologies for Indy Data Partners, Inc. in Indianapolis, IN. AJ is a frequent speaker at national conferences and local user groups. With over 15 years of experience in application development and database administration on various platforms, he specializes in developing cross-platform solutions with an emphasis on .NET and SQL Server technologies. He blogs extensively at http://www.programmersedge.com.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page