Daily Coping 4 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-04
18 reads
Blog Posts
Data Engineer Diary: How to restrict Power BI Gateway installation
Have you ever wondered whether it is possible to restrict installation of the Power BI Gateways (GW) in your tenant? If so, read along… The first question that probably...
2022-04-04
44 reads
Data Engineer Diary: How to take over Power BI Gateway
Sometimes when you start to work on a project there may be an immediate need to use Power BI Gateway(s). For instance, you need to do some PoC, or...
2022-04-04
28 reads
Power BI – unpivotování více než jednoho řádku
Nedávno jsem se potkal se situací, kdy jsem měl jako zdroj pro Power BI Excel, který vypadal jako kontingenční tabulka, kde v řádcích byly „Produkt“ a „Provozovna“ a ve...
2022-04-04
5 reads
PowerShell kvíz – a modří už vědí?
Nedávno jsem narazil na „záhadu“. Schválně, jestli jí přijdete na kloub. 🙂 Bude to jednoduchá funkce s jedním řádkem v těle, takže se nebojte. Nejdřív první příklad: Co myslíte, že ten...
2022-04-04
5 reads
PROČ SE STÁT DATA ENGINEEREM?
Tento blog jsme pro vás napsali v souvislosti s naším novým náborovým programem JOYFUL CRAFTSMEN BOOTCAMP, který je určen pro absolventy, junior data engineery a ostatní nadšence, kteří mají nebo dokonce...
2022-04-04
18 reads
Scripting with a temp stored procedure
A few years back I learned about temporary stored procedures from a Kendra Little (blog|twitter) blog post. At the time ... Continue reading
2022-04-04 (first published: 2022-03-17)
538 reads
Self-hosted integration runtime
V rámci svojho bootcampu (https://joyfulcraftsmen.com/bootcamp/) v Joyful Craftsmen, na ceste stať sa Data Engineerom, som sa často (rozumej takmer vždy) stretol s novými technológiami. Keďže jednou z bežných činnosti...
2022-04-04 (first published: 2022-03-22)
232 reads
Self-hosted integration runtime
V rámci svojho bootcampu (https://joyfulcraftsmen.com/bootcamp/) v Joyful Craftsmen, na ceste stať sa Data Engineerom, som sa často (rozumej takmer vždy) stretol s novými technológiami. Keďže jednou z bežných činnosti...
2022-04-04
10 reads
SQLpassion Live Training about Query Tuning Fundamentals
On May 3, 2022 I will run an SQLpassion Live Training about SQL Server Query Tuning Fundamentals. If you have a database driven application which reacts very slowly when...
2022-04-04
40 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
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...
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