businessintelligence-solutions.com
Extreme performance with xVelocity: is VertiPaq faster than ColumnStore Index or just different?
http://www.businessintelligence-solutions.com/extreme-performance-xvelocity-vertipaq-faster-columnstore-index-different
Extreme performance with xVelocity: is VertiPaq faster than ColumnStore Index or just different? Extreme performance with xVelocity: is VertiPaq faster than ColumnStore Index or just different? Posted in Business Intelligence Blog. I was preparing a nice post about how the new technologies of SQL Server 2012 could make a huge improvement on your DB queries and performance, more specifically about the well known “ColumnStore Index” ( xVelocity memory optimized ColumnStore index). Has shown 100X improvement.
businessintelligence-solutions.com
Posts by albertgd | Business Intelligence Solutions Freelance Australia NSW Sydney
http://www.businessintelligence-solutions.com/author/albertgd
View that provides SCD Type2 with only one datetime field. On Mar 10, 2015 in Business Intelligence Blog. CREATE VIEW [hstg].[vw Table History]. ETL EXECUTION DT AS START DATE. ISNULL(lead (ETL EXECUTION DT) OVER (PARTITION BY BusinessKey ORDER BY ETL EXECUTION DT), ’9999-12-31 00:00:00.0000000′) AS END DATE. CASE WHEN lead (ETL EXECUTION DT) OVER (PARTITION BY BusinessKey ORDER BY ETL EXECUTION DT) IS NULL THEN ‘Y’ ELSE ‘N’ END AS [ CURRENT RECORD. ETL BATCH DT AS ETL ROW START DT,. SETL BATCH ROW ID,.
businessintelligence-solutions.com
Lotus Temple – New Delhi (India) | Business Intelligence Solutions Freelance Australia NSW Sydney
http://www.businessintelligence-solutions.com/lotus-temple-delhi-india
Lotus Temple – New Delhi (India). Lotus Temple – New Delhi (India). Posted in AS PHOTOGRAPHER. Lotus Temple – New Delhi (India). Did you like this? Click here to cancel reply. Mail (will not be published) (required). Download my CV here. MCP Virtual Business Card. View that provides SCD Type2 with only one datetime field. Aiming for the real time with Tabular Cubes. DV) Datavault approach for your DWH. Best Practice of SCD in SSIS. Lotus Temple – New Delhi (India). Testing your SSIS 2008.
businessintelligence-solutions.com
Testing your SSIS 2008 | Business Intelligence Solutions Freelance Australia NSW Sydney
http://www.businessintelligence-solutions.com/testing-ssis-2008
Testing your SSIS 2008. Testing your SSIS 2008. Posted in Business Intelligence Blog. Define a best practice testing a SSIS solution is not an easy task, but I would like to share what I consider good practices from my experience and humble knowledge about the matter. Shouldn’t work on a whole package (or even solution) without testing it little by little. A good (and painful) practice is to apply “ Continuous Integration. 8220;, that means, whenever you are working in a big solution (with even more deve...
businessintelligence-solutions.com
View that provides SCD Type2 with only one datetime field
http://www.businessintelligence-solutions.com/view-scd-type2-datetime-field
View that provides SCD Type2 with only one datetime field. View that provides SCD Type2 with only one datetime field. Posted in Business Intelligence Blog. CREATE VIEW [hstg].[vw Table History]. ETL EXECUTION DT AS START DATE. ISNULL(lead (ETL EXECUTION DT) OVER (PARTITION BY BusinessKey ORDER BY ETL EXECUTION DT), ’9999-12-31 00:00:00.0000000′) AS END DATE. ETL BATCH DT AS ETL ROW START DT,. SETL BATCH ROW ID,. CONVERT (DATETIME, ’99991231′) AS ETL ROW END DT,. ETL ROW HASH,. ETL CDC OPERATION,. Alberto...
businessintelligence-solutions.com
Best Practice of SCD in SSIS | Business Intelligence Solutions Freelance Australia NSW Sydney
http://www.businessintelligence-solutions.com/practice-scd-ssis
Best Practice of SCD in SSIS. Best Practice of SCD in SSIS. Posted in Business Intelligence Blog. Right now I am making a research about what is BIG DATA. Can help with it and some brief hands-on (beyond the theory). But before I just wanted to help to any SSIS developer who has to work with SCD (Slowly Changing Dimensions). And is getting a bad performance response and with some little problems. There is two ways to implement a SCD on SSIS:. Sql command, will give you a better starting date. This way wi...
businessintelligence-solutions.com
Opera House / Sydney (AUS) | Business Intelligence Solutions Freelance Australia NSW Sydney
http://www.businessintelligence-solutions.com/opera-house-sydney-aus
Opera House / Sydney (AUS). Opera House / Sydney (AUS). Posted in AS PHOTOGRAPHER. Did you like this? Click here to cancel reply. Mail (will not be published) (required). Download my CV here. MCP Virtual Business Card. View that provides SCD Type2 with only one datetime field. Aiming for the real time with Tabular Cubes. DV) Datavault approach for your DWH. Best Practice of SCD in SSIS. Lotus Temple – New Delhi (India). Testing your SSIS 2008. Opera House / Sydney (AUS). Alberto Ferrari (SQLBI.com).
businessintelligence-solutions.com
Performance tips for your MS Business Intelligence Solution and SQL Server | Business Intelligence Solutions Freelance Australia NSW Sydney
http://www.businessintelligence-solutions.com/performance-tips-ms-business-intelligence-solution-sql-server
Performance tips for your MS Business Intelligence Solution and SQL Server. Performance tips for your MS Business Intelligence Solution and SQL Server. Posted in Business Intelligence Blog. Well, there is thousand of tips and tricks to maintain your SQL Server with a good perfomance but I would like to remember some tips that I adapt myself for my BI solutions that are totally mandatory (well, as usual, depends of the business and depends of the solution size), but a good practices to keep in mind. Fact ...
businessintelligence-solutions.com
Data Modeling (Antares Solutions - Sydney, Australia)
http://www.businessintelligence-solutions.com/data-modeling
Posted in Business Intelligence Blog. This is probably a key factor, technically speaking, of the future health of your BI solution. There is not perfect nor unique “Data Modelling” that will fit in ALL solutions, but there are some points that will power up your future DW and extend to the max. all the possibilities. Data modeling it is so extensive concept that can’t be covered within one post neither one book, but we can provide some easy to understand “. Dos and don’ts. That will create a database wi...
SOCIAL ENGAGEMENT