Is Self-service BI Threatening IT Professionals’ Livelihoods?
(this is another follow-up to Chris Webb’s post on “Why Corporate BI and Self-Service BI Are Both Necessary”) There is...
2012-12-09
827 reads
SQL Server BI Blog
Debugging Parameter Dependencies in Reporting Services
Creating a report with two datasets that reference the same pair of parameters, I’m seeing the following error: The Value...
2012-12-07
3,851 reads
Power View and Reporting Services
There has been an active discussion thread on Chris Webb’s blog about the similarities & differences between various Microsoft BI & reporting...
2012-12-03
733 reads
Is PowerPivot the Next Access?
I’m impressed with the current generation of semantic modeling technology from Microsoft. I’ve had the opportunity to use both PowerPivot...
2012-10-31 (first published: 2012-10-28)
4,369 reads
Office 2013 BI and Mobility
I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about...
2012-10-15
853 reads
The State of Microsoft Self-Service Reporting
(article published on the MVP Award Program Blog) I really enjoy this topic. One of the reasons, I suppose, it’s...
2012-09-27 (first published: 2012-09-25)
2,745 reads
2012 Fall & Winter Conference Sessions
Fall is a busy time for speaking engagements which include user groups, SQL Saturdays and the PASS Global Summit. I'm...
2012-09-22
709 reads
SQL Server BI & SharePoint eBooks, Guides and Resources
There are many free eBooks & resources available from Microsoft and members of the MVP community. This is a collection of...
2012-08-10
1,347 reads
PASS 2012 Summit: November 6-9
I just received an email message from the PASS Global Summit 2012 organizers after submitting session abstracts a few weeks...
2012-06-10
1,197 reads
On my way to DevTeach in Vancouver
Just stepping out the door on on my way to the DevTeach / SQL Teach conference in Vancouver, BC, Canada. The...
2012-05-28
969 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