Tech Lunch News
Ve středu 9.3.2022 jsme se tradičně sešli nad novinkami ze světa dat, datových skladů, Power BI, Azure apod. Jestli jste chyběli (ale příště dorazíte, že? :D), zde je malý...
2022-04-04
4 reads
Blog Posts
Two Years of “Good Morning!”
Two years ago at the start of the pandemic, I wasn’t feeling great about things. I saw that quite a few others weren’t all that thrilled about how things...
2022-04-04
36 reads
Daily Coping 1 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-01
25 reads
Power Automate – Returning the Last Day of the Month
Have you ever needed to set a property or field to the last day of the month? This is a common business problem that can
2022-04-01 (first published: 2022-03-25)
404 reads
Starting LocalDB–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Lots of people have never worked with LocalDB,...
2022-04-01 (first published: 2022-03-28)
211 reads
Daily Coping 31 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-31
14 reads
KQL Series – Big Data Analytics with Azure Data Explorer
This blog pos illustrates how Azure Data Explorer and Azure Synapse Analytics complement each other for near real-time analytics and modern data warehousing use cases. This solution is already...
2022-03-31
42 reads
KQL Series – create a database in our ADX cluster
In the previous blog post we created an Azure Data Explorer (ADX) cluster. In this blog post we will create a database that we will ingest data into, as...
2022-03-31
64 reads
KQL Series – create an Azure Data Explorer cluster
I have written a lot about the magic of KQL and the brilliance of Azure Data Explorer. Now we should create a cluster of our own that hosts Azure...
2022-03-31
18 reads
KQL Series – creating KQL queries
Basically when we are writing KQL we are asking the following questions: Does it exist? Where does it exist? Why does it exist? What shall we do with the...
2022-03-31
25 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers