Rollback DBCC CHECKDB REPAIR !
I learned something new today while I was listening to one of the courses on corruption authored by the master,...
2014-02-06
1,567 reads
Blog Posts
SQL Server Diagnostic Information Queries for February 2014
I improved the file-level latency query this month and made some other small improvements to a few other queries. Rather...
2014-02-06
1,156 reads
Thank You!
I am humbled and honored (and more than a little horrified) to be on this list of the Best of...
2014-02-06
701 reads
Virtual Lab – Design and Setup
This is part of a series where I set up a virtual lab for testing and misc work. The other...
2014-02-06
1,293 reads
Virtualization resource consumption counters lie to you
OK, so maybe they do not lie to you, but I got your attention. In virtualized environments, the performance statistics...
2014-02-06 (first published: 2014-01-28)
2,130 reads
Your top 10 favorite Excel posts of 2013
The most popular Excel blog posts of 2013 reflect your interest in the new capabilities we’ve added to Excel this...
2014-02-06
348 reads
Automate T-SQL Merge For Loading Dimensions
If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve...
2014-02-05
1,335 reads
Free data & statistics, data collection, analysis, visualization and sharing – knoema.com
Knoema is a knowledge platform. The basic idea is to connect data with analytical and presentation tools. As a result,...
2014-02-05
556 reads
Just use Version Control
There are free systems out there. If you have no budget, and want to get started, download one of these:
Subversion:...
2014-02-05 (first published: 2014-01-28)
2,943 reads
Master Data Services for the Beginner Part 03
Introduction
In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very...
2014-02-05 (first published: 2014-01-28)
6,195 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