Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report updates outside of Power BI Desktop. One thing you may want to do is to...
2024-12-30
25 reads
With the PBIR format of Power BI reports, it’s much easier to make report updates outside of Power BI Desktop. One thing you may want to do is to...
2024-12-30
25 reads
Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain...
2024-12-09 (first published: 2024-11-27)
465 reads
Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain...
2024-11-27
49 reads
Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain...
2024-11-27
63 reads
Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain...
2024-11-27
131 reads
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse with a metadata-driven, pattern-based approach. One of the benefits I mentioned is that it’s easy...
2024-10-28 (first published: 2024-10-14)
309 reads
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse with a metadata-driven, pattern-based approach. One of the benefits I mentioned is that it’s easy...
2024-10-14
23 reads
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse with a metadata-driven, pattern-based approach. One of the benefits I mentioned is that it’s easy...
2024-10-14
24 reads
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse with a metadata-driven, pattern-based approach. One of the benefits I mentioned is that it’s easy...
2024-10-14
30 reads
A reader of one of my previous posts pointed out that the legend order and segment order in my core visual stacked column chart did not match. I had...
2024-10-21 (first published: 2024-09-30)
757 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers