SQL Saturday #200 - Philadelphia
If you read my post from yesterday you will know I will be spending some time on the US east...
2013-05-08
779 reads
Gethyn Ellis
SQL Server Travels–May 2013
At the end of this month of May, I will be teaching Learning Tree’s 3 day SQL Server Virtualization course...
2013-05-07
781 reads
SQL Server Training in the Summer Time
Its been a long winter so far this weekend has seen the first signs of spring here in South Wales,...
2013-04-22
674 reads
Friday Fun – Football Derbies
This is an off-topic post for a Friday. With Cardiff City reaching the premier league this week and all the...
2013-04-19
613 reads
TSQL Tuesday #41–Presenting and Loving it?
Well sort of…it took a while.
I’d done some plays and singing at school but my mother made me practice...
2013-04-09
863 reads
@LearningTree: SQL Server High Availability
Learning Tree are offering their 3 day SQL Server High Availability course this April in London. Running between 17th and...
2013-03-28
1,468 reads
Slide Deck–SQL Saturday Exeter
In my session (An Introduction to SQL Server Virtualisation) at SQL Saturday Exeter I told the attendees that I would...
2013-03-13
859 reads
SQL Saturday Exeter - Review
This last weekend I attended my first SQL Server Saturday event. The event was held in The Jury’s Inn in...
2013-03-11
836 reads
SQL Saturday - Exeter
This time tomorrow morning I will be on my feet starting to deliver a 50 minute session at SQL Saturday...
2013-03-08
880 reads
SQL Saturday Exeter - I'm speaking
Just short post for a Friday. This Saturday (tomorrow) I will be speaking at SQL Saturday 194 which is being...
2013-03-08
713 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...
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...
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