SQLSaturday #26 - Redmond 2009
Event Date: 10/03/2009 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: Database Mirroring: Maximizing Availability Throug
Abstract: Database Mirroring is often thought of as a “set and forget it” technology. But what happens if there are problems and the one person on your team that knows mirroring inside and out is not there? You can have a prolonged outage or you can be prepared ahead of time and set up automation procedures for all of your database mirroring needs.
This session will cover setting up processes to detect problems with database mirroring and setting up processes to automate the maintenance and disaster recovery tasks for database mirroring. Included in the session will be detecting a single database failure and automatically failing over all mirrored databases in response.
Speaker(s):
- Robert Davis
Track and Room: Track 2 - N/A
Title: Simple Solutions for Vexing T-SQL Problems
Abstract: Several problems that many folks encounter in their daily work, problems that are often difficult to conceptualize, will be discussed and then Arnie will demonstrate how to find a simple solution.
Speaker(s):
- Arnie Rowland
Track and Room: Track 3 - N/A
Title: DBA Basic Checklist
Abstract: Are you new to managing database systems, or are you wondering if you’re covering all of the bases? Come hear Buck Woody, Microsoft’s “Real World DBA” explain a basic checklist for SQL Server, and what each element means. You’ll also see a few examples of how to implement it, and how you can modify it to fit your installation. Part of our “DBA 101” series.
Speaker(s):
- Kalen Delaney
Track and Room: Track 1 - N/A
Title: BI Dashboards in Sql Reporting Services
Abstract: Dashboards are a great way to highlight what is most important to your organization. An interface which brings together data from multiple data sources in a high level format can be a vital tool for decision makers. See how this can be accomplished using tables, charts, and a little bit of code in SQL Reporting Services.
Speaker(s):
- Shalu Goel
Track and Room: Track 3 - N/A
Title: Introduction to SQL Server Integration Services
Abstract: SQL Server Integration Services is Microsoft’s powerful tool for doing ETL (Extract, Transform, and Load) in the Business Intelligence arena. In this introductory course you can get up to speed on the basic tools of ETL and learn how to leverage SSIS not just for BI but for data conversion as well.
Speaker(s):
- Robert Cain
Track and Room: Track 3 - N/A
Title: Exploring SQL 2008’s Transparent Data Encryption
Abstract: On the surface, Transparent Data Encryption seems to be a security “silver bullet”. The most important feature (besides securing the data) is that it does not require any changes to your application code.
This session will explain the basics of TDE and show detailed performance test results. You will leave with an understanding of what it takes to implement TDE and what the cost will likely be. This is a very valuable new feature that you should know about.
Speaker(s):
- Rob Garrison
Track and Room: Track 1 - N/A
Title: Using SQL Trace/Profiler Effectively:
Abstract: This session will cover how to use SQL Trace/Profiler effectively. Topics include converting trace templates into T-SQL scripts, running server side traces (and why you should do so), reading trace files via T-SQL. Demo will include creating a SQL job that detects high CPU utilization and starts and stops a custom SQL trace when CPU utilization crosses a predefined threshold.
Speaker(s):
- Robert Davis
Track and Room: Track 3 - N/A
Title: The SQL Server Resource Governor
Abstract: SQL Server 2008 introduces a new feature called the “Resource Governor”. It allows you to set limits (both minimum and maximum) on your SQL Server Instance’s use of CPU and Memory - helping to prevent runaway queries, shoring up your Service Level Agreements, and aiding in consolidating your SQL Server databases onto fewer Instances or even in Virtualization. Come hear Buck Woody, Microsoft’s “Real World DBA”, present an introduction to this feature, and show you an overiew of it’s functionality and flow.
Speaker(s):
- Buck Woody
Track and Room: Track 1 - N/A
Title: Failover Clustering with Windows Server 2008
Abstract: Forget a good portion of everything you know about clustering - Windows Server 2008 changes the game. Come see how the changes and improvements affect clustered SQL Server deployments. In addition to Windows, both SQL Server 2005 and SQL Server 2008 will also be discussed. The focus will be on SQL Server 2008 and how its changes to the setup, upgrade, and patching processes (among other things) impact the configuration and administration of a clustered SQL Server 2008 instance. Live demos will be shown, and one copy of Allan’s new book, Pro SQL Server 2008 Failover Clustering, will be given away.
Speaker(s):
- Allan Hirt
Track and Room: Track 1 - N/A
Title: Hacking SQL / SQL Injection
Abstract: Recently there has been an increase in reported SQL Injection attacks using web applications. We will discuss and demonstrate how hackers will attack a database using a web application. The methods demonstrated are freely available on the internet, and require very little skill. We will also discuss ‘hardening’ the database in order to protect against most attacks. The discussion will include: How to ‘Think like a hacker’; The What/How of SQL Injection; Protecting against SQL injection; How to use SQL Server security to limit risk; Protecting your data; Monitoring database activities with minimal performance impact.
Speaker(s):
- Arnie Rowland
Track and Room: Track 2 - N/A
Title: Introduction to Data Warehousing / BI
Abstract: Business Intelligence is one of the hot job skills for 2009. In this concepts talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean. You’ll also get a peak at the tools available in SQL Server 2008.
Speaker(s):
- Robert Cain
Track and Room: Track 3 - N/A
Title: Exploring SQL Server Column-Level Encryption
Abstract: SQL Server 2005 and 2008 support column-level data encryption in many ways. We will start with some of the basics and quickly move to how to use Encrypt/DecryptByKey and ByCert.
This session will include significant information that is not available in Books Online. It will also discuss Message Authentication Codes and how to use them to support efficient searches of encrypted data.
Speaker(s):
- Rob Garrison
Track and Room: Track 1 - N/A
Title: T-SQL Best Practices
Abstract: This session will cover T-SQL coding best practices. The basics on how to code T-SQL statements to optimize your queries will be covered. In this session you will discover some of the common pitfalls that can cause T-SQL statements to run slow. A number of demos will be done to show how by making slight changes in your code will minimize the resources used to process your queries. From this session you will be able to take home a list of T-SQL coding guidelines to help your code more efficient T-SQL statements.
Speaker(s):
- Greg Larsen
Track and Room: Track 2 - N/A
Title: PowerShell for the Data Professional
Abstract: Learning PowerShell is a must for all Data Professionals. As the world of databases becomes more complex to manage and design solutions for, PowerShell is an essential tool to enable processes that were highly convoluted prior to its inception. Come learn about how to implement PowerShell using beginner to intermediate examples to manage your environment and help ease some of the stress and strain from your every day.
Speaker(s):
- Don Watters
Track and Room: Track 1 - N/A
Title: Table Partitioning Scenarios
Abstract: This session will cover various scenarios for implementing table partitioning, along with anlysis of pro’s and con’s for each. We will start with a brief review of table partitioning basics.
Speaker(s):
- Ron Talmage
Track and Room: Track 2 - N/A
Title: SQL Server Full Text Searching - An Introduction
Abstract: Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it’s as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server.
Speaker(s):
- Robert Cain
Track and Room: Track 2 - N/A
Title: Asynchronous T-SQL processing
Abstract: Many times an application needs to launch into execution a T-SQL script, but it is not interested in waiting until the script is finished. Traditionally such a task would be accomplished using a SQL Agent job. I will present an approach that leverages SQL Service Broker Activation mechanism and go over the advantages and disadvantages of this alternative.
Speaker(s):
- Remus Rusanu
Track and Room: Track 2 - 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.
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.
Arnie Rowland
Twitter: - @ArnieRowland
LinkedIn: Arnie Rowland
Contact: http://sqlblog.com/blogs/arnie_rowland/
Arnie long ago realized that most issues between Developer and DBA comes from incomplete communication and a misunderstanding of each other’s objectives. He is a frequent Trainer and Mentor for Developers and DBAs, bringing both sets of skills to better communicate with teams to create a working solution. For over a decade, Arnie has been a SQL Server MVP, Certified Trainer, technical editor for several publishers, including MOC, and has served as University and Community College adjunct faculty. Clients include Fortune 500 and Multi-Nationals, Federal and State agencies, Foreign governments, and local enterprises –both public and private.
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.
Rob Garrison
Contact: http://persistencevision.blogspot.com/
Rob is a Data Architect working for Fiserv in Portland, Oregon. He has over twenty years of IT experience, with most of that time focused on transactional SQL Server. He has a number of articles published and speaks regularly at user groups and other events.
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
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.
Don Watters
Contact: http://www.sqlsaturday.com
Don Watters is a Group Architect for Data Services at MySpace and lives in Seattle, Washington. He has been working on Microsoft SQL Server products since version 6.5 and has over 11 years of experience with the product. He has extensive administrative and developer experience with large OLTP and OLAP systems and enjoys learning and applying his knowledge to new and interesting database challenges including implementing Massively Parallel Processing (MPP) data warehouses.
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
Shalu Goel
Shalu Goel is a Reporting Analyst for F5 Networks based in Seattle, Washington. She has 10 years of experience with Microsoft SQL Server databases, and has developed in SQL Server Reporting Services since it was known as Rosetta. She has experience with bringing data from disparate systems together to provide meaningful high level and detailed reporting.
Arnie Rowland
Twitter: - @ArnieRowland
LinkedIn: Arnie Rowland
Contact: http://sqlblog.com/blogs/arnie_rowland/
Arnie long ago realized that most issues between Developer and DBA comes from incomplete communication and a misunderstanding of each other’s objectives. He is a frequent Trainer and Mentor for Developers and DBAs, bringing both sets of skills to better communicate with teams to create a working solution. For over a decade, Arnie has been a SQL Server MVP, Certified Trainer, technical editor for several publishers, including MOC, and has served as University and Community College adjunct faculty. Clients include Fortune 500 and Multi-Nationals, Federal and State agencies, Foreign governments, and local enterprises –both public and private.
Robert Cain
Twitter: - https://twitter.com/arcanecode
LinkedIn: Robert Cain
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
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.
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.
Allan Hirt
Twitter: - SQLHA
LinkedIn: Allan Hirt
Contact: http://www.sqlha.com/blog
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.
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.
Rob Garrison
Contact: http://persistencevision.blogspot.com/
Rob is a Data Architect working for Fiserv in Portland, Oregon. He has over twenty years of IT experience, with most of that time focused on transactional SQL Server. He has a number of articles published and speaks regularly at user groups and other events.
Sponsors
The following is a list of sponsors that helped fund the event: