Quick Hits on the News for Nov 12, 2007
A few comment on the database news for the week ending 11/10/07
2007-11-12
31 reads
Editorial
Wiggle Room
Consultants sometimes don't live up to their hype. To what extent should we expect them to know exactly what they're doing? This editorial was originally published on Nov 9, 2007. It is being republished as Steve is on vacation.
2012-08-08 (first published: 2007-11-09)
184 reads
2007-11-08
48 reads
Which Platform Do You Work On?
The growth of SQL Server's subsystems leaves Steve Jones wondering how should we be thinking about the product.
2007-11-07
125 reads
Whack a Database
The SQL Server team is looking for feedback on deleting databases and Steve Jones gives a few ideas.
2007-11-06
102 reads
2007-11-05
749 reads
The Personal Checksum
An interesting method of preventing restaurant fraud and a poll for other ways to determine the accuracy of data. This editorial was originally published on Nov 2, 2007. It is being republished as Steve is on vacation.
2012-08-30 (first published: 2007-11-02)
273 reads
Unstructured Data
I remember when Windows 3.1 started to gain widespread deployment in businesses. With all it's WYSIWYG features and multiple applications running at the same time, many people felt we'd get to a paperless office. Over a decade later I rarely see an office that doesn't have a copy machine and at least one printer. We've gotten better at shuffling bits, but we haven't gotten rid of paper.
2007-11-01
135 reads
2007-10-31
2,803 reads
October Energy Update
A recap of the world of energy from the previous two months. Steve looks at solar, wind, nuclear, and more.
2007-10-30
63 reads
Blogs
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...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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