THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 6 (56 total posts) < 1 second(s)
  • 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
  • re: A new SQL Server MVP from Italy

    Congratulations!
    Posted to Alberto Ferrari (Weblog) by jorg on April 12, 2011
  • re: Replication Services as ETL extraction tool

    Hi Marlene, I have just checked the package again and I can open it and see the design without problems. Please note that it's a SSIS 2008 package so you wont be able to open it in SSIS 2005! --Jorg
    Posted to Jorg Klein (Weblog) by jorg on March 31, 2011
  • Replication Services as ETL extraction tool

    In my last blog post I explained the principles of Replication Services and the possibilities it offers in a BI environment. One of the possibilities I described was the use of snapshot replication as an ETL extraction tool: Snapshot Replication can also be useful in BI environments, if you dont need a near real-time copy of the database, ...
    Posted to Jorg Klein (Weblog) by jorg on March 12, 2011
  • Replication Services in a BI environment

    In this blog post I will explain the principles of SQL Server Replication Services without too much detail and I will take a look on the BI capabilities that Replication Services could offer in my opinion. SQL Server Replication Services provides tools to copy and distribute database objects from one database system to another and maintain ...
    Posted to Jorg Klein (Weblog) by jorg on February 24, 2011
  • re: SSIS - Package design pattern for loading a data warehouse - Part 2

    @Vinod: Because you usually want to minimize the pressure on the source systems and want to keep the load window as small as possible. Next to these reasons it's usually easier to extract only the changed records when using a staging area that's identical to the source system. But in some cases you can do everything in a single DFT, in other ...
    Posted to Jorg Klein (Weblog) by jorg on January 4, 2011
  • SSIS Denali as part of “Enterprise Information Management”

    When watching the SQL PASS session Whats Coming Next in SSIS? of Steve Swartz, the Group Program Manager for the SSIS team, an interesting question came up: Why is SSIS thought of to be BI, when we use it so frequently for other sorts of data problems? The answer of Steve was that he breaks the world of data work into three parts: Process ...
    Posted to Jorg Klein (Weblog) by jorg on December 1, 2010
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement