Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to...
2017-10-11
458 reads
Born SQL with Randolph West
Changes to Service Packs and Cumulative Updates for SQL Server 2017
For a few years now, Microsoft has augmented its irregular release of Service Packs with a more frequent Cumulative Update...
2017-10-04
444 reads
Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
545 reads
Does rebuilding my clustered index also rebuild my non-clustered indexes?
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered...
2017-09-20
433 reads
A trillion and one
Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in...
2017-09-13
443 reads
Connect Windows 10 client to a VPN on Windows Server 2012 R2
I got a strange request in a Slack channel the other day. A colleague in South Africa, who uses Windows,...
2017-09-06
389 reads
What you need to know about memory limits on SQL Server
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max...
2017-08-30
343 reads
Speaking at SQLSaturday #635 in Vancouver this weekend
This coming weekend, at SQLSaturday #635 in Vancouver BC, I will be presenting a brand new talk about Temporal Tables,...
2017-08-23
123 reads
Microsoft presents: MySQL and PostgreSQL?
For the longest time, MySQL has been the recommended database platform for blogs and other websites. It’s free. It’s available...
2017-08-16
152 reads
This is how I recovered from a catastrophic failure
I was fresh off the boat* from South Africa, working in a small computer store in an equally small town...
2017-08-09
148 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