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
43 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
39 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers