Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
2009-01-29
86 reads
Editorial
Earning Credit
The topic of plagiarism rears its head at SQLServerCentral and Steve Jones has some comments and an apology.
2009-01-28
377 reads
The January 2009 Car Update
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
2009-01-27
149 reads
DBAs and the art of persuasion
How does a DBA go about "pitching" for money for a software tool, or any other resource? And what factors affect the likelihood of success? We all think we know, but could we do this part of the job more effectively?
2009-01-26
91 reads
The Cost of Reboots
Would you want to have your pay docked for time spent rebooting? It seems some companies are trying to do just that.
2009-01-26
245 reads
2009-01-23
217 reads
Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
2013-09-13 (first published: 2009-01-22)
214 reads
Secure Cell Phones
With the inauguration of a new President in the US, will he give up his Blackberry? Steve Jones found an alternative that was surprising.
2009-01-21
149 reads
Managing Your IT Data
A new application manages data from your IT machines and software, but doesn't use a database. Steve Jones talks a little about this. (This editorial was originally published on Jan 20, 2009. It is being re-run as Steve is at SQL Bits.)
2013-05-02 (first published: 2009-01-20)
276 reads
Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
2009-01-19
308 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