The session’s was really great and so do the Speakers . Learn a lot off stuffs and knowledge from 24 hours for PASS SUMMIT Preview.http://www.bidn.com/blogs/Anil/ssas/4520/don-t-forget-to-join-the-session-s-by-expert-today-24-hours-of-pass-summit-preview
Here are some of the question I have asked so far and by doing some research on that I found some answers as:
1.Power view loads data in Memory, so how big data set can it load and will it be significant to work/analysis as similar to multidimensional OLAP cube analysis.?
: I could not get the clear answer of this one but I think Power view can’t be used as significant as SSAS providing .
2.Will SQL server going to handle the BIG data as similar like Hadoop and others.
Since they are quite different product I know, Microsoft Big Data offers an integrated platform for managing data of any type or size, whether it is structured data from a relational data warehouse such as SQL Server 2012 Parallel Data Warehouse, unstructured data on Hadoop or streaming data.
PolyBase is a breakthrough new technology on the data processing engine in SQL Server 2012 Parallel Data Warehouse designed as the simplest way to combine non-relational data and traditional relational data in your analysis. So, MSSQL 2012 focusing for Big DATA , structured/ Unstructured data as like Hadoop currently emerging.
http://www.microsoft.com/en-us/sqlserver/solutions-technologies/business-intelligence/big-data.aspx
http://www.microsoft.com/en-us/sqlserver/solutions-technologies/data-warehousing/polybase.aspx
3.Can Power view used to analyze the Multidimensional OLAP cube?
I think this feature is released in SQL Server 2012 SP1 CU 4 and still not works in Excel 2013 if I am not wrong.
4.Is it better to use 50-60 left join from almost 50 tables having cluster index to populate a single fact table or we can use some intermediate table using 20-20-20 joins and lastly join those tables to populate a single fact table.
: still waiting for answer
5.what will be the performance issue while replication AlwaysON High Availability and how does it sync with primary to secondary .
:This is nice feature I notice about in SQL 2012.
6.what will be better approach vertical partitioning or horizontal partitioning in SQL 2012.
:Vertical partitioning since horizontal partitioning is quite complex in SQL 2012 as per speaker.
7.Does Power view and Power Map only support Bing maps, can’t we use a Google maps.
:No, we cannot use Google maps for now.
These are some of the question I have asked so far, and the answers may not be quite enough or correct.
I hope someone knows better answer for these question too so, if you have any please share some.
That will surely helps us and wish I could attend the PASS Summit 2013 that is going to held on
Charlotte, NC: October 15-18, 2013 .
http://www.sqlpass.org/summit/2013/
Thanks,
Anil Maharjan