SQL Server Crossword #3 – Solution
Here’s the solution to SQL Server Crossword #3.
I hope you enjoyed it. Let me know if you would like me...
2011-03-27
1,013 reads
John Sansom
SQL Server Crossword #3
To mark my 30th Birthday today, as promised here’s a SQL Server Crossword for you to enjoy. You can find the previous...
2011-03-23
1,554 reads
SQL Server Crossword #3
To mark my 30th Birthday today, as promised here’s a SQL Server Crossword for you to enjoy. You can find the previous...
2011-03-21
1,400 reads
How to Raise Your Game by Doing Nothing
What if I told you that you could become a more effective Database Administrator by doing nothing?
That’s right, in this...
2011-03-08
479 reads
How to Get a Head Start on Performance Tuning
The problem with performance tuning is that it is commonly considered as secondary to the task at hand rather than...
2011-03-01
711 reads
5 Things Every DBA Should NOT Do
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natural...
2011-03-01
5,946 reads
5 Things Every DBA Should NOT Do
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natural...
2011-02-22
3,600 reads
London UK SQL Server User Group – It’s Back!
"We're back with a Bang!"
In case you missed it, being tucked away amongst all the other UK SQL Server User...
2011-02-21
638 reads
The DBA Ultimate Fitness Workout Plan
If you plan to stay on top of your DBA game then you have to workout regularly.
Those of you that...
2011-02-15
718 reads
10 Things Every DBA Should Do
Recently I spoke about how The Best Database Administrators Automate Everything, as well as Document Everything and this got me...
2011-02-08
2,272 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