How to Optimize Power BI Semantic Model Performance with Vertipaq Analyzer
The performance of a Power BI semantic model – formerly known as dataset – depends on a variety of factors. One of the biggest influences is the data model itself: did you put everything into one single big table (you might found out writing DAX might …
[Video] Office Hours in Snowy Telluride, Colorado
On a beautiful sunny afternoon in the mountains, I went through your top-voted questions from https://pollgab.com/room/brento. Audio is a little rough on this one because I used a new wireless microphone and forgot to put the wind shield on it. If you …
Does Your GROUP BY Order Matter?
Sometimes when you do GROUP BY, the order of the columns does matter. For example, these two SELECT queries produce different results:CREATE INDEX Location_DisplayName ON dbo.Users(Location, DisplayName); SELECT TOP 100 Location, DisplayName, COUNT(*) …
Managed Vs Unmanaged Tables – Data Engineering with Fabric
Managed Vs Unmanaged Tables Microsoft Fabric was released as general availability on November 15th, 2023. I will be creating a series of articles to get you up to speed on how to manipulate data in the lake house using Spark. I really like the speed of …
Free Live Webcasts: Slide & Demo Versions of How to Think Like the Engine
You’re comfortable writing queries to get the data you need. But you’re uncomfortable if someone asks you how it works, how SQL Server and Azure SQL DB turn your queries into results. You know there are execution plans, but … you’re u …
Department of Redundancy Department
Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too much anymore, the first reason that databases came into existence was to remove redundancies. The first source of redundancy back in the dar …
Correct SQL Server Transactional Replication Issues with T-SQL and SSMS
The post Correct SQL Server Transactional Replication Issues with T-SQL and SSMS appeared first on SQLServerCentral.
Find Unused or Backup Tables
In this article, I am going to demonstrate how we can identify the unused tables of a given SQL database. As a database administrator, we must keep an audit of the database objects. You are administrating a database that has hundreds of tables and some …