Resolution of Database Consistency Error in SQL Server
There are so many facilities and amenities in SQL Server along with built-in methods, which assist users in some bad...
2017-02-16
1,936 reads
Blog Posts
True story: Encryption in progress stuck
Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was...
2017-02-16
375 reads
Updates to the Power BI course
Recently I published an open-source course/workshop to learn Power BI Desktop. Fellow MVP Dan English (blog | twitter) gave me the...
2017-02-16
485 reads
Azure Advisor Recommendations
Logging into the Azure portal is a daily task of mine and my eyes light up when I see features...
2017-02-15
334 reads
Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)
Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing with the spirit of the previous...
2017-02-15
464 reads
DBA 101: What you may be missing with “Missing indexes”
If you’ve read my blog, I’m sure by now you know that I have no love for GUI tools. I...
2017-02-15 (first published: 2017-02-08)
3,376 reads
Power BI Custom Visuals Class (Module 37 – Gap Analysis)
In this module you will learn how to use the Gap Analysis Power BI Custom Visual. The Gap Analysis visual...
2017-02-15 (first published: 2017-02-08)
2,417 reads
PowerShell Virtual Group of PASS February Newsletter
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting...
2017-02-15
490 reads
PowerShell Virtual Group of PASS February Newsletter
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting tonight (this afternoon, tomorrow, whichever time zone you’re in)....
2017-02-15
4 reads
PowerShell Virtual Group of PASS February Newsletter
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting tonight (this afternoon, tomorrow, whichever time zone you’re in)....
2017-02-15
18 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