BE SHARING

Database Administration & Monitoring

Do you really need varchar(n) in PostgreSQL?

24.09.2022 by Daniel Westermann

PostgreSQL comes with three data types for storing characters. char, varchar and text. What we often see at our customers is, that varchar(n) is used when they want to store characters and limit the amount of characters which are allowed(…)

TOASTing in PostgreSQL, let’s see it in action

22.09.2022 by Daniel Westermann

The last two posts introduced TOASTing strategies and how TOAST tables look like. Have a look at those posts if you are not yet familiar with TOAST in PostgreSQL. In this post we'll look(…)

Database Administration & Monitoring

Data Platform Virtual Summit 2022 – Day 4 – Focus on Azure SQL Managed Instance

22.09.2022 by Stéphane Haby

Today the Data Platform Virtual Summit begin at 09:30 am with the keynote: Creating a Data Culture… My schedule for the day: D4B1 – SPHINX – Configure SQL Server for efficient troubleshooting – Intermediate – Christophe LaporteD4B2 – HYDRA –(…)

Database Administration & Monitoring

Data Platform Virtual Summit 2022 – Day 3

21.09.2022 by Stéphane Haby

Today the Data Platform Virtual Summit begin at 06:00 am for us…It’s in our time offset, this time better to wake up! 😉 My schedule for the day: D3B1 – KATMAI – SQL MI on Kubernetes – Intermediate – Dhananjay(…)

Database Administration & Monitoring

TOASTing in PostgreSQL, TOAST tables

21.09.2022 by Daniel Westermann

Make sure that you read the last post about TOASTing strategies in PostgreSQL before you continue with this one, at least if you are not familiar with the previous topic. The strategies we looked at are one(…)

Database Administration & Monitoring

Data Platform Virtual Summit 2022 – Day 2

20.09.2022 by Stéphane Haby

Today the Data Platform Virtual Summit begin at 03:30 am for us… It’s a little bit early but better than yesterday. My schedule for the day: D2B1 – HYDRA – Overview of SQL Server 2022 – Intermediate – Bob Ward(…)

Database Administration & Monitoring

TOASTing strategies in PostgreSQL

20.09.2022 by Daniel Westermann

In Oracle a single row can span more than one block, which is called row chaining. As PostgreSQL does not allow a row to span multiple blocks, there needs to be a way to work around that. The default block(…)

Cloud

Data Platform Virtual Summit 2022 – Day 1

19.09.2022 by Stéphane Haby

Today the Data Platform Virtual Summit begin at 00:30 am for us… It’s a little bit early but when we like our work and like to learn, we stay up with plaisir. My schedule for the day: After the login,(…)

Big Data

SQL Server 2022 – Azure Synapse Link

15.09.2022 by Christophe Cosme

Why is this feature interesting? The Azure Synapse Link for SQL Server 2022 will enable you to replicate your operational data into Azure Synapse Analytics dedicated SQL pool. Azure Synapse is an enterprise analytics service that accelerates time to insight(…)

Database Administration & Monitoring

Data Platform Virtual Summit Pre-con 2022

13.09.2022 by Stéphane Haby

Thanks to dbi services to let me the opportunity to follow this week and next week, the Data Platform Virtual Summit beginning with the Pre-con. I subscribe the session of Guy Glantser about The Performance(…)