Microsoft’s Build conference for 2016 took place a couple of weeks ago, and true to form, there were a number of killer announcements and reveals for a number of services, tools, and frameworks, many of which are available today. Not one to ever really post something when it’s actually relevant, here are a few of the things that jumped out at me from the event. Continue reading “5 Observations from Microsoft Build 2016” »
Yet again I’ve let things slide and haven’t posted in a while. This one’s nothing exciting. I’m currently migrating to a new hosting provider, so any weirdness can be attributed to this.
I’m hoping to be back soon with some more up to date posts!
A couple of months ago, Microsoft’s new-look Power BI Preview rolled out globally. Ditching the Office 365/Sharepoint Online requirement, the new Power BI is a streamlined, simplified version of the product that attempts to lose some of the bloat and give users a focussed, easy-to-use, self-service BI platform.
So has it worked?
2014 has been a very quiet year on picnicerror.net. Since moving job in April, things have been rather hectic, which has meant I’ve not had much time to post, despite having lots of good ideas for content. I’m hoping to pick things back up over the holidays and get some content ready for the new year. In the meantime though:
As part of Microsoft’s push to include business users in the Business Intelligence space, the addition of Data Quality Services to SQL Server’s feature set opened up the ETL process to the people who, arguably, know the data best. Integration with SSIS was a great move, meaning that this user control extends to automated processes, further closing the gap between data and the business.
However, like most new components, Data Quality Services has some teething problems, and these can be quite hard to find when debugging your SSIS packages. Here’s a quick tip that should help solve some of those tricky to find DQS issues. Continue reading “Debugging Errors in SSIS Data Quality Services Cleansing Component” »