In this next article, we are going to explore how to install, configure and use the command line to manage a couple different Fabric Lakehouse’s.
Purging data from a table is a common database maintenance task to prevent it from growing too large or to stay in compliance with data retention. When dealing with small amounts of data, this can be accomplished by a simple delete with no issues; however, with larger tables, this task can be problematic. Deleting records requires a lock that can block other processes from writing or even reading the data (depending on your isolation level). In this article I will share a technique I have used to work with some very large tables.
Steve has advice for students looking to become data professionals.
Building pipelines in Microsoft Fabric can be complicated, and it's easy to write code that is hard to maintain. Using parameters in your connections helps to build pipelines that are easily configured.
What DMVs were added to Azure SQL Databases, and which DMVs are missing from Azure SQL Databases but still exist on SQL Server 2019 or other versions?
Before I start the whining (whinging if you prefer), let me just say I have the greatest job in the world. I'm exceedingly lucky to have it. I'm grateful as can be. And someone else (looking at you Tim) can get it when they pry it from my dead cold fingers. With that out of […]
Who among us hasn't deleted a production data file? Steve hopes most of us have not.
Learn how you can conduct a sentiment analysis on data loaded into an Excel spreadsheet.
What advice would you give to someone new to Power BI? What are common Power BI mistakes to avoid? In this article, we will discuss several Power BI mistakes to avoid to help you navigate this powerful tool effectively.
By Daniel Janik
Microsoft's unified analytics platform, Fabric, simplifies integration across various tools in Azure by offering...
By Brian Kelley
I always try and ensure that I post my slides to my talks here...
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
Hi, Does anyone know how to handle a raw data file where some rows...
Hi, On my SQL 2022 (16.0.4195.2) test environment, I tried to enable Force Strict...
Hi everyone I have a bunch of CSV files that I need to import...
I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?
See possible answers