SQL 2016 CTP3 R Setup and Review 10. November 2015 UstOldfield SQL 2016, SQL 2016 CTP3, SQL 2016 R Installation (1) The release of SQL Server 2016 CTP3 is pretty big as it’s the first CTP which incorporates in-databa... [More]
Power BI Maps Handling Duplicate City Names 4. November 2015 ShaneGrimes Power BI, Visualisation, Maps (0) The Bing map engine behind the map visualisation in Power BI is very intuitive allowing users to pro... [More]
Reflections On PASS Summit 1. November 2015 JonathonEve-OConnor PASS, SQL Server 2016 (0) Well it’s been quite a week and this has certainly been a summit with many announcements for the wid... [More]
MDS 2012 Business Rules 208: A database error has occurred 13. October 2015 ShaneGrimes (1) There is an issue with MDS 2012 and business rules with a combination of "must be unique" ... [More]
Azure HDInsight Polybase Example 7. October 2015 Jeremy-Kashel HDInsight, Polybase (2) Polybase has now made it over to SQL Server 2016 and is available to use as part of the SQL Server 2... [More]
Video : Build an Automated Multilingual Product Dimension with Power BI Desktop 29. September 2015 SachaTomey (0) I’ve recorded a short video (< 10 minutes) showing off some of the data manipulation/transformati... [More]
Enhanced Analysis Services Multidimensional Support in Datazen 23. September 2015 JonathonEve-OConnor Datazen, MDX (0) Datazen is a great new addition to the MS BI stack which has been greeted with much enthusiasm since [More]
Data Quality Services Leading Values 22. September 2015 Jeremy-Kashel Data Quality Services (0) The Leading Values checkbox is one of the options available when you setup a domain within DQS Domai... [More]
Connecting SQL Server to R 15. September 2015 UstOldfield ODBC Data Source, sqlTables, RODBC, odbcConnect, Connecting SQL to R, sqlQuery, sqlFetch, R (2) In this post I’m going to use R to retrieve some data from SQL Server. In order to use R in con... [More]
Dynamic Bandings in Power BI Desktop 15. September 2015 JonathonEve-OConnor Percentile, Sorting, Dynamic Banding (1) Recently I’ve been looking at applying dynamic bandings for a client. What was required was to split... [More]
Setting Up The Power BI Analysis Services Connector 11. September 2015 JonathonEve-OConnor Power BI, Tabular, Analysis Services (0) The Power BI Analysis Services Connector is used in order to expose a Tabular model to Power BI allo... [More]
Power BI MDS Dashboard 10. September 2015 Jeremy-Kashel Power BI, Dashboards (2) Master Data Services tables such as the staging tables have been well blogged and documented, but th... [More]
SQL Order by with aggregation 8. September 2015 ShaneGrimes T-SQL, Order by, SQL, Sql Server, Aggregation, Group by (0) In this post we will look into applying an order by clause to a query containing an aggregate functi... [More]
Power BI Visual Studio Online Content Packs – Analysing BI Team Performance 4. September 2015 SimonWhiteley Visualisations, Mobile, Power BI, Dashboards (0) I spend a fair amount of time championing the use of data and analytics around my client’s companies... [More]
Executing SQL Scripts From TeamCity 1. September 2015 JonathonEve-OConnor Unit Testing, TeamCity, SQL Server (0) Recently I was working in an environment where we used TeamCity to automate unit testing (further bl... [More]
Continuous Integration With TeamCity – Automating SSIS Build and Deployment 1. August 2015 JonathonEve-OConnor (8) 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]