Tag: sql

Jun 26 2023

Azure

SQL : Locking down disperse SQL databases – part 2 – Logins & Keyvault

by mattias

No Comments

In the previous article I explain the full setup of a mechanism to automate the access management of databases across various servers. In this article, I’ll start with the basics:...

keyvault, security, sql

Jun 23 2023

Azure, Uncategorized

SQL : Locking down disperse SQL databases – part 1

by mattias

No Comments

In this series, I’ll detail a process to automate giving and removing access to databases. Not just a single one, but different databases over different servers. Introduction The use case...

azure, azure sql db, elastic job, function, keyvault, powerautomate, security, sql

Aug 28 2022

Business Intelligence

SQL : split delimited field in columns

by mattias

No Comments

These days of PowerQuery, Spark and other query tools there are quite a range of options available to split delimited fields, but what if you have a table in your...

0NF, database, db, delimited, json, normalisation, sql, SQLServer

Aug 27 2022

Business Intelligence

SQL : CLR to do base36 decoding

by mattias

No Comments

Always wanted to escape the set based world of SQL and get back to that good old .Net procedural (even object oriented) experience for a quick calculation? Let me show...

assembly, database, datawarehouse, db, etl, sql, SQLServer, tsql

Aug 21 2022

Azure

SQL : Move tempdb to D:

by mattias

No Comments

When you install SQLServer on an Azure virtual machine, you can take advantage of the D: drive that comes with such a VM. Its characteristics are that it is local,...

azure, database, datawarehouse, db, dba, sql, SQLServer, tempdb, vm