Continuation from the previous 76 parts, the whole series can be found at https://www.nikoport.com/columnstore/ I have written previously about SQL Server Integration Services and their interaction with Columnstore Indexes in Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer…
During my vacations at the end of 2014 I have finally finished a book on “SQL Server 2012 Integration Services Design Patterns”. This book is written by some of the most respected authors in the SSIS space, such as Andy…
Did you ever faced a situation when needing to generate dynamically a SQL Server Reporting Services Report on-demand, at some strange hour, such as 4:30 AM because of the different timezones involved or because it takes so much time and…
A couple of days ago, Tillmann has released a new version of his amazing SSIS data source for Google Analytics – GoogleAnalyticSource. After 5 months and some extensive investments here are some of the news that this release contains: Support…
I love SSIS Server, it was one of the greatest addition to the SQL Server Integration Services in 2012 version without any doubt, even though the RTM bits were not production ready. There is one issue with the SSIS Project…