Making Sense of the Power BI Ecosystem Presentation Materials
I just wrapped up my first presentation on Making Sense of the Power BI Ecosystem at SQL Saturday #755 in...
2018-06-09
355 reads
SQL with Dustin Ryan
Monitoring and Tuning Azure SQL Database at SQL Saturday Jacksonville and 24 Hours of Pass
I’m speaking at two upcoming events that I wanted to share with you! My topic is Monitoring and Tuning Azure...
2018-04-20
294 reads
Converting a Power BI Desktop File from Import to Live Query
A customer of mine is in the midst of a proof of concept using SQL Server and Power BI. During...
2018-01-30
1,116 reads
2017 Year in Review for SQLDusty.com
2017 was an awesome year for SQLDusty.com! Thank you to all of the readers and visitors that stopped by to...
2018-01-29
384 reads
Creating a Knowledge Base Chat Bot w/ Azure Bot Service
A while back you may have caught my blog post introducing the Power BI Chat Bot 9000. Since posting that...
2018-01-02 (first published: 2017-12-12)
1,322 reads
Making Sense of Data Migration Assistant Assessments with Power BI
The Data Migration Assistant is a great tool developed to assess your SQL Server environment for a migration to a...
2017-12-06
957 reads
Setting Up a Drillthrough Action in your Power BI Report
At some point this weekend, the Microsoft Power BI folks turned on the drill-through feature in the Power BI service....
2017-09-03
1,616 reads
Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI....
2017-08-23
1,036 reads
Power BI FAQ Chat Bot 9000 lives!
So I’ve been working on a fun little project over the past couple weeks. A lot of my customers have...
2017-08-18
496 reads
Building Your Brand and Becoming a Thought Leader Session Materials
Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed...
2017-08-12
577 reads
Blogs
Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.
I recently had to copy an Azure SQL database (SQL db) from one subscription...
A field note: AI Ambition vs. Operational Reality in 2025
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from...
Redefining Tech Leadership in the Age of Microsoft AI
By Chris Yates
AI is no longer a niche capability – it is a leadership catalyst. As...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
SQL Server Columnstore Index Fragmentation
Comments posted to this topic are about the item SQL Server Columnstore Index Fragmentation
do i lose "what this object depends on" etc when moving sprocs to etl server
Hi i was surprised to see the approach my coworkers used to sunset talend...
Question of the Day
SQL Server Columnstore Index Fragmentation
The columnstore index is absolutely different than the traditional rowstore b-tree index. Because of this, it doesn't suffer from the same kind of fragmentation across pages as the b-tree index. Yet, it does suffer from a type of fragmentation brought about by an excess of deleted rows in a rowgroup and a lack of compression of storage because more things are in the delta store. While b-tree indexes use dm_db_index_physical_stats to show fragmentation, which system tables or DMVs can be used in SQL Server (prior to SQL Server 2025) to determine columnstore fragmentation?
See possible answers