Tuesday, 21 November 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
SQL Server Enterprise Architectural Summit (SEAS) 2008
Author: Jeff Wharton Date Posted: 20/02/2008 11:10:25 PM
Pre-registration for the event can be made through the Tech-Ed site


http://www.microsoft.com.au/teched/pricing_add_ons.aspx
http://www.microsoft.com.au/teched/ .

NB: SEAS is a 2 day event

When: Mon 1st & Tue 2nd Sept 08. Preceeding Tech-Ed Australia, 3-5th Sept (same venue)
Cost: $550 (inc GST) if combined with Tech-Ed Attendance, $1099 if not.

What is it?

The SQL Server Enterprise Architect Summit is a 2-day intensive course designed for experienced SQL DBA’s. The Microsoft Customer Advisory Team are part of the SQL Development team in Redmond. They assist with the deployments and tuning of some of the largest deployments of SQL Server 100+TB, most complex implementations and take those lessons back to become enhancements for future products. Benefit from hearing first hand from experts in the Microsoft Customer Advisory team as they deliver best practices, real world experience, design and deployment of SQL Server enterprise solutions/systems on the SQL 2005 platform and 2008 platforms.

SQL Server Customer Advisory Team
• Works on largest, most complex SQL Server projects worldwide
+ US: NASDAQ, USDA, Verizon, Raymond James…
+ Europe: London Stock Exchange, Barclay’s Capital
+ Asia and Pacific: Korea Telecom, Western Digital, Japan Railways East
+ ISVs: SAP, Siebel, Sharepoint, GE Healthcare
• Drives product requirements back into SQL Server from our customers and ISVs
• Shares best practices with SQL Server community
+ http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx
+ http://blogs.msdn.com/sqlcat
+ http://blogs.msdn.com/mssqlisv
+ http://sqlcat.com/Default.aspx – technical notes and case studies
.
Agenda
(Subject to change without notice. While most of the material is based on extensive deployments of SQL Server 2005, the sessions will be extended to cover lessons learnt from early adopter deployments on SQL Server 2008 )

Day 1:

Session 1: Partial Database Availability
• Overview of Partial Database Availability
• Typical Uses
• Design Considerations
• Recovery Methods

Session 2: SQL Server 2005 and I/O Subsystem Best Practices
• Always On Technologies
• SQLIO basics and IO characteristics
• General storage configuration best practices
• Performance
• General
• RAID Level
• Storage Design
• Number of Data Files and Filegroups
• Creating Partitions
• Configuration
• Isolation
• Managing Growth
• Failover Clustering Considerations
• Data Compression
• Remote Mirroring
• Monitoring and Base-lining I/O Subsystems
• Storage enhancements in SQL 2005 as related to I/O

Session 3: Building High Performance SQL Server Systems
• Real World Lessons Learned
• Optimizations using Lessons Learned:
o Optimizing Connection Resources
o Optimizing Memory
o Optimizing I/O
o Optimizing CPU
o Optimizing Stored Procedure Calls
o Optimizing Indexes

Session 4: Building High Available SQL Server Systems
• Positioning of Technologies
• Deployment Scenarios & Best Practices
o Database Mirroring Deployments
o Log Shipping Deployment leveraging 3rd Party Technology
o Additional Deployment Scenarios

Session 5: Design for Scalable and Highly Available OLTP Systems
• Design for Scalability
o Scale-up vs. Scale-out
o Basic design techniques
? Loosely coupled design
? Transaction decomposition
? Workload partitioning
o Lessons learned and best practices
o Transaction log throughput
o High Volume OLTP Design
• Design for Availability
o High-availability stack
o Component & system availability
o Failure and data corruption
o Design techniques
• Customer Case Studies


Day 2:

Session 1: Design, Building & Maintaining large cubes using Lessons Learned
• Design: Dimensions, Cubes & Aggregations
o Slowly changing and large dimensions
o Using partitions
o Designing Aggregations
• Build
o Scalability – Processing
? ProcessFull vs ProcessData & ProcessIndexes
o Scalability – Queries
? Scale up vs. Scale out
o Scalability options for multi-user queries
? Multiuser scalability
? Troubleshooting Performance Issues
o Best Practices
• Maintain
o Backup and Restore Strategies
o Planning for possible cube rebuild
• Monitor
o What to Monitor, What tools to Use? What to look for.


Session 2: Building & Deploying Large Scale SSRS using Lessons Learned from Customer Deployments
• Common Implementation mistakes & how to avoid them.
• Big Customer Scenario’s
• Scaling Out: What are the options & which should you try first.
• Performance Optimization
• Troubleshooting

Session 3: SQL Server 2005 Large-

Venue: Sydney Convention Centre, Darling Harbour, Sydney | Duration 2 Days | On: Monday, 1 September 2008