sqlsathistory

Nr: 12

Back to Main list

SQLSaturday #12 - Portland 2009

Start Time (24h) Speaker Track Title
00:00:00 Buck Woody Track 1 Performance Tuning with SQL Server 200
00:00:00 Eric Wilson Track 1 XML and Relational Databases
00:00:00 Greg Larsen Track 2 T-SQL Best Practices
00:00:00 Joshua Jin Track 2 SQL Indexes Implementation in Practice
00:00:00 Paul Turley Track 1 Developing and Designing Super Reports
00:00:00 Paul Turley Track 1 Implementing a Self-Service Reporting Strategy wit
00:00:00 Paul Bertucci Track 1 High Availability on SQL Server
00:00:00 Rachel Dyer Track 2 Bridging the BI Chasm
00:00:00 Rob Garrison Track 2 Perf Testing 2008’s Transparent Data Encryption
00:00:00 Rob Garrison Track 2 Understanding SQL Injection (DB Devs and Admins)
00:00:00 Ryan Lence Track 1 Sql Server 2008 Compression
00:00:00 Steve Moss Track 2 Tips, Tricks and Code on Table/Index Partitioning

SessionID: 35048

Performance Tuning with SQL Server 200

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 1

Speaker: Buck Woody

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.

SessionID: 35110

XML and Relational Databases

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 1

Speaker: Eric Wilson

Title: XML and Relational Databases

Abstract:

SessionID: 35128

T-SQL Best Practices

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 2

Speaker: Greg Larsen

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.

SessionID: 35236

SQL Indexes Implementation in Practice

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 2

Speaker: Joshua Jin

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:

During the session, your questions and sharing your experience/knowledge are highly encouraged.

SessionID: 35344

Developing and Designing Super Reports

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 1

Speaker: Paul Turley

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.

SessionID: 35345

Implementing a Self-Service Reporting Strategy wit

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 1

Speaker: Paul Turley

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.

SessionID: 35346

High Availability on SQL Server

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 1

Speaker: Paul Bertucci

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

SessionID: 35385

Bridging the BI Chasm

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 2

Speaker: Rachel Dyer

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.

SessionID: 35396

Perf Testing 2008’s Transparent Data Encryption

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 2

Speaker: Rob Garrison

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.

SessionID: 35397

Understanding SQL Injection (DB Devs and Admins)

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 2

Speaker: Rob Garrison

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.

SessionID: 35414

Sql Server 2008 Compression

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 1

Speaker: Ryan Lence

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?

SessionID: 35443

Tips, Tricks and Code on Table/Index Partitioning

Back to calendar

Event Date: 06-06-2009 - Session time: 00:00:00 - Track: Track 2

Speaker: Steve Moss

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.