Queues in Databases
The idea of using a queue in a database is one that some people try to avoid, preferring to use a messaging service. However, Steve Jones notes that this isn't always necessary.
2016-02-03
191 reads
Editorial
Maybe Security is Harder than Rocket Science
It's hard to build strong security over time, but it's worth the effort. Steve Jones notes that even smart people have problems implementing strong security.
2016-02-02
116 reads
Bogging Down in the Minutia of Minutes
Rodney Landrum gets lost in the fourth dimension, while coding the infinite possible combinations of SQL Server dates and times.
2016-02-01
82 reads
What is the True Version of Code?
What version of your code is the true one? Steve Jones talks some version control today.
2016-02-01
192 reads
Too much information can be counter-productive
If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say
2019-09-02 (first published: 2016-01-29)
376 reads
Training at the Top
Today Steve Jones looks at security training and the need for understanding from upper management.
2016-01-28
96 reads
DeveloperBall
Steve Jones looks at the challenges of putting a team together of wildly different skill levels.
2016-01-26
118 reads
Crafting Your Resume
Today Steve Jones talks about how you can present yourself better within the confines of a resume.
2016-01-25
190 reads
Design a Better SQL Server Pricing Model
Today we have a guest editorial from Andy Warren that talks about SQL Server the no one's favorite topic: licensing.
2016-01-21
170 reads
Turn Out the Lights
Today we have a guest editorial from Andy Warren that looks at the costs associated with our behavior.
2019-09-06 (first published: 2016-01-18)
435 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