Today at the PASS 2009 Summit the spotlight was on business intelligence (BI) with a keynote from Tom Casey, general manager, SQL Server BI at Microsoft. Tom noted during his keynote that more than 30 percent of PASS attendees this year noted BI as a priority track. To respond to the increasing interest in BI, Tom conducted a Twitterview after his keynote, answering questions from attendees. If you didn\u2019t have a chance to follow the Twitterview live, below is a transcript. (Follow Microsoft SQL Server on Twitter @MS_SQL_Server)<\/b><\/p>\n
Q)<\/b> What was that word for Amir’s new feature? (as shown in the keynote demo)<\/p>\n A) <\/b>The underlying technology is called VertiPaq<\/p>\n<\/blockquote>\n Q)<\/b> 100m rows running in Excel 2010 with PowerPivot is remarkably fast, but I want to know how much memory his laptop has?<\/p>\n A)<\/b> 8GB but we had SharePoint, SQL Server running as well. Client side had 100m rows, runs well on 2GB netbook too.<\/p>\n<\/blockquote>\n Q)<\/b> There is a tight integration of PowerPivot w\/ Excel, but also Sharepoint. What if you don’t want SharePoint?<\/p>\n A)<\/b> SharePoint required for server side features. Can use Excel alone for client. <\/p>\n<\/blockquote>\n Q)<\/b> Nobody said BizTalk at PASS is it dead?<\/p>\n A)<\/b> If you are asking about BI, BI and BizTalk still go well together in process automation. <\/p>\n<\/blockquote>\n Q)<\/b> How much of this can be done with just the Standard Edition SKU of R2?<\/p>\n A)<\/b> Excel add-in required for Excel 2010. SharePoint add-in comes with Enterprise Edition. <\/p>\n<\/blockquote>\n Q)<\/b> What were the data extensions on Reporting Services in R2 that you showed?<\/p>\n A)<\/b> Reports, SQL Azure, SharePoint lists can be data feeds. Plus any traditional data sources in your environment – use what you choose. <\/p>\n<\/blockquote>\n Q)<\/b> Should I wait until next week to release, or do it today?<\/p>\n A)<\/b> Get started now, others have <\/p>\n<\/blockquote>\n Q)<\/b> What is the purpose of the SQL Server utility control point (UCP)?<\/p>\n A)<\/b> UCP is central repository for config and perf data collected for all the instances enrolled in App & Multi-Server Mgmt group.<\/p>\n<\/blockquote>\n Q)<\/b> In PowerPivot, what two Excel features do you use to visualize the results?<\/p>\n A)<\/b> You can use PivotChart and PivotTable<\/p>\n<\/blockquote>\n Q)<\/b> Is there a feature in PowerPivot enables you to associate data in one table with data in another table?<\/p>\n A)<\/b> Automatic and manual relationship creation are options<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":" Today at the PASS 2009 Summit the spotlight was on business intelligence (BI) with a keynote from Tom Casey, general manager, SQL Server BI at Microsoft. Tom noted during his keynote that more than 30 percent of PASS attendees this year noted BI as a priority track.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2433,2445],"topic":[],"coauthors":[],"class_list":["post-5503","post","type-post","status-publish","format-standard","hentry","content-type-events","content-type-thought-leadership"],"yoast_head":"\n\n
\n
\n
\n
\n
\n
\n
\n
\n
\n