Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
2009-06-24
164 reads
Editorial
Becoming a DBA
Steve Jones was recently asked how he knows someone is ready to be a DBA. It's an interesting question and he shares some thoughts on this today.
2009-06-23
342 reads
Grown Up Software
We all want to write better software, but do we really want to write grown up software? Steve Jones talks about one of the most successful software groups ever.
2009-06-22
180 reads
Lax Security - Database Weekly (June 22, 2009)
This week Steve Jones talks about database security, or the lack thereof, in today's world.
2009-06-22
122 reads
Going Native
This Friday Steve Jones asks about advice for other DBAs. What's the best way for those intermediate and accidental DBAs to handle maintenance on their servers?
2009-06-19
136 reads
The Best Minds
What do you want when you go to a conference? Great speakers or great information? Steve Jones talks a little about how we get both in the future.
2009-06-18
74 reads
Why Object Databases will always be Tomorrow's Technology
For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?
2017-02-21 (first published: 2009-06-17)
751 reads
The Simple Estimate
Why can't it be easy for someone to tackle small projects? It is in some areas, and Steve Jones talks a little about some of the issues.
2009-06-16
103 reads
Barriers to Virtualization
Virtualization, and use of the 'cloud', will be essential to the deployment of new applications, but will existing applications will be quite so amenable?
2009-06-15
280 reads
Are You an Exceptional DBA?
The Exceptional DBA award is back again in 2009. Steve Jones comments a little on his experience last year.
2009-06-15
190 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