Year: 2022
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 […]
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 […]
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 & […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]