Renewed as Microsoft MVP 2019-2020
I are thrilled to announce that I has been renewed for the sixth time as a Microsoft Data Platform MVP for 2019 to 2020. The MVP award remains incredibly...
2019-07-09
9 reads
Blog Posts
SELECT Expression Execution Order
Watch this week's video on YouTube
Today I want to share with you an interesting observation I made about SELECT expression execution order.
I was working on writing a dynamic SQL...
2019-07-09
6 reads
SELECT Expression Execution Order
Watch this week's video on YouTube
Today I want to share with you an interesting observation I made about SELECT expression execution order.
I was working on writing a dynamic SQL...
2019-07-09
8 reads
The Azure-SSIS IR Startup Time
If you want to run SSIS packages in Azure Data Factory, you need the Azure SSIS Integration Runtime (quite the mouthful), which is basically a cluster of virtual machines...
2019-07-09 (first published: 2019-06-19)
358 reads
What about orphaned windows users?
I should start off by mentioning that this post is applicable to sql server versions 2012 and up. If you have an older version of sql server, the solution...
2019-07-09 (first published: 2019-06-26)
1,843 reads
SQL Saturday Albany NY 2019
I am pleased to announce that I will be presenting at SQL Saturday #855 in Albany, NY on July 20, 2019. Join me at 2 PM in room LC05...
2019-07-08
1 reads
The Microsoft Power Platform
The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow. I find customers are confused on the use cases of these products and how they...
2019-07-08 (first published: 2019-06-25)
311 reads
Workload replay with WorkloadTools
In my last post, I described how to capture a workload to a file, in order to run a replay against your target environment at a later time. Well,...
2019-07-08 (first published: 2019-06-20)
1,112 reads
Last Week Reading (2019-07-07)
Hello, data eaters! Today, coming back from my friend by car, I was browsing a few posts on my cell (calmly – my wife was driving). At some point,...
2019-07-07
16 reads
Comparing Execution Plans
When you run a query twice, and get dramatically different run times, your first step can be to try to identify the differences in execution plans. For many that...
2019-07-05 (first published: 2019-06-19)
930 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