This post is in the category of “I’ll record it here so that the next time I run into it, I can remember what it was”. And if it helps anyone else in the meantime, that’s a bonus.
I had configured a new repository in Azure Repos (as part of Azure DevOps), cloned it to a local copy, modified some files and tried to push them back to the repo.
2024-09-25
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
Another book that I’ve been sent for review lately, was a pre-release edition of Data Visualization with Microsoft Power BI by Alex Kolokolov and Maxim Zelensky. It looks like it’s released now.
I’ve known Alex for many years, and have acted as a judge in his UI competition each year. He has a flair for data visualization. In the book, he mentioned that he was initially puzzled by many people finding it hard. But noted that “I later discovered that for experienced analysts and data engineers, visualization was entirely unnecessary. They comprehend the data structure, and the relationships are evident to them simply through tables. They genuinely don’t understand the need for all these pie charts and graphs.”
2024-09-18
Just a heads-up that v24 of SDU Tools went out to SDU Insiders last week. If you haven’t used SDU Tools, they are just a large library of functions implemented in T-SQL. You can use them as a full library or use them as examples of code in work you are trying to do.
We’ve also tried to keep all the code working for all versions of SQL Server that we see clients using. That means from SQL Server 2008 to SQL Server 2022. We also have an Azure SQL DB version.
2024-09-10
I had some clear time this morning so I read a recent book called Deciphering Data Architectures (Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh) by James Serra.
One comment I need to make is that for some reason, the O’Reilly titles seem to have become more expensive lately, and their freight options are expensive too. It was the same for this book. It was $112 AUD landed at my place. That’s so much more than any similar book that I’ve read lately, and this is not a large book.
2024-08-15
I recently received another eBook for review from our friends at PackT. This time it was an early release copy of the Third Edition of the Microsoft Power BI Cookbook by Greg Deckler and Brett Powell.
I’m a fan of books written in a cookbook style, rather than a teaching style. Often, people already know the basics and just want to get prompted on how to do specific tasks.
2024-08-03
What many people who follow me don’t know, is that I spent a lot of years playing baseball. Early on I played third base, later I pitched, and my last position was usually catcher or first base.
I love the game. What is less known is that I also spent many years umpiring baseball, through to state level. I umpired in the Pan-Pacific games in Queensland.
Umpiring requires a very detailed knowledge of the rules of the game. Umpires must pass annual rules examinations. If you want to umpire at higher levels of competition, you must pass the exams at a higher level.
2024-08-02
Welcome to show 3 for PG Down Under!
Once again, I really enjoyed recording today’s show. It features Ryan Booz. Ryan is an evangelist with our friends at Red-Gate, focussing on PostgreSQL.
In this show, Ryan shares his experiences with community in relation to PostgreSQL. Next, we ventured into the challenges and benefits of being an application vendor working against PostgreSQL, and in particular, the extensibility model and how it compares to other products.
2024-07-25
Another Fabric Down Under podcast is out the door. This time it was with a another fellow “Down Under” guest Heidi Hasting from Adelaide.
Heidi Hasting is a Business Intelligence professional and former software developer with over ten years experience in Microsoft products. She’s an MVP, MCT and holder of many certifications along with being an ALM/DLM enthusiast and Azure DevOps fan and co-founder and organiser of the Adelaide Power BI User Group.
2024-07-24
There was a question on the Q&A forums today, asking how to read data using SSIS, when it’s in this format:
|Col1| |Col2|Col3|Col|
|101| |A|21|DC|
One of the concerns was that there was a leading pipe. This is not a problem. When you have data like that, and you set | as the delimiter, because there are 6 delimiters, then there are 7 columns output. These are the values:
Column 1: blank string Column 2: 101 Column 3: blank string Column 4: A Column 5: 21 Column 6: DC Column 7: blank string
2024-07-19