Data Compression Double Take
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-05
267,356 reads
Editorial
High Availability Upgrades
Today Steve Jones has a poll about the new AlwaysOn feature in SQL Server 2012. Is it worth the upgrade for your company?
2012-03-02
264 reads
Data Compression Double Take
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-01
338 reads
Use the 4th Dimension
Today Steve Jones talks about the conflicting demands of home and work and how you can reconcile the requirements of both.
2012-03-01
199 reads
The Cloud is good for your career
Is the cloud good for your career? Steve Jones thinks so, and gives you a few reasons you might want to learn more about it.
2012-02-29
267 reads
Taking a Sabbatical
Today we have a guest editorial from Andy Warren as Steve is on vacation. Today Andy discusses sabbaticals, and a change in his life.
2012-02-28
159 reads
The Power of Hadoop
Hadoop is an open source framework for working with data, and one that Microsoft has adopted. Is it worth using in your environment? Steve Jones thinks you should investigate it.
2012-02-27
791 reads
Call That a Database? This is a Database.
If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry.
2012-02-27
280 reads
A Break from Databases
A Friday poll that's a break from work, and should be a bit of fun. Today Steve Jones asks about movies, and what's been interesting from the last year.
2012-02-24
162 reads
Future Virtual Machines
What's the benefit of virtual machines and hypervisors? Steve Jones has a few comments on them and their future.
2012-02-23
343 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