Curious case of SYS.MESSAGES
A strange error struck me last week, and this post is all about that.
What you normally expect when you run...
2016-03-15 (first published: 2016-03-07)
2,047 reads
SQLSailor.com
Curious case of SYS.MESSAGES
A strange error struck me last week, and this post is all about that. What you normally expect when you run SELECT * FROM sys.messages? The query will return a...
2016-03-07
5 reads
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.
The transport...
2016-01-28
2,164 reads
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable. The transport security involves encryption of packets exchanged between the...
2016-01-28
7 reads
SQL Server 2016 CTP 3 Setup – UI Improvements
There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making...
2015-11-11
807 reads
Azure Virtual Machine Blog Series – Changing the size of a VM
I’m starting a new blog series on Microsoft Azure Virtual Machines, and my goal is to write blog posts exclusively on...
2015-09-30 (first published: 2015-09-24)
2,803 reads
SQL Server Data Tools is now a separate installer – Things to know!
Recently I had to develop some SSRS report, and my desktop machine had SQL Server 2014 installed on it. I...
2015-09-08
1,289 reads
Why I won’t be running SQL Server Standard Edition on Business Critical Servers!
I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a...
2015-07-09
1,151 reads
Installing SQL Server 2016 CTP2 – UI Changes
SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No,...
2015-05-29
3,246 reads
Full Domain Trust and Natively Compiled Stored Procedures – In Memory OLTP
Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored...
2015-06-03 (first published: 2015-05-26)
1,358 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