Hustle and Bustle to Kick off September
September is kicking off with a boom for me. In one week, it seems I will be here, there and...
2011-09-07
812 reads
Jason Brimhall
S3OLV September 2011
I really meant to get this post out last week. My apologies, but here is the post finally. Along with...
2011-09-06
784 reads
S3OLV September 2011
I really meant to get this post out last week. My apologies, but here is the post finally. Along with the post, I also had meant to get the...
2011-09-06
4 reads
Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little warning and error message to greet me. My activation...
2011-09-01
3 reads
Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little...
2011-09-01
589 reads
Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just...
2011-08-31
1,803 reads
Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just to make some minor updates and clarifications. This is...
2011-08-31
7 reads
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else. In SQL, we should be well aware of Precision...
2011-08-24
6 reads
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else....
2011-08-24
2,861 reads
TSQL Sudoku II
As luck would have it, today I came across this TSQL Challenge. It just so happens that I had already...
2011-08-23
1,078 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