Bite Size Data Tales | Olivier Van Steenlandt
When I started to explore and use Database Projects, I ran into a specific situation quite fast where I was required to use SQLCMD variables. In this blog post, I will describe what they are, how you can use SQLCMD variables in Database Projects and where this might become very useful for you. Quick Overview […]
I’m happy to share that I will be delivering my session about “Improving Team Collaboration using Database Projects & Azure DevOps” at the dataMinds User Group. During this session, I will first be explaining what went wrong in the past for me, during the main part of the session, I will be showing how to […]
In one of the previous blog posts, I described how to merge branches manually (Database Projects – Merging changes). When merging manually, there is no way to revise the development that someone did. If you want to start with peer reviewing during the development process, you can easily do so by using Pull Requests. Quick […]
The moment that Microsoft announced that Power BI Paginated reporting was becoming a Pro feature (link), I finally realized that I would be able to move from 2 different reporting platforms (Power BI Portal & SQL Server Reporting Services) back to 1 (Power BI Portal). Quick Overview SQL Server Reporting Services Report Power BI Report […]
Well, it’s that time of the year, days are getting shorter, it’s pretty cold outside and that typically is the time for me to get cosy on the sofa and review the year. This year was a special one, I was able to achieve a couple of awesome milestones in my professional career During the […]
In my previous blog post, we finalized our development phase by deploying our changes to the development environment(Database Projects – Deploying Changes). Since we now have a complete overview of how development can be done, we can look at specific use cases. Quick Overview Use Case Description Step-by-Step Example Important Notices Use Case Description In […]
I’m very happy to share that I will be delivering my session about “Improving Team Collaboration using Database Projects & Azure DevOps” at SQL Saturday MN. During this session, I will first be explaining what went wrong in the past for me, during the main part of the session, I will be showing how to […]
In a previous blog post (Database Projects – Merging changes), we successfully merged our feature branch into our development branch. Now, as a final step in our development process, we want to get our changes deployed to our development environment. In this blog post, we will go through the process step by step to execute […]
In my previous blog post (Database Projects – Making Changes), we successfully executed our first development task in a feature branch. To get our changes to the development environment, we will need to execute a couple of steps which are called merging. Quick Overview What is merging exactly? Merging by example Lessons Learned What is […]
T-SQL Tuesday is the brainchild of Adam Machanic (blog). Steve Jones (blog, Twitter) is currently maintaining this fantastic initiative. This month’s topic has been chosen by Tom Zika (blog, Twitter), “Which quality makes code production grade?“ My Contribution When I first thought about this topic, I didn’t have any clue what to write… Then, I […]
