BYOC
With people becoming smarter about technology, does it make sense for them to choose their own computer? Steve Jones thinks so.
2008-11-16
639 reads
Editorial - WMV
Ethics in IT - Database Weekly (Nov 17, 2008)
Employers say they're looking for more ethics and morals in IT for 2009. Steve Jones hopes it's true.
2008-11-16
733 reads
How Productive Are You?
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
2008-11-13
128 reads
Twitter Your Issues
Twitter is one of those interesting Web 2.0 ideas that is hard to analyze. Is it valuable? Steve Jones might have an idea for how it could be used by DBAs.
2008-11-12
611 reads
Fix the Little Things
There are any number of small, annoying or tedious things in SQL Server and Steve Jones makes a case for getting them fixed.
2008-11-11
801 reads
DBA Value
Are DBAs worth more to a company than other types of IT employees? Steve Jones has some thoughts about the salary ranges for DBAs today.
2008-11-10
624 reads
The Security of You
There is a lot of data out there that is specific to an individual, none more important perhaps than biometric data. Steve Jones writes a bit about the security implications involved in working with this data.
2008-11-09
662 reads
Creative SPAM
SPAM permeates all aspects of our lives. Steve Jones takes a poll today about which messages might have caught your eye.
2008-11-06
574 reads
Testing Service Pack 3
Who is responsible for Service Pack testing? Ultimately it's Microsoft, but Steve Jones reminds us we make a difference as well.
2008-11-05
75 reads
Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
2008-11-04
162 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