How to prepare for 70-766 - Perform Big Data Engineering on Microsoft Cloud Services 14. August 2017 terrymccann Azure, Azure Data Factory, Microsoft, Modern Data Warehouse, Data Lake, Stream Analytics (2) There is a new exam currently in beta titled "Perform Big Data Engineering on Microsoft Cloud Servic... [More]
How to Find Your Next Job with Power Apps and Flow 11. August 2017 matthow Logic Apps, Power BI, Flow, PowerApps, Common Data Service (4) Both PowerApps and Flow exist within the Office 365 suite and bring enormous amounts of possibilitie... [More]
Scrum Insanity 6. August 2017 Dave-Stokes (3) When agile projects go wrong it’s often not a single massive mistake, but a series of small ones tha... [More]
Hashing for Change Detection in SQL Server 1. August 2017 NigelMeakins Hashing, Change Detection (4) HashBytes() in SQL Server 2016The HashBytes() function is primarily intended for hashing values for ... [More]
How to run a successful testing stage 26. July 2017 josemendes SQL (1) As we all know, testing is one of the most important stages of an IT project, however, either becaus... [More]
The Rad Retro 24. July 2017 Dave-Stokes (55) On our Agile / Scrum projects, we found we were suffering from the same issues coming out of Sprint ... [More]
Direct Query vs Live Connection in Power BI – Part 2 19. July 2017 Callum-Green Power BI Desktop, PowerBI, Live Connection, Direct Query (2) This instalment of the Power BI blog series focuses on the two other differences between Direct Quer... [More]
Direct Query vs. Live Connection in Power BI – Part 1 18. July 2017 Callum-Green Power BI Desktop, PowerBI, Live Connection, Direct Query (8) There are lots articles out there that compare Import Mode vs.Direct Query, but people rarely talk a... [More]
Instant Bot: deploying a Bot in minutes with Azure Bot Service 17. July 2017 UstOldfield Azure, Introduction, Bot Framework (1) I had been playing around with the Bot Framework for a while but hadn’t really got anywhere, largely... [More]
Geographic Spatial Analysis with Azure Data Lake Analytics (ADLA) 10. July 2017 SachaTomey Azure, Big Data, Business Intelligence, Data Lake, Data Lake Analytics, Data Lake Store, U-SQL, Data Warehouse (4) Whilst working on an Azure Data Lake project, a requirement hit the backlog that could be easily sol... [More]
Data Flow Pt 2: Vertexes In Azure Data Lake 6. July 2017 UstOldfield Azure, Big Data, Data Lake, Deep Dive (0) Following on from my previous post on Job Execution in the Azure Data Lake, this post will explore t... [More]
A Crash Course in R Part 2 4. July 2017 tristanrobinson R (3) Following on from Part 1 which introduces the R basics (which can be found here), in Part 2 I’ll sta... [More]
A Crash Course in R Part 1 3. July 2017 tristanrobinson R (6) What is R? Also known as the language for statistical computing, it was developed in the 1990s... [More]
Azure SQLDW-CTAS Statements 27. June 2017 SimonWhiteley Azure DataWarehouse, Azure (1) So here we are - you've designed your target distribution, you're scaling your warehouse appropriate... [More]
Azure SQLDW-Polybase Design Patterns 27. June 2017 SimonWhiteley Azure DataWarehouse (2) In my last posts, I've spoken about using Polybase as a basic data loading mechanism for Azure SQLDW... [More]
Azure SQLDW-Polybase Limitations 27. June 2017 SimonWhiteley Azure DataWarehouse (2) If it wasn't clear from my other blogs, I LOVE polybase. It's a super powerful tool that seamlessly ... [More]
Azure SQLDW-Polybase 27. June 2017 SimonWhiteley Azure DataWarehouse (1) The last time I gave a SQLDW conference talk, one of the audience members commented that I probably ... [More]
Coming Soon in Power BI - June 2017 & Beyond 15. June 2017 Callum-Green PowerBI, Power BI Desktop, Microsoft Data Insights Summit (1) Whilst I wasn’t fortunate enough to attend the Microsoft Data Summit on June 12-13 2017, I managed t... [More]
SQL Saturday Plovdiv 7. June 2017 JonathonEve-OConnor (2) Last weekend, Adatis made our first (of many appearances) at a Bulgarian SQL Server event - SQL Satu... [More]
Connecting Power BI to Hive 4. June 2017 UstOldfield Azure, Big Data, Power BI, HDInsight (0) On a recent project I was tasked with importing data into Power BI from a Hive table. For those of y... [More]