THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 7 (62 total posts) < 1 second(s)
  • SharePoint Server 2016 IT Preview from a BI point of view

    SharePoint Online and Power BI have a lot of attention and focus lately, but what about the on-premises version of SharePoint thats used in almost all serious BI solutions today? Well SharePoint Server 2016 IT Preview has just been released by Microsoft, by many stated as the last on-premises version of SharePoint ever. In this blog post I will ...
    Posted to Jorg Klein (Weblog) by jorg on August 28, 2015
  • re: BI on your terms with SQL Server 2016

    Hi Nacho, I recently attended a session from a SQL Server MVP about SQL 2014 and he told me adding the MSDB to an AlwaysOn Group should be possible from SQL 2014. I had some contact with him about this matter and he told me this was probably in a CTP version of SQL 2014 because it is indeed not possible anymore in SQL 2014 today. So you are ...
    Posted to Jorg Klein (Weblog) by jorg on June 3, 2015
  • BI on your terms with SQL Server 2016

    The last few years Microsoft's strategy was all about cloud first (or cloud only?), releasing new BI products and updates to existing products to the cloud in high pace without almost any investments in on-premises BI. In 2015 Microsoft seems to change its course, they now aim more on the enabling of hybrid scenarios, investing a lot in both ...
    Posted to Jorg Klein (Weblog) by jorg on May 22, 2015
  • Power BI Analysis Services Connector Security

    The Power BI Analysis Services Connector can be used to connect from the Power BI service to your on premises tabular Analysis Services models. In this blogpost I will look into the security and authentication possibilities that the SSAS Connector offers. Dynamic row-level security based on the Power BI user name to an on premises SSAS Tabular ...
    Posted to Jorg Klein (Weblog) by jorg on March 19, 2015
  • re: Relational Data Lake

    @Tony, using HDInsight gives you the possibility to issue Hive and Pig queries. The big advantage of these queries is that they are SQL-like and therefore easy to understand, you dont have to write any Java code. A nice introduction to HDInsight can be found here: The following tutorial ...
    Posted to Jorg Klein (Weblog) by jorg on December 23, 2014
  • Relational Data Lake

    What is a Data Lake? Pentaho CTO James Dixon is credited with coining the term ''Data Lake''. As he describes it in his blog entry, ''If you think of a Data Mart as a store of bottled water cleansed and packaged and structured for easy consumption the Data Lake is a large body of water in a more natural state. The contents of the Data ...
    Posted to Jorg Klein (Weblog) by jorg on December 18, 2014
  • re: Implement SSAS MD cell security using dimension security with blazing performance

    Hi Anže, Following the technique described in this blog post means you would create one _CHECKED calculation based on your measure and use this in all your other calculation definitions. End users will still see the calculations, but when they use it in a pivot or report it will return NULL when they don't have the appropriate rights. So the ...
    Posted to Jorg Klein (Weblog) by jorg on February 26, 2013
  • Implement SSAS MD cell security using dimension security with blazing performance

    SQL Server Analysis Services (SSAS) Multidimensional (MD) is a great product, and in my opinion its still the only real option to go for when building complex enterprise BI solutions. Its still very fast when implemented correctly and its mature and therefore very stable. &nbsp; The only real downside is cell security, which, in my opinion, is ...
    Posted to Jorg Klein (Weblog) by jorg on February 18, 2013
  • SSIS Denali CTP3 – What’s new?

    Last week Microsoft released CTP3 of SQL Server Integration Services (SSIS), code name: Denali. In this blog post I will look into the new key features and some of the minor improvements in SSIS Denali. 1. Development Shared Connection Managers Connection Managers can now be shared on SSIS project level. You can create them in the ...
    Posted to Jorg Klein (Weblog) by jorg on July 22, 2011
  • SSIS - Connect to Oracle on a 64-bit machine (Updated for SSIS 2008 R2)

    We recently had a few customers where a connection to Oracle on a 64 bit machine was necessary. A quick search on the internet showed that this could be a big problem. I found all kind of blog and forum posts of developers complaining about this. A lot of developers will recognize the following error message: Test connection failed ...
    Posted to Jorg Klein (Weblog) by jorg on June 9, 2011
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement