Thank you to @MrDenny
I wanted to take a quick moment to thank Denny Cherry for selecting me for Speaker Idol this year.
For...
2016-10-29
772 reads
Daniel Janik
Read this before using SQL 2016 Temporal Tables
I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of...
2016-10-26 (first published: 2016-10-17)
2,812 reads
Why I don’t love SELECT INTO
Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc...
2016-10-20
1,049 reads
Making the case for CamelCase naming
Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting...
2016-10-17 (first published: 2016-10-10)
3,857 reads
An observation about Unicode in SQL Server Management Studio
A week or so ago I read a blog post and tweet about using an emoji in SQL Server. This...
2016-10-14 (first published: 2016-10-02)
2,231 reads
A quick note comparing ISNULL vs COALESCE
There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...
2016-10-13
1,286 reads
Off-topic: If you’re in Texas and 18+ yrs old
Today is the last day to register to vote in Texas. I’m not sure about other states in the US...
2016-10-11
427 reads
Understanding the new MAXDOP settings in SQL 2016
If you have just begun using SQL Server 2016 or you have been using it for a while now you...
2016-10-05
3,086 reads
SQL 2016 SSMS memory leak?
Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...
2016-10-04
7,245 reads
I’m speaking at SQL PASS 2016 (Speaker Idol)
It’s always been my dream to speak at SQL PASS Summit. It’s a tough egg to crack. In my experience...
2016-09-29
779 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...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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