Continuous Integration With TeamCity – Automating SSIS Build and Deployment 1. August 2015 JonathonEve-OConnor (7) In this blog article I will be detailing how I use TeamCity in order to automate the building and de... [More]
New Features in SQL Server 2016 – Part 4: Integration Services 8. July 2015 Callum-Green SSIS, Integration Services, Project Upgrade, Package Deployment, AlwayOn (0) In the current SQL Server 2016 CTP2, there are not many exciting improvements made to SSIS. Th... [More]
New Features in SQL Server 2016 – Part 3: Reporting Services 25. June 2015 Callum-Green New Chart types, PowerBI, DPI, PowerView, SSRS, Report Builder, Mobile BI (2) I am pleased to announce Microsoft have made some improvement to Reporting Services (SSRS), in the u... [More]
New Features in SQL Server 2016 – Part 2: Analysis Services 17. June 2015 Callum-Green Tabular, Multidimensional, SQL Server 2016 CTP2, Partitions, SSAS, DAX, PowerPivot (5) This blog solely focuses on the new Analysis Services features of SQL Server 2016 CTP2. For an... [More]
New Features in SQL Server 2016 – Part 1: Database Engine 9. June 2015 Callum-Green System Views, CTP2, In-Memory, SQL Server 2016, RLS, Columnstore, High Availability, Database Engine (4) In early May 2015, SQL Server 2016 was made available in Preview. To download the CTP2 version... [More]
Master Data Services SQL Server 2016 5. June 2015 Jeremy-Kashel SQL Server 2016 (1) Unless you’ve been living under a rock for the last week or so, you will have noticed that CTP2 for ... [More]
Master Data Services Staging Tables Setup 19. May 2015 Jeremy-Kashel (0) This is just a quick tip for Master Data Services, specifically around the setup of new entities. Wh... [More]
Master Data Services Permissions Guide 13. May 2015 Jeremy-Kashel (0) I’ve had a few questions recently on various projects around the Master Data Services Model Object p... [More]
Currency Conversion (Triangulation Arbitrage) 12. May 2015 UstOldfield Common Table Expression, IBM, CTE, Currency Conversion, Triangulation Arbitrage, Cognos Controller (0) Some systems use a single currency as a base, which is something that I noticed recently when workin... [More]
How to setup Datazen Enterprise Server 7. May 2015 FrancescoSbrescia Azure, Datazen, SQL Server, Visualization (4) Microsoft has recently acquired Datazen, a powerful platform for data visualization. From the presen [More]
Joins vs CROSS APPLY 7. April 2015 Callum-Green CROSS APPLY, Joins, SQL Server 2005+, OUTER APPLY, TVF's, table-valued functions (0) Every professional (who has worked with SQL Server) will have used a Join operator. However, t... [More]
How to get an age from two dates in SQL 1. April 2015 UstOldfield Age, DATEDIFF, SQL, Age in Years and Months (1) For a project that I’ve been working on recently I was tasked with finding the Age of a product at a... [More]
Stop Automatic checkout of SSIS Packages in Visual Studio 20. March 2015 JonathonEve-OConnor (0) Every once in a while I work on a project affected by this issue. What happens is that upon loading ... [More]
Connecting To Google BigQuery From SSRS 20. March 2015 JonathonEve-OConnor (1) Recently I have been investigating Google BigQuery as a potential tool for use in a client Datawareh... [More]
Getting Started With Windows Azure Files Service 17. March 2015 JonathonEve-OConnor (0) One of the exciting new features I have been using recently in Azure is the new ‘Azure Files’ servic... [More]
Setting Up Credentials For Azure Automation 17. March 2015 JonathonEve-OConnor (0) Recently I have been working with Simon Whiteley on a project to produce a scalable BI solution in t... [More]
A Morning with Scott Guthrie 5. March 2015 SimonWhiteley (0) Monday saw the UK Azure usergroup hosting the legendary ScottGu for a morning of all-things-Azure. T... [More]
Adatis Hackathon Jan 2015 – Power BI Designer Preview 4. March 2015 ScottHudson Power BI Designer Preview, Power BI Designer, Hackathon, Power BI (1) In the January Adatis hackathon we were split into 3 teams and got the chance to play with some blee... [More]
SSIS Foreign Language Translation 3. March 2015 Jeremy-Kashel (1) A standard practice in the data warehousing world is the process of delivering conformed dimensions,... [More]
Effective Handling Of Failed Lookups In SSIS 23. February 2015 JonathonEve-OConnor (0) Recently I was working on a project I noticed the many of the packages were using the below pattern ... [More]