THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » denali   (RSS)
Showing page 2 of 9 (88 total posts)
  • Drillthrough for #BISM Tabular and attribute keys in #SSAS #Denali

    In an Analysis Services cube you can define drillthrough actions on a cube. This feature has been working since SQL 2005 and now it will be available in both BISM Multidimensional and BISM Tabular in the next version of SQL Server “Denali”. In the current CTP3 you can already use the drillthrough on a Tabular model: by default, all the columns of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 17, 2011
  • SQL Server v.Next (Denali) : CTP3 T-SQL Enhancements : FORMAT()

    As its name implies, the FORMAT() function was added to Denali in CTP3 to make formatting easier. For the purists, all formatting should be done at the presentation layer. For the rest of us, we know that our users and developers consuming our stored procedures expect us to be able to return data exactly how they want it presented. For years, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 9, 2011
  • SQL Server v.Next (Denali) : Changes to system objects in CTP3

    If you have access to both a CTP3 instance and a CTP1 instance, and the CTP3 instance can see the CTP1 instance, you can run all of these queries simply by creating a linked server on the CTP3 instance that references the CTP1 instance (and be sure to run in the context of master). I named this linked server ''OlderCTP'' so you will see that ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 7, 2011
  • Run as Radio Podcast - A little Denali

          In this podcast on the uber-popular podcast ''RunAs Radio'', host Richard Campbell asks me about what topics are of particular interest at Tech-Ed 2011, focusing the discussion on cloud and SQL Server ''Denali'' You can download the MP3 version of the podcast or the transcript here. Enjoy, -Kev ...
    Posted to Kevin Kline (Weblog) by KKline on August 2, 2011
  • Parent-child special calculations in #BISM #Tabular #Denali

    Alberto Ferrari published an interesting blog post regarding how to write particular calculations over a parent-child hierarchy in PowerPivot Denali (and in BISM Tabular, of course). One case is the Sum of Leaves (summing only the leaves of a parent-child hierarchy) and the other is the Sum of Children (computes all the nodes that are descendants ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 22, 2011
  • Change default workspace and deployment server in #Tabular #SSAS #Denali #CTP3

    When you install Analysis Services Denali, chances are that you create an instance for Tabular that is not the default instance for Analysis Services. When you try to create a Tabular project, you might get the following error: You cannot open the BIM file. Reason: The workspace database server ‘localhost’ was not found. Verify that there is ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 20, 2011
  • SQL Server v.Next (Denali) : Breaking change to sys.dm_exec_sessions

    If you're not OCD about prefixing every single column in a query, this is one that might bite you. Today you might have code that assumes that, because database_id is in sys.dm_exec_requests but not in sys.dm_exec_sessions, you don't need to prefix database_id in the following example:SELECT TOP (1)   s.session_id,   ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 19, 2011
  • Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect

    If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, you cannot import the attribute key value. Only the attribute name is included in the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 19, 2011
  • Detect Tabular or Multidimensional Version in #ssas #denali #ctp3

    If you want to detect if a particular instance of Analysis Services “Denali” is running in Tabular or Multidimensional mode, you have several choices. In the Books On Line you can find a few instructions to detect the version by looking at the icon used by SQL Server Management Studio when you connect to a SSAS instance, and if ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 18, 2011
  • SSIS Logging in Denali

    In my blog post SSIS Server, Catalogs, Environments & Environment Variables in SSIS in Denali from November 2010 I alluded to forthcoming enhancements in the logging infrastructure when I said: One final note on logging. The fairly limited information that gets captured in the current CTP is not the same as what will be in the product upon ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 16, 2011
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement