Making Your Career Go Further
Steve Jones comments on a few things that can help you, and are worth keeping in mind as you interact with people.
2010-06-21
251 reads
Editorial
2010-06-18
265 reads
Selling Used Cars
Today we have a guest editorial from Andy Warren that looks at the value of experience.
2010-06-17
212 reads
Archive Backups
The need to archive data is becoming more and more important as data sizes grow. However when you choose to archive data, you might need to reconsider how your DR plan is structured.
2010-06-16
248 reads
Google FUD
A recent headline that Google is dumping Windows because of security issues sounds like FUD to Steve Jones.
2010-06-15
230 reads
A new IDE for SQL Server?
Microsoft have been cooking up something for Database Developers in Visual Studio 2010, and Phil Factor has decided it's high time he looked into it. It's not as odd as it sounds, and is actually rather promising, as Phil discovers.
2010-06-14
373 reads
Finding the Context
Will computers become better at finding context in situations and environments? Steve Jones comments.
2010-06-14
88 reads
Bad Database Design
A guest editorial from Andy Warren looks at a bad database design he recently ran across.
2010-06-11
1,297 reads
Is the MVP Worth It?
The MVP award is coveted by many people and there are constant questions about how to get it. Is it worth it? Steve Jones talks about that today.
2010-06-09
306 reads
2010-06-08
89 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