August 2010 – Technical Rollup Mail – SQL Server
News
SQL 2008 R2
Leading Research Firm Gartner, Inc. Publishes Two Important Notes on Microsoft PowerPivot
If you haven’t already tried out PowerPivot, or if you need a little help educating your IT department on SQL Server 2008 R2, Office 2010 and SharePoint 2010, check out these two reports from leading research firm, Gartner, Inc. These important notes highlight the value of PowerPivot and how IT should prepare for and position PowerPivot. They also offer best practices based on real-world customer scenarios and feedback for building business intelligence (BI) and performance management architecture.
PivotViewer extension for SQL Server Reporting Services
Microsoft has recently released a new Silverlight control called PivotViewer. This new control helps us to make better use of the growing amounts of information around us by visualizing thousands of things at once in a way that reveals the relationships which connect them. At the heart of the PivotViewer control are "Collections." They combine large groups of similar items, so we can begin viewing the relationships between individual pieces of information in a new way. By visualizing hidden patterns, PivotViewer enables users to discover and act on new insights.
PowerPivot & Analysis Services – The Value of Both
As Microsoft PowerPivot is gaining more popularity and exposure, BI professionals ask more and more questions about PowerPivot’s role in the organization in trying to understand what value the new in-memory BI solution from Microsoft brings, along with the benefits and the limitations of it. Is PowerPivot going to replace SQL Server Analysis Services? If so, how soon? What should be done with the existing BI solution? Or maybe both can coexist and serve different needs?
Other
https://blogs.technet.com/trm/default.aspx
Documents
SQL 2008
Microsoft SQL Server Protocol Documentation
The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in Microsoft SQL Server 2008.
Events/Webcasts
Business Insights Webcast: The Value of Business Intelligence with SQL 2008 R2, Office 2010 and SharePoint 2010 (Level 100)
In a challenging economic environment, businesses must be even more agile and responsive to changes in the marketplace. From the chief executive to the marketing analyst, users need relevant information at their fingertips.ta from disparate sources and make informed business decisions that position the company for success. Users also want to use the same tools to support BI, communications, content management, collaboration, and search and want all these tools be accessible via their PC, phone, browser, or whatever device they choose. During this session, we explain how you can use Microsoft business intelligence (BI) solutions—specifically SQL Server 2008 R2, Office 2010, and SharePoint 2010—to empower your users, improve organization effectiveness, and increase IT efficiency. Presenter: Mike Thomsen, Senior Product Manager, Microsoft Corporation Mike Thomsen has worked for Microsoft since 2006 and is responsible for driving Business Intelligence (BI) marketing in the U.S. His primary focus is on driving awareness of Microsoft’s BI stack and the understanding among customers that they often already own the software necessary for exceptional BI analysis, reporting & collaboration. Prior to this role, Mike drove Microsoft Visual Studio partner marketing in the US and provided guidance on global partner strategy. Mike has an MBA in Marketing and Bachelors in Journalism. Prior to working at Microsoft, he spent 7 years at CA (Computer Associates) as a Partner Account Manager and Sales Executive. If you have questions or feedback, contact us. In addition to Business Insights webcasts, Microsoft offers a complimentary e-newsletter with real-world examples of how to align IT with your business strategy. You get tips and techniques on using Microsoft technologies and straight talk about solutions that work for mid-sized businesses. If you would like to receive the Business Insights newsletter, click here. Regardless of any contact preferences you might have previously made on this Microsoft site or on other Microsoft sites or services, by registering for this webcast or virtual lab, you consent and agree to allow Microsoft or one of its third-party agents to contact you no more than three (3) instances for the purpose of soliciting feedback on the webcast or virtual lab or to supply you with special discounts and offers related to products and services presented in the webcast or virtual lab. Any other use of the personal information in your Microsoft Passport profile is subject to the Microsoft Privacy Statement. You can learn more about the privacy and security of Microsoft Passport Network at www.Passport.net
8/12/2010 11:00 AM Pacific Time (US & Canada)- 8/12/2010 12:00 PM | Duration:60 Minutes