Skip to content

Olivier Van Steenlandt Posts

T-SQL Tuesday #156 – Production Grade Code

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 started to think about what I’m always doing while I’m developing and eventually before I publish the code to production.…

#NewStarNovember – My first speaking engagement

A couple of months ago, June 2022 to be exact, I gave my very first session at DataGrillen. A couple of years ago, after attending a couple of conferences/ events, I knew I wanted to do something for the community. At first, I wasn’t really thinking about becoming a public speaker, but more about contributing to events in the background. Back then, I knew a couple of people involved with the dataMinds user group. After…

Database Projects – Making changes – Feature Branching

In my previous blog post about Database Projects: “Getting started with Database Projects and Version Control”, I explained how to set up a database project and connect it to Azure DevOps Repos. In this blog post, I will be focussing on how you can start development. Quick Overview What about branching? Feature branching How to get started? Get started by example Create a new feature branch Making changes What about branching? Depending on how you…

Speaking @ Data Bristol User Group

I’m delighted to share that I will be speaking at the Data Bristol User Group where I will be sharing my personal experience with Database Projects & Azure DevOps. During this session, I will start off by explaining what went horribly wrong in the past, where we were struggling and how we overcame our challenges. Step by step we will be discovering the amazing world of Database Projects & Azure DevOps By the end of…

Speaking @ Southampton Data & Cloud User Group

After presenting my first session at DataGrillen 2022, in the beautiful city of Lingen, Germany. I started to look for new speaking opportunities, thanks to Mikey Bronowski (Twitter), who was kind enough to contact me if I was interested in speaking at the Southampton Data & Cloud User Group (Twitter). Without any doubt, I immediately responded that I would love to give a talk to his User Group. During this session, I will give a…

Getting started with Database Projects and Version Control

In one of my previous blog posts (Creating your first Azure DevOps Project), I described how to create an Azure DevOps Project and explained what kind of configuration you might want to consider. In this blog post, we will focus on how to get started with Database Projects and how to get this into Source Control (Azure Repos). So together we will create our first Database Project, import our database into the project and push…

T-SQL Tuesday #155: Dynamic Code

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 Steve Jones (blog, Twitter), “Where have you used Dynamic SQL for in the past?“ My Contribution In the past 10 years, I have used dynamic SQL several times in specific use cases. In this blog post, I will describe the use cases I can remember. The first time I…

Azure DevOps Pipelines – Release your Tabular Model without Users & Roles

Problem statement A couple of weeks ago my team & I ran into an issue with SQL Server Analysis Services (SSAS), due to a network split between companies, We weren’t able anymore to manage our SSAS access into our SSAS Tabular Model. Since deploying a Tabular Model using Visual Studio is also overwriting members & roles, we needed to find a valid alternative to execute our deployments. Manually at first and automated in the end.…

T-SQL Tuesday #154: SQL Server 2022

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Steve Jones (blog, Twitter) is currently maintaining this amazing initiative. This month’s topic has been chosen by Glenn Berry (blog, Twitter), “What have you been doing with SQL Server 2022?“ My SQL Server 2022 Journey Near the end of May 2022, SQL Server 2022 Public Preview was announced, a day after I heard, I downloaded the installer and installed SQL Server 2022 locally to play around.…

T-SQL Tuesday #153: The Conference That Changed Everything For Me

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Steve Jones (blog, Twitter) is currently maintaining this amazing initiative. This month’s topic has been chosen by Kevin Kline (blog, Twitter), “Tell us the story of how attending an IT conference or event resulted in an amazing career or life opportunity.“ My Story In the past couple of years, I became more active in the data community. First, as an attendee where I visited a couple…