Recently Azure Resource Graph was announced as a new connector in Power BI. Azure Resource Graph provides access to almost all resources inside the azure environment of a company. Why is this important? Resource Graph by itself is a very important tool to analyze the provisioned resources on Azure environment without lose the control of … Read more
We can say Fabric is the evolution of the Power BI environment. Power BI is a self-service environment, and so is Fabric. This allows the implementation of very interesting architectures, which will be the subject of future videos and articles. However, it’s not something free-and-easy, and it shouldn’t be. Using Fabric Admin Portal (or Power … Read more
I have always spent time learning relational databases on my own, non-work time. As the years have passed, I have spent less of my own free time on technical learning and writing for many reasons, but still, I spend plenty of my own time learning about the database technology that Codd started. While I never … Read more
The animation on the top of this article tries to track the evolution of the enterprise architecture since SQL Server 7.0 introduced tools for ETL, Semantic model and much more. Some of you probably remember these tools as SSIS and SSAS. At that time they had even older names, but no one wants to confess remembering … Read more
I hate coming up with ideas for editorials, but my last editorial of the year gives me a very simple topic just staring me in the face: New Year’s Resolutions. Love them or hate them (or it we are honest, a good bit of both,) this end of one year and the start of another is … Read more
This continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer rows between systems from a basic design perspective. This isn’t specific to any ETL tool but rather the basic patterns for moving data. The most difficult part in designing a pattern is efficiency. It has to be accurate … Read more
On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on the source control. In this way we can include notebooks on a Software Development Lifecycle (SDLC) for Power BI objects. In this way, the notebooks need to flow from the development environment to test and production environments. However, … Read more
It has been a long month. We had the PASS Data Community Summit just a month ago, and I came home with a hitchhiking virus (no, not that one). I dragged through Thanksgiving, got better, and went on vacation. I got back home from vacation, and, well, I was sick again. Looking at my calendar … Read more
I used to believe this option was something almost absolute: it should be enabled as best practice. I was in some way happy when all my demos for SQL Server 2022 started to fail, and I discovered it was because this option was enabled by default. This weekend I attended a technical session which caught … Read more
The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power BI allowed us to include source control on a SDLC process for Power BI, supporting reports and datasets linked directly from the portal to a repository. The New Source Control Features Recently, without much news, Microsoft extended the … Read more
No matter the ETL tool used, there are some basic patterns to follow when transferring data between systems. There are many data tools and platforms, but the basic patterns remain the same. This focuses on SQL Server, but most of these methods work in any data platform. Even if you are using a virtualization layer, … Read more
comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an interesting advance, but it was disappointing because it was only available in half. Updating the Fabric Data Warehouse was not possible yet. The November updates for Microsoft Fabric announces the support for SQLPackage, but I couldn’t find additional … Read more
What a week it was. While it wasn’t my first in person conference this year, it felt different. For the past 20+ years, the Summit has been one of the standard parts of my year. It was always marked on my calendar as where I would be, and for years I would make hotel reservations … Read more
Last but not least, the Community Keynote. Hang on to your hats, this is going to be an interesting ride! President/Founder of SQL Skills – Kimberly Tripp Surprised people make the Friday keynote. Agreed. This is hard and exhausting! On day to go! Try to do your reviews as soon as possible. Then perhaps present … Read more
Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence! Note: if you aren’t into the whole brevity thing, you can view then entire keynote on YouTube here. Carly Miechen – Redgate Events Welcome to day 2. Let the Event team this year! (Great job Carly). Carly’s fifth … Read more
The possibility to use Visual Studio Code (or VS Code) to develop your Microsoft Fabric notebooks seems very interesting. It may bring many benefits for usability and for the SDLC (Software Development lifecycle): You may prefer developing on your own machine than on the interface of a portal It’s possible to develop and test before … Read more
I arrived early to get my seat at the media table. Definitely exciting! CEO of Redgate: Jakub Lamik This year’s theme is Connect, Share, and Learn. Tomorrow will be the Redgate keynote! People are here from 44 countries. The summit has 5 tracks, 232 sessions with 231 speakers! 43% of attendees are first timers! Thank … Read more
I was talking to some people today about the concept of Autonomous Databases. The idea is that the database platform can do most, if not all, of the work of storing and managing data by itself. These are a few of the concepts that were shared primarily as discussion points, but you have to be … Read more
As an editor working with other people’s technical writing for many years, you might guess that either language skills or technical abilities would be the largest issue that you deal with. Both of these provide plenty of challenges, but the biggest issue is plagiarism in one shape or another. (Spelling the word plagiarism is kind … Read more
I wanted to write a post about going to the Pass Data Community Summit this year, and everything I started to write sounded cheesy. So I started thinking (finally), how could I share my love for the event? One of my hobbies is photography. My goal in taking pictures is to remind me of a … Read more