| Time | Description | Abstract | Bio |
| Attendee Check-In and Breakfast | | |
| 9:00am - 9:15am | Welcome | | |
| 9:15am - 10:15am | Stress Testing SQL Server - Hilary Cotter/ MVP | How do you get the most bang for your buck from SQL Server? In this session Hilary Cotter will show you how determine what the current bottlenecks are on your SQL Server, and how to discover how your SQL Server will respond as your application scales. Take aways from this session are tools to help you with performance tuning and stress testing your SQL Server a methodology for tuning and stress testing your SQL Server workloads, and best practices for performance tuning and stress testing. | Hilary Cotter is a SQL Server MVP with over 20 years of IT experience. He is a guru in replication, full text search, and performance tuning. He has answered over 17,000 questions on the Microsoft newsgroups, some of them correctly. |
| 10:15am - 10:30am | Break | | |
| 10:30am - 11:30am | Query Plan Optimization / T-SQL Performance Tricks - Alec Lazarescu | You've methodically narrowed down your performance problems to a few particular queries, but where do you go from here? We'll dive into query plans and go over some ways to find potential trouble spots at a glance as well as use a few helper procedures to do analysis. Many T-SQL equivalent rewriting techniques will be explored that can have often surprisingly differing performance characteristics. The SQL optimizer has grown extremely complicated and is influenced by an incredible number of variables so, as always, the effectiveness of each technique will vary, but you will likely find a few techniques that will come in handy at some point. In addition you'll hopefully gain an appreciation for the value of creativity and experimentation for query optimization. | Alec has been a DBA/developer for over 12 years starting with Access 95 and moving to SQL Server 6.5 and has experienced firsthand the evolution of every SQL Server release since then. His current priority is a terabyte class clustered SQL Server 2005 database and the ASP.Net web site that drives it. He spends much of his time on performance tuning, troubleshooting, automation, best practices guidelines, and thinking about interesting discoveries that he should probably blog about, but never seems to have the time to. |
| 11:30am - 12:15pm | Lunch, Vendor Presentation & IPOD Raffle - Duane Johnson –Storage Architect and Solutions Ambassador (FalconStor) | The talk will be focused on how to: Reduce overall storage costs for SQL, Optimize I/O Performance, Rapidly provide thin current copies to simplify and speed testing and development, Recover databases in 15 min or less no matter the size, Provide a simple way to protect from deletion and corruption, Replicate large datasets with minimal WAN bandwidth via "No-Dupe", Leverage CDP to protect every write, even when logging is disabled | Duane’s experience in the computer industry cover a multitude of areas including running his own technology company for 16 years servicing SMB and Enterprise accounts across the country. As a subject matter expert in multi-protocol switching technology and physical plant interconnections, Duane has been tasked to write a number of Professional Certification Exams for IBM and was the Chief Architect for the infrastructure used for the 1998 Nagano Olympics “Fan Mail” project which continues to be transformed every two years to cover both Summer and Winter Olympic Events. After joining FalconStor Software in 2005 , he spent two years maintaining the Enterprise Testing Labs at FalconStor HQ in Melville, LI and worked closely with Quality Assurance to establish testing process for testing of CDP, VTL and SIR, he now supports Sales in the Northeast as a trusted Storage Architect. |
| 12:15pm - 1:15pm | Performance tuning XML and XQuery in SQL Server 2008 - Michael Coles/ MVP | Get the most out of your SQL Server XML and XQuery-based applications. Tips and tricks to speed up server-side XQuery and XML manipulation on SQL Server. Focus on XML shredding, XQuery path language, XML indexes, and converting relational data to XML. | Michael Coles is a SQL developer and database architect with 15 years experience. He works for a BI consulting firm in NYC and is the author of Pro T-SQL 2008 Programmer's Guide and Pro SQL Server 2008 XML. Michael has been recognized as a Microsoft MVP for his work on SQL Server. |
| 1:15pm - 2:15pm | Disk I/O Related Performance Tuning -Linchi Shea/ MVP | | Linchi Shea has been working with Microsoft SQL Server since version 4.2. He is currently responsible for SQL Server engineering at a major Wall Street firm in the New York City area. Linchi is passionate about creating robust and automated infrastructures for managing SQL Server in a large enterprise environment. He has written many tools and utilities to simplify deploying, operating, and testing SQL Server. You can find him blogging about SQL Server enterprise issues at www.sqlblog.com. Linchi is a co-founder and co-lead of the NY Metro SQL Server users group, and has been a Microsoft MVP since 2002. |
| 2:30pm - 2:45pm |
Wrap-Up and Raffle/Swag | Microsoft, FalconStor, Edgewood Solutions, PASS, Idera
| |
Attendee Check-In and Breakfast | | | | 9:00am - 9:15am | Welcome | | |
| 9:15am - 10:15am | Stress Testing SQL Server - Hilary Cotter/ MVP | How do you get the most bang for your buck from SQL Server? In this session Hilary Cotter will show you how determine what the current bottlenecks are on your SQL Server, and how to discover how your SQL Server will respond as your application scales. Take aways from this session are tools to help you with performance tuning and stress testing your SQL Server a methodology for tuning and stress testing your SQL Server workloads, and best practices for performance tuning and stress testing. | Hilary Cotter is a SQL Server MVP with over 20 years of IT experience. He is a guru in replication, full text search, and performance tuning. He has answered over 17,000 questions on the Microsoft newsgroups, some of them correctly. |
| 10:15am - 10:30am | Break | | |
| 10:30am - 11:30am | Query Plan Optimization / T-SQL Performance Tricks - Alec Lazarescu | You've methodically narrowed down your performance problems to a few particular queries, but where do you go from here? We'll dive into query plans and go over some ways to find potential trouble spots at a glance as well as use a few helper procedures to do analysis. Many T-SQL equivalent rewriting techniques will be explored that can have often surprisingly differing performance characteristics. The SQL optimizer has grown extremely complicated and is influenced by an incredible number of variables so, as always, the effectiveness of each technique will vary, but you will likely find a few techniques that will come in handy at some point. In addition you'll hopefully gain an appreciation for the value of creativity and experimentation for query optimization. | Alec has been a DBA/developer for over 12 years starting with Access 95 and moving to SQL Server 6.5 and has experienced firsthand the evolution of every SQL Server release since then. His current priority is a terabyte class clustered SQL Server 2005 database and the ASP.Net web site that drives it. He spends much of his time on performance tuning, troubleshooting, automation, best practices guidelines, and thinking about interesting discoveries that he should probably blog about, but never seems to have the time to. |
| 11:30am - 12:15pm | Lunch, Vendor Presentation & IPOD Raffle - Duane Johnson –Storage Architect and Solutions Ambassador (FalconStor) | The talk will be focused on how to: Reduce overall storage costs for SQL, Optimize I/O Performance, Rapidly provide thin current copies to simplify and speed testing and development, Recover databases in 15 min or less no matter the size, Provide a simple way to protect from deletion and corruption, Replicate large datasets with minimal WAN bandwidth via "No-Dupe", Leverage CDP to protect every write, even when logging is disabled | Duane’s experience in the computer industry cover a multitude of areas including running his own technology company for 16 years servicing SMB and Enterprise accounts across the country. As a subject matter expert in multi-protocol switching technology and physical plant interconnections, Duane has been tasked to write a number of Professional Certification Exams for IBM and was the Chief Architect for the infrastructure used for the 1998 Nagano Olympics “Fan Mail” project which continues to be transformed every two years to cover both Summer and Winter Olympic Events. After joining FalconStor Software in 2005 , he spent two years maintaining the Enterprise Testing Labs at FalconStor HQ in Melville, LI and worked closely with Quality Assurance to establish testing process for testing of CDP, VTL and SIR, he now supports Sales in the Northeast as a trusted Storage Architect. |
| 12:15pm - 1:15pm | Performance tuning XML and XQuery in SQL Server 2008 - Michael Coles/ MVP | Get the most out of your SQL Server XML and XQuery-based applications. Tips and tricks to speed up server-side XQuery and XML manipulation on SQL Server. Focus on XML shredding, XQuery path language, XML indexes, and converting relational data to XML. | Michael Coles is a SQL developer and database architect with 15 years experience. He works for a BI consulting firm in NYC and is the author of Pro T-SQL 2008 Programmer's Guide and Pro SQL Server 2008 XML. Michael has been recognized as a Microsoft MVP for his work on SQL Server. |
| 1:15pm - 2:15pm | Disk I/O Related Performance Tuning -Linchi Shea/ MVP | | Linchi Shea has been working with Microsoft SQL Server since version 4.2. He is currently responsible for SQL Server engineering at a major Wall Street firm in the New York City area. Linchi is passionate about creating robust and automated infrastructures for managing SQL Server in a large enterprise environment. He has written many tools and utilities to simplify deploying, operating, and testing SQL Server. You can find him blogging about SQL Server enterprise issues at www.sqlblog.com. Linchi is a co-founder and co-lead of the NY Metro SQL Server users group, and has been a Microsoft MVP since 2002. |
| 2:30pm - 2:45pm |
Wrap-Up and Raffle/Swag | Microsoft, FalconStor, Edgewood Solutions, PASS, Idera
| |
| Attendee Check-In and Breakfast | | |
| 9:00am - 9:15am | Welcome | | |
| 9:15am - 10:15am | Stress Testing SQL Server - Hilary Cotter/ MVP | How do you get the most bang for your buck from SQL Server? In this session Hilary Cotter will show you how determine what the current bottlenecks are on your SQL Server, and how to discover how your SQL Server will respond as your application scales. Take aways from this session are tools to help you with performance tuning and stress testing your SQL Server a methodology for tuning and stress testing your SQL Server workloads, and best practices for performance tuning and stress testing. | Hilary Cotter is a SQL Server MVP with over 20 years of IT experience. He is a guru in replication, full text search, and performance tuning. He has answered over 17,000 questions on the Microsoft newsgroups, some of them correctly. |
| 10:15am - 10:30am | Break | | |
| 10:30am - 11:30am | Query Plan Optimization / T-SQL Performance Tricks - Alec Lazarescu | You've methodically narrowed down your performance problems to a few particular queries, but where do you go from here? We'll dive into query plans and go over some ways to find potential trouble spots at a glance as well as use a few helper procedures to do analysis. Many T-SQL equivalent rewriting techniques will be explored that can have often surprisingly differing performance characteristics. The SQL optimizer has grown extremely complicated and is influenced by an incredible number of variables so, as always, the effectiveness of each technique will vary, but you will likely find a few techniques that will come in handy at some point. In addition you'll hopefully gain an appreciation for the value of creativity and experimentation for query optimization. | Alec has been a DBA/developer for over 12 years starting with Access 95 and moving to SQL Server 6.5 and has experienced firsthand the evolution of every SQL Server release since then. His current priority is a terabyte class clustered SQL Server 2005 database and the ASP.Net web site that drives it. He spends much of his time on performance tuning, troubleshooting, automation, best practices guidelines, and thinking about interesting discoveries that he should probably blog about, but never seems to have the time to. |
| 11:30am - 12:15pm | Lunch, Vendor Presentation & IPOD Raffle - Duane Johnson –Storage Architect and Solutions Ambassador (FalconStor) | The talk will be focused on how to: Reduce overall storage costs for SQL, Optimize I/O Performance, Rapidly provide thin current copies to simplify and speed testing and development, Recover databases in 15 min or less no matter the size, Provide a simple way to protect from deletion and corruption, Replicate large datasets with minimal WAN bandwidth via "No-Dupe", Leverage CDP to protect every write, even when logging is disabled | Duane’s experience in the computer industry cover a multitude of areas including running his own technology company for 16 years servicing SMB and Enterprise accounts across the country. As a subject matter expert in multi-protocol switching technology and physical plant interconnections, Duane has been tasked to write a number of Professional Certification Exams for IBM and was the Chief Architect for the infrastructure used for the 1998 Nagano Olympics “Fan Mail” project which continues to be transformed every two years to cover both Summer and Winter Olympic Events. After joining FalconStor Software in 2005 , he spent two years maintaining the Enterprise Testing Labs at FalconStor HQ in Melville, LI and worked closely with Quality Assurance to establish testing process for testing of CDP, VTL and SIR, he now supports Sales in the Northeast as a trusted Storage Architect. |
| 12:15pm - 1:15pm | Performance tuning XML and XQuery in SQL Server 2008 - Michael Coles/ MVP | Get the most out of your SQL Server XML and XQuery-based applications. Tips and tricks to speed up server-side XQuery and XML manipulation on SQL Server. Focus on XML shredding, XQuery path language, XML indexes, and converting relational data to XML. | Michael Coles is a SQL developer and database architect with 15 years experience. He works for a BI consulting firm in NYC and is the author of Pro T-SQL 2008 Programmer's Guide and Pro SQL Server 2008 XML. Michael has been recognized as a Microsoft MVP for his work on SQL Server. |
| 1:15pm - 2:15pm | Disk I/O Related Performance Tuning -Linchi Shea/ MVP | | Linchi Shea has been working with Microsoft SQL Server since version 4.2. He is currently responsible for SQL Server engineering at a major Wall Street firm in the New York City area. Linchi is passionate about creating robust and automated infrastructures for managing SQL Server in a large enterprise environment. He has written many tools and utilities to simplify deploying, operating, and testing SQL Server. You can find him blogging about SQL Server enterprise issues at www.sqlblog.com. Linchi is a co-founder and co-lead of the NY Metro SQL Server users group, and has been a Microsoft MVP since 2002. |
| 2:30pm - 2:45pm |
Wrap-Up and Raffle/Swag | Microsoft, FalconStor, Edgewood Solutions, PASS, Idera
| |
| |