Smart Teaching
Do computers help us learn quicker? Do we need to in today's wired world? Steve Jones talks a little about learning in today's editorial
2008-12-23
83 reads
Editorials
The Set-Based Limit
An interesting post from Linchi Shea inspires Steve Jones to comment on procedural v set-based programming.
2008-12-22
520 reads
The Best Computer
Hollywood does a great job of showing off technology that might be possible someday. This Friday Steve Jones wonders what amazing computer you'd like to have.
2008-12-19
244 reads
Guest Editorial: That ain't a Database, it's a Spreadsheet
Phil recently had to draw up a list of 'top ten' pieces of advice for programmers who were starting out as database developers. It is a difficult thing to do when one is immersed in the study of the intricacies and detail of the plumbing of SQL Server.
2008-12-18
440 reads
Learning Priorities
Steve Jones talks a bit about the value of learning for DBAs and other IT professionals.
2008-12-16
477 reads
Career Challenges - Database Weekly (Dec 15, 2008)
This week Steve Jones sees a lot of people talking about challenges in their career.
2008-12-15
243 reads
Simple Metadata
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
2008-12-15
349 reads
Guest Editorial: On writing SQL
The exceptional talents of seasoned engineers and developers can never quite be rendered obscelete by technological wizardry. Phil Factor considered old-school intuition, and wonders if he's missed a trick.
2008-12-12
481 reads
Versioning Over Time
How do you handle the tracking of changes across time in a database? Not auditing, but the actual structural and schema changes. Steve Jones talks about some of the issues with rapidly changing versions.
2008-12-11
353 reads
Alone Time
Working in a distributed team can be challenging, but working in an office can be just as difficult. Steve Jones talks a bit about time management today.
2008-12-10
173 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