Reblog: November 2 to November 8
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-11-09
511 reads
StrateSQL
PASS Summit – Day One
Thought I would put up a quick post to summarize day one of regular sessions at the PASS Summit. It...
2012-11-08
630 reads
PASS Summit First Sessions Tomorrow
Are you in Seattle yet? Still working on getting here? Tomorrow is the first day of regular sessions at this...
2012-11-06
711 reads
Last Weeks Top 10 “Reading” Links #5
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-05
610 reads
PASS 2012 Countdown – 0 Weeks to Go!
Seriously, the clock is ticking and you should be in your car or a plane for PASS Summit by now. ...
2012-11-05
679 reads
Ask the Unicorn: Do I have to sing at SQL Karaoke?
The PASS Summit is coming up next week and that means that as the sun goes down, a number of...
2012-11-02
589 reads
Lost in Translation – Deprecated System Tables – sysindexes
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-01 (first published: 2012-10-29)
3,303 reads
Learn Good / Do Good
Obviously the title of this post is an exercise in bad grammar, but it’s a little catchy. Well, maybe not,...
2012-10-31
1,481 reads
Pro SQL Server 2012 Practices Released Today
Happy Halloween! Are you looking for the perfect treat for your SQL Server costume?
Well, if so – I have the treat...
2012-10-31
11 reads
Lost in Translation – Deprecated System Tables – sysindexkeys
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-30
1,508 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