SQL Saturday #437–Boston BI Edition 2015–You Can Still Analyze Data with T-SQL
Thanks for attending my session on analyzing data with TSQL. I hope you learned something you can take back and...
2015-10-17
525 reads
Thanks for attending my session on analyzing data with TSQL. I hope you learned something you can take back and...
2015-10-17
525 reads
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2015-10-10
459 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-10-09
900 reads
My Session: Using Azure SQL Database for Enterprise Needs
On 10/6/2015, I presented on Azure SQL Database at TechFuse Minnesota. Some...
2015-10-06
469 reads
On Tuesday, September 15, I presented on this topic for Pragmatic Works. You can find that session here. This session...
2015-09-15
604 reads
As I noted in my previous post, I am not a fan of scripting. In that post we set up...
2015-09-04 (first published: 2015-08-25)
1,303 reads
Let me start by saying, I am not a fan of scripting. It definitely has its place and a lot...
2015-09-01 (first published: 2015-08-24)
1,453 reads
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help...
2015-08-28
1,516 reads
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help...
2015-08-27
700 reads
As I noted in my first post, I am not a fan of scripting. In that post we set up...
2015-08-26
902 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...
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
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 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 n;See possible answers