Skip to content

Blog

  • 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…