SSDT – Installation confusion
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual...
2012-04-13
11,497 reads
James Serra's Blog
Consultants: Corp-to-Corp vs 1099
I blogged previously that when you are a consultant or contractor, you can sometimes be faced with the decision when...
2012-04-11
5,552 reads
SSAS development quick tip
When creating a new cube in SSAS, you are frequently making changes that cause the whole cube to reprocess when...
2012-04-09
1,957 reads
SQL Server 2012: Installing on a Virtual Machine
Now that SQL Server 2012 RTM is out, I have an update to my blog post SQL Server 2012 (“Denali”): Installing...
2012-04-06
15,155 reads
SQL Server 2012: Multidimensional vs tabular
To expand on what I talked about in SQL Server 2012 (“Denali”): Details on the next version of SSAS, there is...
2012-04-04
6,547 reads
SQL Server 2012: SSAS enhancements
My previous blog, SQL Server 2012 (“Denali”): Details on the next version of SSAS, talked about the major new feature in...
2012-04-02
2,689 reads
BIDS Helper 1.6 for SQL Server 2012 released
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2012-03-30
2,531 reads
TinyInt problem in SSAS
If you have a source table that has a Tinyint primary key column defined as IDENTITY and you create a...
2012-03-28
1,608 reads
SQL Server Parallel Data Warehouse (PDW) Appliance Update 3 (AU3)
In the next few weeks there will be an update to the SQL Server Parallel Data Warehouse (PDW) called “Appliance Update 3?...
2012-03-26
2,047 reads
Dell Quickstart Data Warehouse Appliance for SQL Server 2012
As a follow-up to my blog Microsoft SQL Server Reference Architecture and Appliances, Dell recently announced the future availability of Dell Quickstart...
2012-03-23
1,308 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