Skip to content

Author: Olivier Van Steenlandt

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…

T-SQL Tuesday #151: Coding Standards

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 Mala Mahadevan (blog, Twitter), “What are the T-SQL coding rules that are appropriate for where you work and what you do? If there are exceptions to those rules, state them too!“ Applying Coding Standards When executing development with multiple developers, a coding standard is a must-have. Though, having one…

DataGrillen 2022 – Presenting my first session

At the time that I was writing this blog post, I just started to realise that I’m no longer considered a “newcomer” speaker. On June 2nd, 2022, I delivered my first session at DataGrillen. Which is a wonderful event hosted by William Durkin (Twitter) and Ben Weissman(Twitter). Before the event Before I mention how I experienced the event, I would like to go back to January 2022. Around that time, my preparation started. Yes, I’m…

T-SQL Tuesday #150: My First Technical Job

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Currently, Steve Jones (blog, Twitter) is maintaining this amazing initiative. This month’s topic has been chosen by Kenneth Fisher (blog, Twitter), “What was your first technical job?” My first technical Job After finishing University College in June 2013, I started as an Operational Data Analyst for a Belgian online gaming company. The company where I started did not have a data warehouse, nor any automated reporting…

T-SQL Tuesday #149: T-SQL Advice you’d give your younger self

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Currently, Steve Jones (blog, Twitter) is maintaining this amazing initiative. This month’s topic has been chosen by Camila Henrique (blog ), “If you could give advice about T-SQL to your younger self what would you say? My advice to share To be fair, when I saw the T-SQL Tuesday invitation, my first thought was, hmm I wouldn’t know what to advise. So before I wrote this…

Getting started with Database Projects and Version Control

In my previous blog post (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 it to…

Creating your first Azure DevOps Project

Before you can setup an Azure DevOps Projects, you need to create a Azure DevOps account and organization. This setup is very easy and basic configuration can be done in a matter of minutes. For this blogpost, I will skip the organization setup and I will dive into Azure DevOps Project Setup straight away. When creating an Azure DevOps Project, there are a few considerations to make, do you want your project to be publicly…

My session got selected! What now…

In my first blogpost, that I’ve written after dataMinds Connect 2021, I explained that I was really thinking about public speaking. What started as an idea became reality, even faster than I ever could imagine. How so? After dataMinds Connect, I started to gather multiple ideas on topics that I would love to tackle during a session, actually I already started with a list a long time ago but I started to extend the shortlist.…