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! Carly Miechen – Redgate Events Welcome to day 2. Let the Event team this year! (Great job Carly). Carly’s fifth PASS (first in 7 years!). Welcome to the people watching on the livestream as well! All general … 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
Microsoft Fabric, including the Data Warehouse, evolves faster than we can analyze and write about it. Here I’m summarizing the most recent news I looked at. Clone Table We have a specific statement to clone a table. But what exactly does it mean? The Clone Table feature promises to create an image of the table … Read more
One of the technologies that my new job brought with it was learning about all the various database platforms that are not Microsoft SQL Server. Not that I don’t still spend time learning about SQL Server, as it will happily remain one of our largest topics, but rather that I need to learn about other … Read more
Assistive Technology (AT) refers to a broad range of tools, devices, and software designed to enhance and/or maintain the functional capabilities and independence of individuals with disabilities. These technologies are designed to address and cater to the unique needs and challenges faced by people with physical, sensory, cognitive, or communication impairments. Assistive technology refers to … Read more
Move objects on Azure is not simple. Move between Tenants is extremely difficult or not possible. I faced the challenge to move a virtual machine and disks between tenants recently and found the solution. Some Years ago, I wrote an article about the Azure Resource Mover when it was still being created. Today the resource … Read more
Move your lips (and shake your hips if you want to, that is not required) and hear your words before you hit “post”. If you have someone you can read it to, that helps too. I commonly read my own articles to my spouse who will freely tell me when I am not making any … Read more
Database Projects for Fabric Data Warehouse is one of the most recent news of Fabric for SDLC (Software Development Life Cycle). Microsoft released the Database Projects around 2010 and have they evolved since that year. The original name was a tool called SSDT, released as part of SQL Server, but running inside a Visual Studio … Read more
While preparing for this career as an editor, my mind went to the joys of sitting at a computer editing documents. I expected this to include checking articles for technical accuracy, and proper English, formatting documents to meet the website standard, and posting the documents. I just knew that many of the firefighting skills I … Read more
SQL Server security structure, mechanisms and methods are very thoroughly documented in the Microsoft documentation, but it is quite daunting if you don’t already know about the functionality. I recently had a request to explain some security features of SQL Server so that internal audits could be completed. While thinking about the request and preparing … Read more
In 1964, the Beatles added something interesting to one of their songs. I Feel Fine started out with a twang of feedback. It wasn’t planned to happen, but by a happy accident, the first use of feedback in a song was created (and it wouldn’t be the last, which you know if you have ever … Read more