Combining Silver Tables into a Model – Data Engineering with Fabric
Data Presentation Layer Microsoft Fabric allows the developer to create delta tables in the lake house. The bronze tables contain multiple versions of the truth, and the silver tables are a single version of the truth. How can we combine the silver tab …
Why Generative AI Scares the Hell Out of DBAs
I was chatting with a client’s DBA about this thought-provoking blog post about data governance in the age of generative AI. The DBA’s concern was, “What if we hook up generative AI tools to the production database, and someone asks f …
T-SQL Tuesday #174: Your Favorite Job Interview Question?
T-SQL Tuesday is something I don’t participate in nearly enough. When I saw Kevin Feasel’s invitation for this months topic, I knew I had to answer! One of my favorite things to do is technical interviews (about stuff that I know). So much …
PowerBI premium capacity administration: dataset monitoring and tuning
Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its turn demands several supporting roles: there are, of course, developers, data engineers and data scientists, but there is need for one more, i. …
Read Data Stored in a Lake Database using Azure Synapse Analytics
The post Read Data Stored in a Lake Database using Azure Synapse Analytics appeared first on SQLServerCentral.
Using Machine Learning Pipeline Execution Activity in Azure Data Factory
Introduction The Azure Machine Learning (AML) Python SDK v2 is an updated Python SDK package. It helps to build a single command or a chain of commands like Python functions to create a single step or a complex workflow. I will discuss the end-to-end s …
Identifying Customer Buying Pattern in Power BI – Part 2
In our previous article, Identifying Customer Buying Patterns in Power BI—Part 1, we described the customer purchase product frequency. In this article, we will be conducting an advanced analysis in Power BI via a market-based analysis (MBA) technique …
I’m Getting Antsy for SQL Server vNext.
Historically, Microsoft publicly announces the next version of SQL Server about a year before it ships. For example: November 2, 2021, Microsoft announced the private preview of SQL Server 2022. About 6 months later, on May 24, 2022, they announced the …
Who’s Changing the Table? Answers and Discussion
Your challenge for this week was to find out who keeps mangling the contents of the AboutMe column in the Stack Overflow database. Conceptually, there are a lot of ways we can track when data changes: Change Tracking, Change Data Capture, temporal tabl …
SQL Server Filtered Index Essentials Guide
The post SQL Server Filtered Index Essentials Guide appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Spring 2024
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha. The long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? Let’s …
How to Build Metadata Driven Pipelines in Microsoft Fabric
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined software engineering approach. One of the benefits of having a more code-based approach in data pipelines is that it has beco …
[Video] Office Hours: Ask Me Anything About Azure and Microsoft Databases
Back at home in the office, time to settle in with a nice caffeine-free Diet Coke and go through your top-voted questions from https://pollgab.com/room/brento. Why caffeine-free? Because I slug multiple coffees first thing in the morning when I wake up …
Ingest and Retrieve data from an ADX Cluster Using Python
Introduction Azure Data Explorer (ADX) helps to analyze high volumes of data in near real-time. The Azure Machine Learning (AML) Python SDK v2 is an updated Python SDK package. It helps to build a single command or a chain of commands like Python funct …
The Curious Case of… missing log information
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some t …