Friends of Redgate 2015
Reading Time: 2 minutes
It’s official, I am in Friends Of Redgate for 2015!
Ok, the last few months have been an...
2015-01-27
818 reads
WaterOx SQL
Identify Primary Keys That Are Not Identity Columns
Reading Time: 3 minutesPrimary Keys help keep your database in balance
Continuing the thoughts of knowing what is going on in...
2015-01-13
1,148 reads
Have We Devalued SQL Server Consulting?
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training of SQL Server...
2014-11-21
617 reads
Have We Devalued SQL Server Consulting?
Reading Time: 3 minutes
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training...
2014-11-21
336 reads
12 Things To Check With SQL Server To Prepare For Winter
Winter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts are predicting massive...
2014-11-14
1,065 reads
12 Things To Check With SQL Server To Prepare For Winter
Reading Time: 8 minutesWinter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts...
2014-11-14
635 reads
Versioning In Your SQL Database
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking about version control,...
2014-11-12 (first published: 2014-11-07)
6,991 reads
Versioning In Your SQL Database
Reading Time: 4 minutes
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking...
2014-11-07
638 reads
When Things Align Unexpectedly
Things are happening
or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have aligned. I am...
2014-11-02
872 reads
When Things Align Unexpectedly
Reading Time: 4 minutesThings are happening
or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have...
2014-11-02
405 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