Are Indexes Actually Changes to the System?
Is an index change equivalent to a code change? Steve Jones asks the question and has a few thoughts.
2018-10-02
175 reads
Editorial
Give Up on Natural Primary Keys
With the need to remove older data, Steve thinks natural keys may be obsolete.
2018-10-01
219 reads
The Ever Expanding Data Platform
With lots of news coming out of Ignite, Steve talks about a few of the changes.
2018-10-01
49 reads
Picking the Right Type of Tool For the Job
Do we need the right tool or just a tool? A guest editorial from Andy Warren gives a few thoughts on getting things done effectively.
2018-09-28
61 reads
An Open Thank You to the Microsoft SQL Server Team
Thanks for improving the string or binary data truncated error message.
2018-09-27
183 reads
The Uninteresting But Necessary Work
Data classification may not be fun or even interesting, but it is necessary.
2018-09-26
74 reads
2018-09-24
76 reads
2018-09-24
147 reads
Fitting Into RAM
Will your database fit into RAM? Steve Jones asks you to think about the possibility.
2023-07-05 (first published: 2018-09-21)
285 reads
2018-09-20
57 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...
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...
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