Passing MS Exam 70 – 768: Developing SQL Data Models
Introduction The purpose of this blog is to provide brief overview of the MS Exam 70-768 with focus on the preparation from the perspective of a junior MSBI developer. The…
Life of a variable in PowerShell
Overview Recently, I was facing an issue that a variable had a different value than I expected. I was executing a script, let’s call it Script1, which was using a…
Moje první SQL SATURDAY
Moje první návštěva byla na letošní konferenci SQL Saturday, která se nedávno uskutečnila v Praze na Pankráci. Před tím jsem měl malé zkušenosti s návštěvami meetupů od Czech Pass, s obdobnou tématikou. Protože…
Microsoft Flow Refresh
The goal of this post is to check back on the progress of Microsoft Flow after some time not using it and describe the changes. What is MS Flow? It’s…
Query Performance Tuning with Filtered Statistics
Introduction I recently got a call from our DBA telling me that the CPU usage is hitting 100% on the DB server and the ETL process runs for more than…
CI – Best Practices Using Bamboo
The goal of this post is to find some resources about Bamboo Best Practices, review the current setup on our project and propose some changes. Sources The very basic resource…