Monday, September 1, 2014

Useful Links

SSIS/SSAS Interview Question Links

http://www.msbiguide.com/2012/11/ssas-interview-questions-and-answers/
http://www.msbiguide.com/2012/11/ssas-interview-questions-and-answers
http://www.msbiguide.com/2012/12/ssis-interview-questions-and-answers/

SSAS Useful Links
http://siddhumehta.blogspot.in/2011/05/free-ssas-tutorial-end-to-end-step-by.html
http://www.mssqltips.com/tutorial.asp?id=2000
https://mis.uhcl.edu/rob/Course/DW/Resources/SQL-ServerAnalysisServices2008.pdf
https://mis.uhcl.edu/rob/Course/DW/DW.htm
http://msdn.microsoft.com/en-us/library/ms145514.aspx
http://msdn.microsoft.com/en-us/library/ms144785.aspx
Online tutorial: http://technet.microsoft.com/en-us/magazine/ee677579.aspx

http://msdn.microsoft.com/en-us/library/ms146047.aspx (slice examples)
http://www.databasejournal.com/article.php/1459531/William-E-Pearson-III.htm -  SSAS book
http://msdn.microsoft.com/en-us/library/ms145970.aspx - MDX funtions

http://www.ssas-info.com/analysis-services-faq/27-mdx/917-how-do-i-find-the-bottom-10-customers-with-the-lowest-sales-in-2003-that-were-not-null - query examples
http://www.ssas-info.com/ssas-cheat-sheets/922-mdx-various-queries-cheat-sheet - query examples

http://thomasivarssonmalmo.wordpress.com/category/mdx-for-everyone/ - query exmaples

http://office.microsoft.com/en-001/access-help/find-the-records-with-the-top-or-bottom-values-in-a-group-or-field-HA010096437.aspx - query examples

http://vnu10.blogspot.in/2011/01/mdx-grand-total-sub-total.html

http://msdn.microsoft.com/en-us/library/aa216772(v=sql.80).aspx – for key concepts

http://msdn.microsoft.com/en-us/library/ms144864.aspx - for query

http://beyondrelational.com/modules/2/blogs/65/posts/11612/set-the-slice-on-your-ssas-cube-partitions-now.aspx (for mdx slicing)

http://sqlserverpedia.com/wiki/MDX_Built-in_Functions_-_Member_Functions#CurrentMember
(for functions)
http://www.mdxpert.com/Functions/MDXFunction.aspx?f=43 (for funtions)

https://eazybi.com/help/calculated-members - BI Concepts

http://technet.microsoft.com/en-us/library/ms145988.aspx - for mdx functions
http://www.purplefrogsystems.com/blog/
http://www.databasejournal.com/





SSAS interview questions:

http://www.mssqltips.com/sqlservertip/2637/ssas-interview-questions-part-i-questions-on-basic-concepts-data-sources-and-data-source-views/


http://www.databasejournal.com/features/article.php/3593466/MS-SQL-Series.htm



General SQL Links
http://jkhealthworld.com/hindi/%E0%A4%91%E0%A4%B2-%E0%A4%95%E0%A5%88%E0%A4%9F%E0%A5%87%E0%A4%97%E0%A4%B0%E0%A5%80%E0%A4%9C

http://hindisamay.com/premchand%20samagra/Indexpremchand.htm

http://www.toadworld.com/platforms/sql-server/default.aspx
http://www.databasejournal.com/features/article.php/3593466/MS-SQL-Series.htm
http://www.mytechmantra.com/LearnSQLServer/SQL_Server_Recovery_Model.html
http://www.sqlskills.com/blogs/jonathan/

No comments:

Post a Comment