Scribd Logo
Upload

Welcome to Scribd!

  • 48 views

    Exam Ref 70-768 Developing SQL Data Models: List of Urls

    Uploaded by

    sahil

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Exam Ref 70-768 Developing SQL Data Models: List of Urls

    Uploaded by

    sahil
    48 views11 pages

    Original Title

    ER70-768_URL_List.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    48 views11 pages

    Exam Ref 70-768 Developing SQL Data Models: List of Urls

    Uploaded by

    sahil

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 11

    Exam Ref 70-768 Developing SQL Data Models

    List of URLs

    Introduction

    SQL Server 2016 installation documentation


    https://msdn.microsoft.com/en-us/library/ms143219.aspx

    SQL Server Management Studio


    https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

    SQL Server Data Tools for Visual Studio 2015


    https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

    Chapter 1 Design a multidimensional business


    intelligence (BI) semantic model

    Dimensional Modeling Techniques


    http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-
    techniques/dimensional-modeling-techniques/

    WideWorldImportersDW sample database


    https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

    Installation instructions
    https://msdn.microsoft.com/library/mt734217.aspx

    Snowflake dimension design


    http://sqljason.com/2011/05/when-and-how-to-snowflake-dimension.html

    Slowly changing dimension type 1


    http://www.kimballgroup.com/2008/08/slowly-changing-dimensions/

    Slowly changing dimension type 2


    http://www.kimballgroup.com/2008/09/slowly-changing-dimensions-part-2/

    Fact table surrogate key


    http://www.kimballgroup.com/2006/07/design-tip-81-fact-table-surrogate-key/

    SQL Server Data Tools for Visual Studio 2015


    https://msdn.microsoft.com/en-us/library/mt204009.aspx

    1
    Search for current updates to SSDT if link changes
    http://www.microsoft.com

    Select Creation Method (Dimension Wizard)


    https://msdn.microsoft.com/en-us/library/ms178681.aspx

    Defining the Unknown Member and Null Processing Properties


    https://msdn.microsoft.com/en-us/library/ms170707.aspx

    SQL Server Analysis Services Discretization


    https://www.mssqltips.com/sqlservertip/3155/sql-server-analysis-services-discretization/

    Translations in Multidimensional Models (Analysis Services)


    https://msdn.microsoft.com/en-us/library/hh230908.aspx

    Defining and Browsing Translations


    https://msdn.microsoft.com/en-us/library/ms166708.aspx

    Adventure Works 2014 Sample Databases


    http://msftdbprodsamples.codeplex.com/releases/view/125550

    Define Linked Dimensions


    https://msdn.microsoft.com/en-us/library/ms175648.aspx

    Select Creation Method (Cube Wizard)


    https://msdn.microsoft.com/en-us/library/ms187975.aspx

    Warnings (Database Designer) (Analysis Services-


    Multidimensional Data)
    https://msdn.microsoft.com/en-us/library/bb677343.aspx

    Ragged Hierarchies
    https://msdn.microsoft.com/en-us/library/ms365406.aspx

    Ragged Hierarchies and HideMemberIf: an in-depth look


    https://xzwang.wordpress.com/2013/07/10/ragged-hierarchy-and-hidememberif/

    Ragged Hierarchies, HideMemberIf and MDX Compatibility


    https://blog.crossjoin.co.uk/2009/11/11/ragged-hierarchies-hidememberif-and-mdx-compatibility/

    Defining Parent Attribute Properties in a Parent-Child Hierarchy


    https://msdn.microsoft.com/en-us/library/ms167115.aspx

    Unary Operators in Parent-Child Dimensions


    https://msdn.microsoft.com/en-us/library/ms175417.aspx

    Using Unary Operators to control Analysis Services hierarchy


    aggregations

    2
    https://sqljoe.wordpress.com/2011/09/23/using-unary-operators-to-control-analysis-services-
    hierarchy-aggregations/

    SSAS: Reference materialized dimension might produce incorrect


    results
    http://sqlblog.com/blogs/alberto_ferrari/archive/2009/02/25/ssas-reference-materialized-
    dimension-might-produce-incorrect-results.aspx

    Data Mining Wizard (Analysis Services – Data Mining)


    https://msdn.microsoft.com/en-us/library/ms175645.aspx

    Browse a Model Using the Microsoft Cluster Viewer


    https://msdn.microsoft.com/en-us/library/ms174801.aspx

    Many to Many Revolution 2.0


    http://www.sqlbi.com/articles/many2many/

    Create a Finance account of parent-child type Dimension


    https://technet.microsoft.com/en-us/library/ms174609(v=sql.130).aspx

    Create a Currency type Dimension


    https://technet.microsoft.com/en-us/library/ms175413(v=sql.130).aspx

    A Guide to Currency Conversions in SSAS


    http://www.bp-msbi.com/2010/10/a-guide-to-currency-conversions-in-ssas/

    SSAS: Multicurrency Problem (Part I)


    http://bifuture.blogspot.com/2014/09/ssas-multicurrency-problem-part-i.html

    Analysis Services MOLAP Performance Guide for SQL Server


    2012 and 2014
    https://msdn.microsoft.com/en-us/library/dn749781.aspx

    Create a Finance account of parent-child type Dimension


    https://msdn.microsoft.com/en-us/library/ms174609.aspx

    Chapter 2 Design a tabular BI semantic model

    Comparing Tabular and Multidimensional Solutions (SSAS)


    https://msdn.microsoft.com/en-us/library/hh212940.aspx

    Create a PivotTable to analyze worksheet data


    https://support.office.com/en-us/article/Create-a-PivotTable-to-analyze-worksheet-data-a9a84538-
    bfe9-40a9-a8e9-f99134456576

    3
    Power View: Explore, visualize, and present your data
    https://support.office.com/en-us/article/Power-View-Explore-visualize-and-present-your-data-
    98268d31-97e2-42aa-a52b-a68cf460472e

    Turn on Power View in Excel 2016 for Windows


    https://support.office.com/en-us/article/Turn-on-Power-View-in-Excel-2016-for-Windows-f8fc21a6-
    08fc-407a-8a91-643fa848729a

    USERELATIONSHIP in Calculated Columns


    https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

    Bidirectional cross-filtering in SQL Server Analysis Services 2016


    and Power BI Desktop
    https://blogs.msdn.microsoft.com/analysisservices/2016/06/24/bidirectional-cross-filtering-
    whitepaper/

    Using the SSAS Tabular Model, Week 5 – Hierarchies 2


    https://sharepointmike.wordpress.com/2012/11/03/using-the-ssas-tabular-model-week-5-
    hierarchies-2/

    Parent-Child Hierarchies
    http://www.daxpatterns.com/parent-child-hierarchies/

    DateStream
    https://datestream.codeplex.com/

    Copy and Paste Data (SSAS Tabular)


    https://msdn.microsoft.com/en-us/library/hh230895.aspx

    Configure Analysis Services for Kerberos constrained delegation


    https://msdn.microsoft.com/en-us/library/dn194199.aspx

    Hardware Sizing a Tabular Solution (SQL Server Analysis


    Services)
    https://msdn.microsoft.com/en-us/library/jj874401.aspx

    5 Tips to Ensure Super Fast SSAS Tabular Models


    https://www.blue-granite.com/blog/5-tips-fast-ssas-tabular-models

    The VertiPaq Engine in DAX


    https://www.microsoftpressstore.com/articles/article.aspx?p=2449192&seqNum=3

    Refresh command (TMSL)


    https://msdn.microsoft.com/en-us/library/mt697588.aspx

    Introduction to the Tabular Object Model (TOM) in Analysis


    Services AMO
    https://msdn.microsoft.com/en-us/library/mt706505.aspx

    4
    Memory Settings in Tabular Instances of Analysis Services
    http://www.sqlbi.com/articles/memory-settings-in-tabular-instances-of-analysis-services/

    Analysis Services PowerShell Reference


    https://msdn.microsoft.com/en-us/library/hh758425.aspx

    DAX Formula Compatibility in DirectQuery Mode (SSAS 2016)


    https://msdn.microsoft.com/library/mt723603(SQL.130).aspx

    DAX Properties
    https://msdn.microsoft.com/en-us/library/mt761855.aspx

    What’s New in Analysis Services


    https://msdn.microsoft.com/en-us/library/bb522628.aspx#DirectQuery

    Hybrid Mode in Tabular BI Semantic Model – Part 1


    http://www.mssqlgirl.com/hybrid-mode-in-tabular-bi-semantic-model-part-1.html

    Chapter 3 Develop queries using Multidimensional


    Expressions (MDX) and Data Analysis Expressions (DAX)

    MDX Function Reference (MDX)


    https://msdn.microsoft.com/en-us/library/ms145970.aspx

    Descendants (MDX)
    https://msdn.microsoft.com/en-us/library/ms146075.aspx

    FORMAT_STRING Contents (MDX)


    https://msdn.microsoft.com/en-us/library/ms146084.aspx

    VBA functions in MDX and DAX


    https://msdn.microsoft.com/en-us/library/hh510163.aspx

    Passing Parameters to MDX Shared Datasets in SSRS


    http://www.bimonkey.com/2014/04/passing-parameters-to-mdx-shared-datasets-in-ssrs/

    Stairway to MDX
    http://www.sqlservercentral.com/stairway/72404/

    CREATE MEMBER Statement (MDX)


    https://msdn.microsoft.com/en-us/library/ms144787.aspx

    Microsoft Locale ID Values


    https://msdn.microsoft.com/en-us/library/ms912047.aspx

    Grant custom access to dimension data (Analysis Services)

    5
    https://msdn.microsoft.com/en-us/library/ms175366.aspx

    SSAS Dynamic Security


    http://richardlees.blogspot.com/2010/10/ssas-dynamic-security.html

    Grant custom access to cell data (Analysis Services)


    https://msdn.microsoft.com/en-us/library/ms174847.aspx

    The Additive Design of SSAS Role Security


    https://blogs.msdn.microsoft.com/psssql/2014/07/30/the-additive-design-of-ssas-role-security/

    User Access Security Architecture


    https://technet.microsoft.com/en-us/library/ms174927(v=sql.105).aspx

    Analysis Services Stored Procedure Project


    https://asstoredprocedures.codeplex.com/

    Predefined Numeric formats for the FORMAT Function


    https://technet.microsoft.com/en-us/library/ee634561

    Customer Numeric Formats for the FORMAT Function


    https://technet.microsoft.com/en-us/library/ee634206

    SUMMARIZECOLUMNS Function (DAX)


    https://msdn.microsoft.com/en-us/library/mt163696.aspx

    SUMMARIZE Function DAX


    https://msdn.microsoft.com/en-us/library/gg492171.aspx

    All the secrets of SUMMARIZE


    http://www.sqlbi.com/articles/all-the-secrets-of-summarize/

    Best Practices Using SUMMARIZE and ADDCOLUMNS


    http://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/

    Revising ALL()
    https://www.powerpivotpro.com/2010/02/all-revisited/

    ALL Function (DAX)


    https://msdn.microsoft.com/en-us/library/ee634802.aspx

    Using ALLEXCEPT versus ALL and VALUES


    https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/

    Order of Evaluation in CALCULATE Parameters


    https://www.sqlbi.com/articles/order-of-evaluation-in-calculate-parameters/

    ADDMISSINGITEMS Function (DAX)

    6
    https://msdn.microsoft.com/en-us/library/dn802537.aspx

    CALCULATETABLE Function (DAX)


    https://msdn.microsoft.com/en-us/library/ee634760.aspx

    New DAX Functions


    https://msdn.microsoft.com/en-us/library/mt704075.aspx

    Math and Trig Functions (DAX)


    https://msdn.microsoft.com/en-us/library/ee634241.aspx

    DAX Operator Reference


    https://msdn.microsoft.com/en-us/library/ee634237.aspx

    Statistical Functions (DAX)


    https://msdn.microsoft.com/en-us/library/ee634822.aspx

    Date and Time Functions (DAX)


    https://msdn.microsoft.com/en-us/library/ee634786.aspx

    Time Intelligence Functions (DAX)


    https://msdn.microsoft.com/en-us/library/ee634763.aspx

    Filter Functions (DAX)


    https://msdn.microsoft.com/en-us/library/ee634807.aspx

    Logical Functions (DAX)


    https://msdn.microsoft.com/en-us/library/ee634365.aspx

    Variables in DAX
    https://www.sqlbi.com/articles/variables-in-dax/

    Clever Hierarchy Handling in DAX


    http://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/

    DAX Patterns
    http://daxpatterns.com

    Chapter 4 Configure and maintain SQL Server Analysis


    Services (SSAS)

    Analysis Services Operations Guide


    https://msdn.microsoft.com/en-us/library/hh226085.aspx

    Configure Services Accounts (Analysis Services)


    https://msdn.microsoft.com/en-us/library/ms175371.aspx#bkmk_winpriv

    7
    Hardware Sizing a Tabular Solution (SQL Server Analysis
    Services
    https://msdn.microsoft.com/en-us/library/jj874401.aspx

    Thread Pool Properties


    https://msdn.microsoft.com/en-us/library/ms175657.aspx

    Coreinfo utility
    https://technet.microsoft.com/en-us/sysinternals/cc835722.aspx

    Synchronize Analysis Services Databases


    https://msdn.microsoft.com/en-us/library/ms174928.aspx

    SQLCAT’s Guide to BI and Analytics


    http://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-
    7BF3C672DF9D/SQLCAT's%20Guide%20to%20BI%20and%20Analytics.pdf

    Backup and Restore of Analysis Services Databases


    https://msdn.microsoft.com/en-us/library/ms174874.aspx

    Attach and Detach Analysis Services Databases


    https://msdn.microsoft.com/en-us/library/cc280583.aspx

    Create and Manage a Remote Partition (Analysis Services)


    https://msdn.microsoft.com/en-us/library/ms174751.aspx

    How to Cluster SQL Server Analysis Services


    https://msdn.microsoft.com/en-us/library/dn736073.aspx

    Analysis Services Operations Guide


    https://msdn.microsoft.com/en-us/library/hh226085.aspx

    Analysis Services MOLAP Performance Guide


    https://msdn.microsoft.com/en-us/library/dn749781.aspx

    RAMMap utility
    https://technet.microsoft.com/en-us/sysinternals/rammap.aspx

    Analysis Services Stored Procedure Project


    http://asstoredprocedures.codeplex.com/

    DAX Query Plan, Part 1, Introduction


    http://mdxdax.blogspot.com/2011/12/dax-query-plan-part-1-introduction.html

    DAX Query Plan, Part 2, Operator Properties


    http://mdxdax.blogspot.com/2012/01/dax-query-plan-part-2-operator.html

    DAX Query Plan, Part 3, Vertipaq Operators

    8
    http://mdxdax.blogspot.com/2012/03/dax-query-plan-part-3-vertipaq.html

    Whitepaper; Understanding DAX Query Plans


    https://www.sqlbi.com/articles/understanding-dax-query-plans/

    Monitor Analysis Services with SQL Server Extended Events


    https://msdn.microsoft.com/en-us/library/gg492139.aspx

    Use Dynamic Management Views (DMVs) to Monitor Analysis


    Services
    https://msdn.microsoft.com/en-us/library/hh230820.aspx

    Tool for baselining MOLAP Processing


    http://blogs.prodata.ie/post/Tool-for-baselining-MOLAP-Processing.aspx

    Baselining Tabular Model Processing with a trace file


    http://blogs.prodata.ie/post/Baselining-Tabular-Model-Processing-with-a-trace-file.aspx

    Analysis Services MOLAP Performance Guide


    https://msdn.microsoft.com/en-us/library/dn749781.aspx

    How to warm up the Analysis Services data cache using Create


    Cache statement?
    https://blogs.msdn.microsoft.com/sqlcat/2007/04/26/how-to-warm-up-the-analysis-services-data-
    cache-using-create-cache-statement/

    Building a Better Cache-Warmer, Part 1: The Storage Engine


    Cache
    https://blog.crossjoin.co.uk/2009/09/30/building-a-better-cache-warmer-part-1-the-storage-
    engine-cache/

    Analysis Services Operations Guide


    https://msdn.microsoft.com/en-us/library/hh226085.aspx

    The VertiPaq Engine


    https://www.microsoftpressstore.com/articles/article.aspx?p=2449192&seqNum=6

    Performance Tuning of Tabular Models in SQL Server 2012


    Analysis Services
    https://msdn.microsoft.com/en-us/library/dn393915.aspx

    MaxParallelism Property in Sequence Command (TMSL)


    https://msdn.microsoft.com/en-us/library/mt697587.aspx

    Performance Tuning of Tabular Models in SQL Server 2012


    Analysis Services
    https://msdn.microsoft.com/en-us/library/dn393915.aspx

    Group Attribute Members (Discretization)

    9
    https://msdn.microsoft.com/en-us/library/ms174810.aspx

    DRILLTHROUGH Statement (MDX)


    https://msdn.microsoft.com/en-us/library/ms145964.aspx

    Analysis Services MOLAP Performance Guide


    https://msdn.microsoft.com/en-us/library/dn749781.aspx

    Improve SQL Server Analysis Services MDX Query Performance


    with Custom Aggregations
    https://www.mssqltips.com/sqlservertip/4432/improve-sql-server-analysis-services-mdx-query-
    performance-with-custom-aggregations/

    Partition Wizard
    https://msdn.microsoft.com/en-us/library/ms179981.aspx

    Create and Manage a Remote Partition (Analysis Services)


    https://msdn.microsoft.com/en-us/library/ms174751.aspx

    Set Partition Storage (Analysis Services-Multidimensional)


    https://msdn.microsoft.com/en-us/library/ms175646.aspx

    Proactive Caching (Partitions)


    https://technet.microsoft.com/en-us/library/ms174769.aspx

    Error Configuration for Cube, Partition, and Dimension


    Processing (SSAS – Multidimensional)
    https://msdn.microsoft.com/en-us/library/ms180058.aspx

    Set the Partition Slice Property (Analysis Services)


    https://msdn.microsoft.com/en-us/library/ms174764.aspx

    Set Partition Writeback


    https://msdn.microsoft.com/en-us/library/ms174823.aspx

    Write-Enabled Partitions
    https://msdn.microsoft.com/en-us/library/ms174750.aspx

    Processing Objects (XMLA)


    https://msdn.microsoft.com/en-us/library/ms187199.aspx

    Performing Batch Operations (XMLA)


    https://msdn.microsoft.com/en-us/library/ms186680.aspx

    Defining and Browsing Translations


    https://msdn.microsoft.com/en-us/library/ms166708.aspx

    Translations in Tabular models (Analysis Services)

    10
    https://msdn.microsoft.com/en-us/library/mt654273.aspx

    11

    You might also like