Scalability Experts (my employer) is providing several high-value presentations in the coming months on a variety of hot SQL Server topics. First are the ‘Road Show’ events we are delivering in partnership with SQL Server Magazine. In addition, we are delivering four online presentations again in conjunction with SQL Server Magazine on business intelligence topics with the keynote being delivered by Andrew Sisson, our BI Director. Finally, are the SQL Server Momentum events we are taking part in.

SQL Server Magazine Road Show

SQL Magazine is putting on a Road Show, with SE as the featured act. Note the Dates and Locations of the stops on the tour. At each stop there will be two SE presenters, one for OTLP and the other for BI. There will be a Keynote address, plus three presentation sessions at each stop.

Dec 2 – San Francisco - Raj Gill and Andrew Sisson

Dec 4 – Chicago - Don Vilen and Jim Leisring

Dec 9 – Atlanta - Joe Yong and Jim Leisring

Dec 11 – Philadelphia - Joe Yong and Andrew Sisson

Keynote – Managing Data in Your Environment In the next 5 years, we will store more than twice the data that we have stored since the beginning of the computer age. Managing this data and turning it into useful information will be the key to survival and success for every organization. Traditional applications and architectures continue to play their important roles in supporting current businesses but newer approaches and standards such as consolidation, virtualization and true scale-as-you-grow architectures are rapidly becoming the norm as businesses evolve. Find out more about how Microsoft’s recent release of SQL Server 2008 positions your organization for success by improving your ability to address current needs while getting your organization ready to adopt newer and/or alternate architectures when your business demands it.

Session 1 - Upgrading to SQL Server 2008 With the release of SQL Server 2008, your organization can benefit from many new features. But, how do you get there? What are the pitfalls that you need to watch out for? What tools and techniques are available that will help you in this effort? What will it take to Upgrade to SQL Server 2008? Will I encounter compatibility or performance problems? If so how do I mitigate the risks or solve those problems? These questions will be addressed for upgrades from SQL Server 2000 and SQL Server 2005 along with best practices collected from hundreds of upgrades performed around the world. The focus of this session will be the relational engine.

Session 2 – HA and DR in the SQL Server 2008 World As users and businesses become more dependent on instantly and constantly available access to critical information, service level agreements for High Availability and Disaster Recovery become increasingly demanding with no end in sight while IT budgets remain the same or reduced. Consolidated systems further add to the pressure as IT departments are asked to do more with less but are still expected to manage the same or higher levels of business criticality. Find out how the enhancements in SQL Server 2008 help you accomplish your goals while working within your constraints in staff and budgets.

Session 3 – SQL Server 2008 Business Intelligence Microsoft SQL Server 2008 offers a complete foundation of Business Intelligence with scalable, enterprise ready data warehousing. The feature rich functionality of the 2008 platform puts timely and mission critical information in hands of your organization. Unlock the hidden knowledge embedded in your applications and gain amazing insight and vision to your data to expand your competitive advantage.

SQL Server 2008 gives you the ability to:

• Build Enterprise data warehouse and data marts with immense scalability and performance – with SQL Server 2008 Relational Database

• Quickly Extract, Transform, Cleanse, and Load from multiple sources —with SQL Server 2008 Integration Services.

• Provide Deep and Complex Data Analytics —with SQL Server 2008 Analysis Services.

• Author, deliver, and deploy enterprise class reporting—with SQL Server 2008 Reporting Services.

More importantly, SQL Server 2008 allows you to accomplish all this without consuming your entire IT budget and does not require that your staff attend months of training to deploy and manage these solutions effectively. With up to 87% of all BI projects rated as failures or not meeting objectives, find out how you can be in the other 13% and how SQL Server 2008 helps you get there. If you're already taking advantage of the Microsoft SQL Server suite of BI tools in prior versions, learn how to maximize the new features of 2008 with optimized star-query joins, merge, tablix, CDC, lookup and pipeline performance, and numerous other improvements.

SQL Server Magazine Online BI Presentations

Keynote: Enabling Enterprise BI on the Microsoft SQL Server BI Stack – Presenter: Andrew Sisson With the nature of business today, many organizations have not had the time or the reason to upgrade their SQL Server systems, but even with that being the case there are numerous ways to take advantage of the power OLAP and BI functionality in many versions used today. Through each version Reporting Services, Integration Services (or DTS), and Analysis Services are used to build a solid BI and data warehouse foundation. With each new version’s release there are key components and specific functionality you can use in your environments to expand the scalability and usability of your BI infrastructure. Learn when, where, and how to implement them today.

Session 1: Best Practices for a Successful BI Implementation – Presenter: Ajay Goyal The Best Practices for Data Warehouse design and implementation will be covered. Learn the best approach for designing and deploying your data warehouse solution with the Microsoft BI suite of tools. There are many traps to avoid when implementing an end-to-end BI solution and following these best practices will help navigate project killing pitfalls. The data warehouse is the foundation to your enterprise BI solution and building it correctly will have a significant impact on your over all BI strategy and success.

Session 2: Must Use Features of the Microsoft BI Stack – Presenter: Jim Leisring Microsoft SQL Server delivers enterprise BI out of the box. Learn the key features and differences of SQL Server, SSIS (DTS), SSAS, and SSRS available in 2000, 2005 and 2008 to bring your BI initiatives to the next level of usability. SQL Server 2000 is a powerhouse of BI functionality but SQL Server 2005 offers a paradigm shift in the usability and scalability of the BI stack and 2008 continues on that tradition with numerous features such as tablix, report builders, star joint query optimization, CDC, optimized ETL, aggregation designer, and many other improvements.

Session 3: Enabling Pervasive BI with SharePoint Integration – Presenter: Derek Comingore SharePoint is one of the fastest growing portal technologies on the market. Learn how to integrate your BI initiatives with SharePoint and take advantage of Pervasive BI with comprehensive collaboration, publishing, and dashboard solutions. With a centralized portal technology for your enterprise-wide BI content and tools, your entire organization can view and interact with relevant reports, KPIs, and analytic views.

SQL Server Momentum Events (MSFT SQL Server 2008 Road Show)

http://technet.microsoft.com/en-us/cc984277.aspx