#SQLNewBlogger
Details:
System: 5.5GB of RAM, Windows 2008 R2, vmware, 4 cores, SQL Server 2012 Standard Edition. The database currently has the...
2015-05-05 (first published: 2015-04-28)
5,712 reads
Earlier this year, my buddy Dan recommended that I read The Checklist Manifesto: How to Get Things Right. The recommendation...
2015-05-05
523 reads
Reading Time: 2 minutesEver have this happen? You (on vacation): I’ll have another piña colada...
The post How Many SQL Log...
2015-05-05 (first published: 2015-04-22)
5,596 reads
Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise...
2015-05-05
837 reads
Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise...
2015-05-05
210 reads
If you’re in the Iowa City area, come to Iowa Code Camp this weekend! They have a great lineup of speakers, covering...
2015-05-05
412 reads
Most people prefer to have “sa” account as the database owner, primary reason being sa login cannot be removed/deleted unlike any...
2015-05-05
387 reads
Quick, short and sharp blog post for those interested in the latest and greatest that the SQL Server mothership has...
2015-05-05
551 reads
Quick, short and sharp blog post for those interested in the latest and greatest that the SQL Server mothership has to offer… It was announced by the Microsoft CEO...
2015-05-05
4 reads
It was announced yesterday at the Ignite conference that we’ll be getting a summer preview of SQL Server 2016. With...
2015-05-05
678 reads
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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