Are You A Technical Expert or Manager?
Expert or Manager? Why not both.
Are you a Technical Expert or a Manager? You certainly cannot be both.
At least that’s...
2013-01-29
963 reads
John Sansom
How To Win Career Gold
The start of a new working year is often a time for self reflection. This is a great thing, it’s...
2013-01-22
1,056 reads
Top 10 Free SQL Server Tools
What better way to kick off a new year than with a look back at some of the top free...
2013-01-15
12,895 reads
Step Up and Take More Ownership
This post is part of the T-SQL Tuesday Meme, this month hosted by Jason Brimhall. His chosen theme, to come up with...
2013-01-08
1,557 reads
Your Top 10 Posts of the Year
Top of the Flops
Short and sweet today, here’s what you enjoyed reading the most this year on the blog. No...
2012-12-17
781 reads
The Great DBA Getaway
Free, at last!
It’s holiday season which means it’s a time for you all to buy me gifts super busy time for Data...
2012-12-12
1,026 reads
A Journey To SQL Authority
I am delighted to welcome to the blog someone who is without a doubt one of the biggest names in...
2012-10-09
1,125 reads
Clients Love The Way I Jiggle
It’s one of the most enjoyable things about being a consultant.
I’m not talking about my suspect dance moves here. I’m...
2012-09-18
1,136 reads
Something for the Weekend – SQL Server Links 14/09/12
It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server Links,...
2012-09-14
1,530 reads
How To Simply Say You’re a DBA
Have you ever looked back on a conversation where someone asked you “what do you do?” and felt disappointed with your reply?...
2012-09-03
976 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