Power BI Hands-On Workshop at PASS Global Summit
Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring...
2015-07-02
257 reads
SQL Server BI Blog
Animated Graphics Depict The Fallen of World War II
In an amazing application of visualization techniques, this production is a depiction of the casualties and affects of war. Starting...
2015-06-07
411 reads
Animated Graphics Depict The Fallen of World War II
In an amazing application of visualization techniques, this production is a depiction of the casualties and affects of war. Starting...
2015-06-07
202 reads
Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches
This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty...
2015-05-27
481 reads
Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches
This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty...
2015-05-27
278 reads
New Articles About Datazen, Microsoft’s Mobile Dashboard Platform
I’m pleased to share the first two articles in a series for SQL Server Pro Magazine. Here’s a short excerpt...
2015-05-26
432 reads
New Articles About Datazen, Microsoft’s Mobile Dashboard Platform
I’m pleased to share the first two articles in a series for SQL Server Pro Magazine. Here’s a short excerpt...
2015-05-26
225 reads
Microsoft DataZen Mobile Platform Available to SQL Server Enterprise Customers for Free
Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise...
2015-05-05
837 reads
Microsoft DataZen Mobile Platform Available to SQL Server Enterprise Customers for Free
Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise...
2015-05-05
210 reads
DataZen Dashboards Update
I’ve spend a good three days on and off working with the new “Microsoft” DataZen dashboard tool and I think...
2015-04-29
1,401 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers