Want to work with Power BI and have no idea where to start? Let us show you in this straightforward and low cost course with easy to follow practical exercises !
We’re pleased to announce that this course is now available. This is another course that we’ve had so many requests for. You can find details of it here:
Do you need to get started with Power BI?
2025-07-09
Unlock your potential with Analysis Services !
We’re pleased to announce that this course is now available. We had so many requests for this course. You can find details of it here:
Analysis Services for Data Professionals
Are you ready to elevate your skills in working with Analysis Services?
Our comprehensive course is your gateway to becoming proficient at working with both SQL Server Analysis Services, and with Azure Analysis Services.
Ask Yourself:
2025-07-06
I’ve heard several people complaining that Azure Data Factory (ADF) is expensive to use, and yet I’ve seen many others talking about it as a really low cost service.
So which is true?
We’re very careful about which features of ADF that we use as there are a few that can increase the cost substantially. And without those, it becomes a very low cost service.
None of my current clients has any issue with ADF costs. The people that I hear complaining about the cost are using one or both of:
2025-07-05
One of the events that I try to take part in each year is the Hack Summit. I’ve always enjoyed it.
The next edition of the The Hack Summit is on October 17th online and October 18th in Warsaw at Stadion PGE Narodowy. It’s a conference fully dedicated to cybersecurity.
I so wish I could have been there, but unfortunately, that’s not possible for me this year. The organizers describe it as having “a diverse and rich agenda, featuring more than 15 thematic tracks, over 150 presentations, networking opportunities, an afterparty, and much more….”.
2024-09-20
I want to call attention to an upcoming change that I’m surprised I haven’t heard a lot more comments about. When you deploy an Azure VM, by default, they’ve always had the ability to connect outbound to the Internet.
That’s going to change.
Note the contents of this official notice: Default outbound access for VMs in Azure will be retired— transition to a new method of internet access.
The TLDR version of this, is that after the change date, when you deploy an Azure VM, it will not have outbound connectivity to the Internet.
2023-10-04
I was recently sent a copy of a new book by Ahilan Ponnusamy and Andreas Spanner, called Technology Operating Models for Cloud and Edge: Create your purpose-built distributed operating model for public, hybrid, multicloud, and edge.
It was interesting to read this book.
I spend more of my time on the Azure side of the fence than the AWS / RedHat side of things, so I have some pretty different opinions to the authors on many of the topics. I’ve have worked with multiple clouds, so what they were describing was familiar anyway.
2023-09-28
Microsoft Learn has a community content pilot running right now. They are looking to see how content from community members might provide different value to the content provided by their team members.
So, I decided that I should submit an article to see how it goes, and to find out how it works.
At present, it’s all hosted in a GitHub repository, and no surprise, is all written in Markdown.
2023-09-26
This is part 4 of a series on working with change data capture (CDC) in Azure SQL Database. This part discusses how to enable it and how to use it.
When I was reading the documentation for CDC in Azure SQL Database, I kept coming across a mention that it required at least an S3 service level objective (SLO), if you were using a DTU-based database.
I really hoped that wasn’t the case.
2023-09-23
I can’t tell you how many times lately, that I’ve seen people writing about service principles when they really mean service principals. These are entirely different concepts!
I did a certification exam the other day, and it was asking about service principles. I was left wondering how many people had reviewed that before it was released.
But what’s worse, is when people bake the wrong one into code libraries that others need to use. I was reading some content from Microsoft Learn: Quickstart: Manage data with Azure Cosmos DB Spark 3 OLTP Connector for API for NoSQL and I saw this code example:
2023-08-11
This is part 3 of a series on working with change data capture (CDC) in Azure SQL Database. This part discusses how to enable it and how to use it.
To show how this works, I have created an Azure SQL Database called CDCTest. I created it as a DTU-based database with a service level objective (SLO) of S3. I’ll discuss more about the licensing implications of CDC in part 4.
2023-06-02
