2008-04-07
1,800 reads
Articles
Building and customizing SQL Server script templates
There is not enough time in the day to keep it all straight! There is no shame in making use of any short cuts or cheats that allow you to be a more productive and well-versed SQL Professional in order to cope with the sheer volume of expectations you are required to meet on a daily basis.
2008-04-07
3,496 reads
Securing Data
It's important that you do more than just implement perimeter security with firewalls. Steve Jones talks about how we can better secure our systems.
2008-04-07
36 reads
Securing Data
It's important that you do more than just implement perimeter security with firewalls. Steve Jones talks about how we can better secure our systems.
2008-04-07
27 reads
Securing Data
It's important that you do more than just implement perimeter security with firewalls. Steve Jones talks about how we can better secure our systems.
2008-04-07
44 reads
TSQL String Array Workbench
Robyn Page and Phil Factor show how to use XML-based arrays to make string handling easier in SQL Server 2005/2007, and illustrate the techniques with some useful functions
2008-04-07
2,521 reads
The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
2008-04-06
31 reads
The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
2008-04-06
29 reads
The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
2008-04-06
43 reads
No XP, but Look Forward To 7
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
2008-04-05
191 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