Actual Emails: What is a "soft delete"?
What's a "soft delete", and why should DBAs be aware of such behavior in tables?
So, a DELETE statement is a “hard” delete. The data is gone.
However, it is a...
2018-12-19
7 reads
Blog Posts
Infrastructure matters, even in the Cloud
I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK...
2018-12-19
279 reads
MongoDB – Basic Commands
We discussed about MongoDb installation and startup. I highly recommend to go though the training session which will provide a detail...
2018-12-19
205 reads
SQL Server Availability Group FailoverDetection Utility PowerShell Function Improvements – Named Instances, Archiving Data, Speed
In my last post I wrote about a new function for gathering the data and running the FailoverDetection utility by...
2018-12-19 (first published: 2018-12-01)
1,856 reads
SSIS Catalog Automatic Log Cleanup
Built into the SSIS catalog is a mechanism that can automatically purge log data after a set period of time. In this post, I’ll show you how to set...
2018-12-19
60 reads
T-SQL Tuesday Participation Over the Years
Loads of TSQL Tuesdays
Years ago the TSQL Tuesday party was started by Adam Machanic (b|t). The premise of the monthly event...
2018-12-19
229 reads
T-SQL Tuesday Participation Over the Years
I have personally participated in quite a large number of these TSQL Tuesday events - despite not being every single one. This is a roundup of my personal participation...
2018-12-19
4 reads
Turbo Charged Staging\Caching Tables With In Memory OLTP
Since SQL 2012 some really awesome new technologies have been introduced into the engine that are massively underused. Everyone is...
2018-12-19 (first published: 2018-12-03)
2,270 reads
Azure at the Ranch
From our webinar today, I mentioned I had a dog named “Azure”. Here she is.
No, this isn’t an homage to...
2018-12-18
356 reads
Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause
The Problem
During our workload we have recognized a difference in performance for queries using IN clause. We are building query...
2018-12-18
175 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
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:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
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