Tag: database

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

Aug 20 2022

Azure

Azure : Connect to Azure SQL database

by mattias

No Comments

Setting up an Azure SQL database is easy and fast, but you might bump into some problems connecting to it. I’ll share a couple of tools that you can use,...

azure, connection, database, db, errors, firewall, sql, SQLServer

Aug 19 2022

Azure, Navision

SQL : Configure automatic failover

by mattias

No Comments

Having some redundancy in your database infrastructure is essential to making sure your applications are accessible as much as possible. Even with a solid platform as Azure SQL database, you...

azure, database, db, failover, navision, primary, replica, sql