How Azure Storage Kick Starts Your Big Data Projects
So, your boss says, ‘Let’s do big data!’ And you think: ‘I don’t even know what that means or what...
2018-08-29
979 reads
So, your boss says, ‘Let’s do big data!’ And you think: ‘I don’t even know what that means or what...
2018-08-29
979 reads
Azure accounts vs. Azure subscriptions – often a topic that brings some confusion to Azure newbies. Are they the same? What’s...
2018-08-28
205 reads
Are you just starting out with Azure and wonder: What is Azure Resource Manager (ARM) Deployment Model? Or what’s the...
2018-08-27
264 reads
As you likely know, I am a Principal Consultant at Pragmatic Works. This year we have been doing some great...
2018-08-25
387 reads
Power BI Report Server was released as a way to host reports on premises. It was one of the highest...
2018-05-31
522 reads
Cosmos DB is one of the fastest growing Azure services in 2018. As its popularity grows, data professionals are faced...
2018-05-24 (first published: 2018-05-16)
2,852 reads
The following has been reposted with permission from Steve Howard a.k.a. @AngryAnalytics. I have made some formatting changes but the...
2018-05-24
441 reads
I was able to present at SQL Saturday Dallas this year. Thanks to those of you who were able to...
2018-05-22
205 reads
Microsoft has expanded sharing by allowing users to share Power BI content via email. In a previous post, I discussed...
2018-04-02 (first published: 2018-03-22)
2,125 reads
Microsoft recently added more sharing capabilities that may change my view on sharing within the enterprise. As with all things...
2018-02-06 (first published: 2018-01-29)
1,643 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
i have huge table with lot of data and is also wide. i took...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers