Continuous Learning
In case you can’t tell from some of my blog posts, I’m a bit of an advocate for DevOps. I’m extremely fortunate in my employer, Redgate Software, that they...
2019-07-01
128 reads
Blog Posts
Honored to be a Microsoft MVP
Today is the renewal date for Microsoft MVPs. I received an email a short while ago informing me that I was being awarded again for the July 2019 –...
2019-07-01
19 reads
It’s an Honor: Microsoft MVP
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:
How to be an MVP Book November 28, 2018...
2019-07-01
26 reads
It’s an Honor: Microsoft MVP
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:
Data Platform MVP 2020 August 12, 2020
How to...
2019-07-01
5 reads
Public Role Permissions – Back to Basics
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...
2019-07-01 (first published: 2019-06-17)
351 reads
Scalar Valued Functions in SQL Server 2019
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-07-01 (first published: 2019-06-18)
1,619 reads
SQL Homework – July 2019 – Table Size
In general this homework series is meant to give you ideas of things to play with that most if not ... Continue reading
2019-07-01
135 reads
Weekly reading #20
Being MVP for the #11 straight year is something unique! Thank you! The first week of July has just started. So oficially we have started vacations and the team...
2019-07-01
15 reads
Thanks for Joining us at SQLSaturday Pensacola!
Thanks for joining us at #SQLSatPensacola!The 8:30am Careers in Technology panel featured lots of talk about Twitter, so might as well mention that the panelists were (in audience's order,...
2019-06-30
8 reads
Powershell script to find SQL Server instances on remote servers
This is actually part 2 of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there will be a series of...
2019-06-28
7,576 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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