SQL CAT: Lessons Learned Working with MSIT and Microsoft BI to Improve Performance and Productivity
In this session, we will explore a number of new techniques that we have developed to improve the performance of Excel reports against Analysis Services cubes. You will learn how to enrich the BI user experience by utilizing the features of the Excel client with Excel Services. You will discover how combining these technologies enables you to execute complex calculations on powerful servers and to reduce performance penalties related to slow network connections, while still providing the user with the full Excel client experience. This session will include a demonstration of MSIT solution for querying Analysis Services in a worldwide deployment, maximizing performance over slow network connections. In addition, we will explore how MSIT is enabling power users to create and deploy their own highly performant cubes based on IT-approved conformed dimensions and IT-sanctioned fact tables.
Senior Program Manager
Carl is a Senior Program Manager on the SQL Server Customer Advisory Team, and is an Extended Customer Program Manager with the Reporting Services and Integration Services product groups. Carl works closely with internal and external customers to develop solutions and validate SQL Server business intelligence best practices for working with large scale and complex BI solutions. Carl has worked with Microsoft SQL Server for over 13 years as a consultant, mentor, writer, speaker and trainer. Carl has written several SQL Server books and numerous technical white papers, has presented at many SQL Server conferences, and has provided mentoring and consulting services for numerous companies around the world.
Software Developer Engineer
Josh Caplan is currently a developer for MSSales in MSIT. He has worked on building and maintaining some of MSSales’ worldwide BI applications. Some of these applications include consolidated OLAP database processing and Analysis Services load balancing. Before coming to Microsoft, Josh worked as the Database Manager at the Franklin Institute Science Museum in Philadelphia where he built database applications to support the marketing and daily operations of the King Tutankhamen exhibit in 2007. The exhibit drew over 1.3 million people making it the most attended traveling exhibit in the world in 2007 and second most attended traveling exhibit ever in the US. Josh has spoken at SQL Pass 2009 and Tech Ed 2010 about the Analysis Services Load Balancing Solution.
Sr. Technology Architect
Sergei Gundorov, Sr. Technology Architect in MS IT, started developing applications in the Microsoft Office environment in 1991 while working for Proctor & Gamble Russia, using the macro recorder in Microsoft Office Excel. Sergei transitioned to Microsoft Visual Basic for Applications (VBA) two years later. He proceeded to develop business centric programs and applications as a career for the next 19 years transitioning to managed code, SharePoint, ASP.NET, etc... Sergei has worked at Microsoft since April 2003 in Corporate IT. Sergei works closely with the Office team. Throughout his career he wrote several technical papers, presented his work at conferences and built several showcase applications leveraging latest MS technology offerings.
Register Now for PASS Summit 2010!