I’m not trying to start up a debate whether you should use tabs or spaces when indenting code. Personally, I prefer spaces because when I copy the code to another editor the outlining of the code remains the same while with tabs it’s not always the case (looking at you, Word and Outlook). But I […]
Category: SQL Server
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post 🙂While deploying a DACPAC (from a SQL Server Data Tools Database Project) through Azure Devops, I got the following error message: The user attempting to perform this operation does not have permission as it is currently logged in as a member of an Azure Active Directory […]
How to Install SQL Server 2025 RC0 on an Azure VM
I wanted to try out the new JSON index which is for the moment only available in the SQL Server 2025 preview version. I know, it’s not even available in Azure SQL DB. Cloud not first? What? I already had a virtual machine in Azure, running SQL Server 2025 CTP 2.0 (which uses a pre-made […]
Redgate SQL Prompt in SSMS 21
Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it, the new version of SSMS is now generally available. It’s a big new version and it now uses Visual Studio 22 behind the scenes, so it’s now installed through the Visual Studio Installer. Anyway, I’m a big fan of Redgate SQL […]
dataMinds Connect 2024 – Session Materials
The slides and scripts for my session “Tackling the Gaps & Islands Problem with T-SQL Window Functions” at dataMinds Connect 2024 can be downloaded from GitHub. If you want to run the sample scripts, some of them require an installation of the AdventureWorks DW sample database.
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very long, for example if a dimension has a lot of columns. When debugging, I noticed a couple of statements failing with various errors. Turns out, they […]
How to Install Integration Services 2022
The title of this blog post is a bit misleading, because what we actually want to do is to install the SSIS development functionality in Visual Studio 2022. SSAS and SSRS have been available for some time now in VS 2022, but the extension for SSIS has only just been released in preview. For those […]
How to Install SQL Server 2022
SQL Server 2022 has been released! In this blog post, I’ll walk you through how you can install the latest version of SQL Server on your machine. I’ll be using the developer edition of SQL Server 2022, which can be downloaded here. The download link will only download a small 4MB file. Opening this file […]
Cool Stuff in SQL Server 2022 – IS DISTINCT FROM
I have a blog post series about some nice features in the Snowflake cloud data warehouse; one of them is about the IS [NOT] DISTINCT FROM predicate. I was excited to find out this is now also included in the T-SQL language since the SQL Server 2022 CTP 2.1 preview! You can find the official […]
T-SQL Tuesday #149 – T-SQL Advice you’d give to your younger self
It’s the second Tuesday of the month, so it’s time for the T-SQL Tuesday blog party! This month’s topic is chosen by Camila Henrique (blog): what T-SQL advice would you give to your younger self? Here’s a little list I’d tell anyone starting out with T-SQL: you can configure most tools that when you hit […]