SQLSaturday #12 - Portland 2009
Event Date: 06/06/2009 00:00:00
Event Location:
- Mt. Hood Community College
- 26000 S.E. Stark Street
- Portland, Oregon
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: XML and Relational Databases
Abstract: Well established relational database principles help us decide when and how to use the XML features in SQL Server. The audience will learn what’s missing from the typical understanding of first normal form (“1NF”) and how to apply 1NF to XML related database design choices. If you think (like many DBAs) that XML is a curse or (like some developers) that XML is a cure-all, this presentation is for you. Contrary to typical technology presentations, this focuses on what we should do over just a list of features and syntax.
Speaker(s):
- Eric Wilson
Track and Room: Track 1 - N/A
Title: Understanding SQL Injection (DB Devs and Admins)
Abstract: SQL injection is a term you’ve heard often, but do you really understand what it means for a database developer or administrator? Can’t you just leave that to the application developers to deal with?
This session will help you understand what SQL injection is, why it is a risk for your database, and how to guard against it.
Speaker(s):
- Rob Garrison
Track and Room: Track 2 - N/A
Title: SQL Indexes Implementation in Practice
Abstract: Table index design and implementations have significant impact to the overall database performance and operations. In this session Joshua will take you through simple practical steps for:
-
Identifying Missing Indexes
-
Implementing Clustered Index
-
Optimizing Multiple Non-Clustered Indexes for a Table
-
Capturing Index Usages
During the session, your questions and sharing your experience/knowledge are highly encouraged.
Speaker(s):
- Joshua Jin
Track and Room: Track 2 - N/A
Title: Tips, Tricks and Code on Table/Index Partitioning
Abstract: Partitioning is arguably the key feature needed to manage large SQL Server databases. In this presentation I will briefly review the main concepts of partitioning and then will provide information from actual experience in implementing partitioning, including code, tips and lessons learned. It is primarily focused on SQL 2005, but will include a brief discussion of the enhancements in SQL 2008.
Speaker(s):
- Steve Moss
Track and Room: Track 2 - 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: Sql Server 2008 Compression
Abstract: Improving Performance while reducing storage costs through Compression.
A partial list of items covered are: backup Compression Internals, how to enable Backup Compression, improving Backup Times, reducing Storage I/O and Space, restoring a database with Backup Compression, and what about going to tape?
Speaker(s):
- Ryan Lence
Track and Room: Track 1 - N/A
Title: Performance Tuning with SQL Server 200
Abstract: Buck Woody, Microsoft’s “Real World DBA” will show you how to use the Management Data Warehouse, Data Collector, and the new Activity monitor to fix unit and integration performance issues.
Speaker(s):
- Buck Woody
Track and Room: Track 1 - N/A
Title: High Availability on SQL Server
Abstract: Do you need five 9’s of uptime? High Availability of applications and databases are rapidly becoming the “norm” around the globe. It is clearly one of the hottest topics that is important for database administrators, data architects and system architects to fully understand and to plan for.
This presentation covers assessing, planning, choosing, implementing and administering a high availability solution along with the business justifications of different approaches to achieve high availability (including SQL Clustering, Data Replication, Database Mirroring, and Database Snapshots).
Speaker(s):
- Paul Bertucci
Track and Room: Track 1 - N/A
Title: Bridging the BI Chasm
Abstract: What does and doesn’t work in a BI implementation? Rachel will cover what makes it work –the people skills, how to choose the right tool set and the best practices process for a successful implementation.Learn how to cross the IT-Business User chasm and build a successful career in an exploding field.
Speaker(s):
- Rachel Dyer
Track and Room: Track 2 - N/A
Title: Developing and Designing Super Reports
Abstract: How to create fewer, more capable reports with SQL Server 2008 Reporting Services, using expert patterns and recipes that meet multiple report requirements. Material will be presented from our forthcoming Wiley book: Super Reports – Patterns and Recipes for Reporting Services 2005 and 2008.
Speaker(s):
- Paul Turley
Track and Room: Track 1 - N/A
Title: Implementing a Self-Service Reporting Strategy wit
Abstract: For the IT pro and BI solution architects: How to provide the tools, training and environment to enable your business users to create useful reports. Train your business users to utilize Report Builder 2.0 and Analysis Services to achieve real business value. You will learn how to balance IT production reporting solutions from ad-hoc reporting and then migrate mission-critical prototype reports with the involvement of the user community.
Speaker(s):
- Paul Turley
Track and Room: Track 1 - N/A
Title: Perf Testing 2008’s Transparent Data Encryption
Abstract: Everyone is getting hit with data security requirements. SQL 2005 introduced column-level encryption, but there are drawbacks to using it. The big security news in SQL Server 2008 is Transparent Data Encryption.
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.
How much will TDE affect performance in an OLTP environment? This session will help you understand what TDE offers, discuss the list of caveats, and explain the performance testing and results.
Speaker(s):
- Rob Garrison
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.
Paul Bertucci
Twitter: - @ptbertucci
LinkedIn: Paul Bertucci
Paul Bertucci is the founder of Data by Design, LLC (www.dataxdesign.com – formerly Database Architechs), a global database consulting firm with offices in the United States and Paris, France. Former Chief Architect/Shared Services Director for Autodesk (BI/DW/ODS, Big Data, Identity Management, SOA, Integration (EAI amp; ETL), MDM, Collaboration/Social, SaaS platforms, and Enterprise Architecture). Former Chief Data Architect at Symantec. Author SQL Server Unleashed book series, SQL Server High Availability, and SQL Performance and Tuning. Frequent speaker at Database and MDM conferences around the globe. Formal education: UC. Berkeley, Electrical Engineering and Computer Science.
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.
Rachel Dyer
Rachel Dyer, Vice President of Implementation, joined On Demand Analysis® in 2001. She crosses the IT-User gap by playing a bit of both roles.
Rachel is a graduate of Harvard University and Harvard Business School.
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.
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.
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.
Joshua Jin
Joshua Jin is a frequent speaker at SQL PASS local chapter in Portland, Oregon. He holds MCITP Business Intelligence Developer, Database Administrator, and Database Developer certifications for SQL Server 2005. Joshua is one of contributing authors of “Professional SQL Server 2005 Performance Tuning” book by Wiley/Wrox. At Intel IT, currently he is the development lead of a large SQL BI project for a private Cloud.
Steve Moss
Steve Moss is the Data Architect at Ecova, the total energy and sustainability management company whose sole purpose is to see more, save more and sustain more for our clients.
Steve has been working in IT for over 13 years as a Data Architect, Manager of Database Administration, Sr. DBA and Systems Consultant. He specializes in Microsoft data-centric techologies, including SQL Server, Analysis Services, Integration Services and other associated data technologies.
Eric Wilson
Eric has designed and implemented database-centric software solutions for 14 years in a variety of industries spanning financial, publication, e-commerce, and manufacturing. His passion is how to couple fundamental theory (principles) with pragmatic tradeoffs to achieve the best results. He has been a Developer, a DBA, and a Data Architect, including many years as team lead or manager. He has led both OLTP and DSS projects using SQL Server. In his spare time he is working toward a master’s degre
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.
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.
Ryan Lence
Contact: http://dbtune.net/default.aspx
Ryan Lence works as an independent Senior Database Engineer in Portland, Oregon. Ryan enjoys the challenges associated with designing stable, scalable, and redundant environments that enable businesses and their clients to focus on their primary mission. With over 12 years of Enterprise experience and numerous IT certifications Ryan’s primary focus is SQL 2008. Ryan is currently working towards his MCM in SQL 2008.
Sponsors
The following is a list of sponsors that helped fund the event: