Credit to stux-12364 for the jigsaw image. When you install SSDT, you can find that the SSIS Toolbox components are all missing. I am writing this blog for myself BECAUSE I ALWAYS FORGET WHERE IT IS and I am SO ANGRY with myself right now. Here is what to do: Click on Control Flow Go… Continue reading SSIS Toolbox components are all missing?! Here’s the fix!
Customers want their data good, fast, cheap and easy. A tall order, right? One of the biggest challenges that I see with data warehousing in the cloud is that customers are concerned with cost. I was interested to see the Gigaom report on the topic of Data Warehousing in the cloud, which contained a number… Continue reading Data Warehousing and Business Intelligence in the Cloud with #Azure: How do we get good, fast, cheap and easy?
I'm excited about Power BI dataflows, since I believe it's a great way forward for companies to sort out the issue that nobody likes to talk about: cleaning data. I'm passionate about this topic since I believe in inheriting technical debt as much as I can, so I leave the organization's technical debt in a… Continue reading Power BI Dataflows and fixing ‘Your Azure storage account must be in the same Azure Active Directory tenant as your Power BI tenant.’
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