Good for the Goose
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
2009-08-07
579 reads
Articles
Good for the Goose
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
2009-08-07
600 reads
Good for the Goose
This Friday's poll asks you about having a fair set of benefits for extra time work. Steve Jones wants to know how your employer treats you.
2009-08-07
70 reads
Richard Stallman: Geek of the Week
Many famous geeks work away at their programs without considering the wider implications of what they, and others, are doing. Richard Stallman isn't like that. Richard (rms) is one of the great brains behind Linux distros, as he wrote the GNU compilers and GNU debugger. He is driven by strong opinions about the nature of free software, and the restrictive nature of software copyright. We sent our intrepid reporter, Richard Morris, to find out if Richard Stallman really required journalists to read parts of the GNU philosophy before an interview, for "efficiency's sake".
2009-08-07
2,874 reads
Scripting in SSIS
Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...
2009-08-07
3,559 reads
Simple Doughnut Chart for Analysis Services Data
Architect Bill Pearson leads the hands-on creation of a simple doughnut chart based upon an Analysis Services data source.
2009-08-07
3,212 reads
Compatibility issue and CROSS APPLY
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
2009-08-06
6,006 reads
Dedicated Administrator Connection - SQL School Video
If you have trouble connecting to a busy server, you'll want to watch this installment of SQL School. MVP Andy Warren shows how you can use the dedicated administrator connection (DAC) in SQL Server 2005 and above.
2009-08-06
8,123 reads
Agile Practices Meet Database Development: Intro
I think the database developer role is on the rise and that it's better suited for agile practices - but guidance...
2009-08-06
3,345 reads
An Introduction to SQL Server FileStream
Filestream allows us to store and manage unstructured data in SQL Server more easily. Initially, the accounts of FILESTREAM assumed prodigious powers of concentration and cognition, and we mortals all recoiled numbly. However, it became clear that we were missing out on some extraordinarily useful functionality, so we asked Jacob Sebastian to come up with a simple and clear-cut account of the FILESTREAM feature in SQL Server 2008. You'll agree he has managed the feat superbly.
2009-08-06
3,929 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