Power BI Tracker
Znáte ten pocit, kdy jste si přepsali nějakou složitější measure a rádi byste jí vrátili do stavu, jak vypadala před hodinou? Nebo kolega něco upravil ve vašem modelu, ale...
2022-09-22 (first published: 2022-09-21)
26 reads
Joyful Craftsmen Blog
Azure Synapse Case Study
Let’s introduce our customer and their product
Our client is working in telecommunications providing secure and reliable networks. They are an independent supplier of mobile, data and voice services in...
2022-06-29 (first published: 2022-06-09)
378 reads
Azure Synapse Explained
In this article we would like to give you a high level summary on Azure Synapse.
What it is, what are its strengths and weaknesses observed through our project implementations...
2022-06-06 (first published: 2022-05-13)
491 reads
Synergy of Azure Synapse & Joyful Craftsmen
Why „synergy”? Let’s take a look at the context first. Data warehouses have undergone development on Microsoft technologies in the last few years.
From the beginning, customer data warehouses were...
2022-05-13 (first published: 2022-04-28)
238 reads
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
3 reads
Data Engineer Diary: How to make Power BI Gateway work in an environment with a proxy
With this blog post, I would like to show and describe to you the last lesson that I learned on my recent project regarding the installation and configuration of...
2022-05-27 (first published: 2022-04-04)
594 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
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
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
24 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
Blogs
Building the Team: Roles and Responsibilities in FinOps
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
Forums
Shelf Life Testing Laboratory | FARE LABS Pvt. Ltd.
Fare Labs' shelf life testing facility has been accredited by the NABL. The best...
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers