SQL Server on Linux is Just SQL Server
Steve Jones looks at SQL Server on Linux and how this may differ from what most of us have worked with in the past.
2017-04-27
99 reads
Editorials
Becoming a Data Scientist
The path to becoming a data scientist isn't simple or easy, but it might be for you.
2017-04-26
186 reads
2017-04-25
256 reads
Have you ever given up on your brainchild
Have you ever given up on your brainchild? If yes, how did you deal with it?
2017-04-24
112 reads
It's all about Customer Service
Grant Fritchey on the lessons all DBAs can learn from the recent Public Relations disaster for United Airlines.
2017-04-24
77 reads
How do you come up with creative ideas?
It takes a creative mind to come up with new ideas. So how do you do it?
2017-04-21
109 reads
2017-04-20
366 reads
SQL Server Telemetry
SQL Server captures information about usage and send it to Microsoft. Is that a problem? Not for Steve Jones.
2017-04-18
862 reads
Liable for Data Loss
Today Steve Jones looks at some data loss lawsuits against Microsoft, but asks the general question of whether software vendors need to be more liable (and careful).
2017-04-17
69 reads
More Power in Your BI
This week Steve looks at all the information and learning available for Power BI.
2017-04-17
124 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