Sheila Molnar is a former executive editor, developer content, for SQL Server Pro, DevConnections, System iNEWS, and SharePointPro Connections. Formerly, she managed SDK and IT pro content teams at Microsoft.
Ten years ago, Microsoft revolutionized business intelligence (BI) by making OLAP accessible to the IT professional right in the SQL Server relational database product. Now the company wants to make BI available throughout an organization. What’s next for BI?
Thomas Rizzo, senior director of SharePoint at Microsoft, took some time to talk about what’s new and what’s coming for SharePoint 2010 with SharePointPro Connections executive editor Sheila Molnar and her colleague Michael Otey, technical director for Windows IT Pro.
Molnar and Otey: Hi Tom. It’s great to have a chance to catch up with you. Before we get started, we understand that you go back quite a ways on Microsoft SQL Server before you moved to SharePoint.
Today Mary Jo Foley's column predicted that May 6, 2010 would be the official "due date" for SQL Server 2008 R2. A Transaction Processing Performance Council (TPC) benchmark for SQL Server 2008 R2 was published in early November 2009. According to Microsoft, the TPC rules require a product to be released within 185 days of the published benchmark. Add up the days and you get a release in early May 2010.
At PASS Summit 2009, Tom Casey, the Microsoft General Manager for SQL Server BI chatted with Michael Otey and me about the new editions for SQL Server 2008 R2 and how Microsoft is making it easier for developers and DBAs to try SQL Azure.
I spoke with Bill Graziano and Wayne Synder of the PASS organization about the upcoming PASS Summit 2009 in Seattle, November 2-9. There will be over 160 technical SQL Server sessions. The conference has experienced explosive growth.
Some announcements at TechEd of interest to SQL Server pros are: SQL Server 2008 R2, Support for 64 logical processers, Self-service BI in-memory analysis, Utility Data Platform, Master Data Services, and Low Latency Complex Event Processing.
Embarcadero announced a set of new and enhanced performance optimization tools to detect, fix and prevent a range of software errors that will improve the performance, availability and scalability of software systems.
Power Pivot and other self-service BI tools are not a replacement for a data mart or data warehouse. When used correctly for Personal BI, Team BI, prototypes or proofs-of-concept, you can achieve truly agile, rapid reporting success with Excel Power Pivot....More
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More