I am writing some SQL to form the basis of views to pull data from a Microsoft SQL Server source into Azure SQL Database, and then the data would go to Power BI. The data was all presented in string format initially (not my data, not my monkeys, not my circus), and I wanted to… Continue reading Error converting data type varchar to numeric where ISNUMERIC finds only numbers
how to find the tenant in Power BI.
December is a great time for setting personal and business goals for next year. I'd hoped for some downtime at this time of year, but I've picked up a crucial data science project which needs to be delivered over Christmas so there isn't much downtime. I'm also starting to write another book, which will be… Continue reading Business Goals for 2019: Looking back over 2018 and forward
Azure SQL Database is introducing two new features to cost-effectively migrate workloads to the cloud. SQL Database Hyperscale for single databases, available in preview, is a highly scalable service tier that adapts on demand to workload needs. It auto-scales up to 100 TB per database to significantly expand potential for app growth. What does this mean?… Continue reading Microsoft Ignite interview with Kevin Farlee on Azure SQL Database Hyperscale
If you are at Microsoft Ignite this week in Orlando, FL, don't miss these Azure Cosmos DB database sessions and all the Cosmic Announcements. Here's a list of the Azure Cosmos DB sessions below. You can find out more details on Azure Cosmos DB sessions over at the Schedule Builder here. Here's a great slideshare… Continue reading Roundup of Azure #CosmosDB Sessions at #MSIgnite
I'm speaking at #ITDevConnections 2018! Join me in Dallas and learn on topics such as: Blockchain Demystified for Business Intelligence Professionals Data Analytics with Azure Cosmos Schema-less Data and Power BI R in Power BI for Absolute Beginners There is also a Women in Technology lunch and I'm excited about that, too! Join me in… Continue reading I’m speaking at #ITDevConnections 2018!
This blog is my takeaways from Microsoft's Build 2018 conference, Day 2. Communication is such an essential skill and it is even more crucial in today's connected world. I love what Microsoft are doing with ML in Word, with WinML. It will improve people's written communication skills since it improves the spell and grammar. This… Continue reading Microsoft Build 2018 Day 2 Keynote Summary: Better developer experiences across devices
Hans Hultgren (LinkedIn) and his team are holding the Data Vault Certification course (CDVDM) again in London - June 18-20. Please tell Hans that I sent you, and you will qualify for a discount. Note that I'm not financially incentivized in any way; Hans reached out after my recent Data Vault post, and I was… Continue reading Data Vault Certification Course in London with Hans Hultgren.
One of my project roles at the moment (I have a few!) is that I am architecting a major Azure implementation for a global brand. I'm also helping with the longer-term 'vision' of how that might shape up. I love this part of my job and I'm living my best life doing this piece; I… Continue reading Modelling your Data in Azure Data Lake
I'm excited to be speaking three times at the Data & BI Summit in Dublin, 24th - 26th April. It's extra special for me since it will be my first event as a Microsoft Regional Director and also after having been named one of the top 20 women in Artificial Intelligence, Data Science, Machine Learning… Continue reading Azure CosmosDB, Azure Data Lake Analytics and R sessions at Microsoft Data and BI Summit BA
I was very pleased to appear on the Izenda website along with five other Business Intelligence experts, discussing the past, present and future of self-service Business Intelligence. I was delighted and honoured to appear with luminaries such as Wayne Eckerson, John Myers, Kevin Smith, Rich Ghiossi, and Ron Powell. Self-service Business Intelligence is a… Continue reading Past and Future of Self-Service Business Intelligence
As an independent consultant, I value my customers' security, particularly around their data. Why use a Password Manager? I love data and I believe in protecting it. I believe in trying to fix the people and process aspects of security. So that means, I need to think about how to give my customers access to… Continue reading Using Password Managers as a Consultant