Infrastructure at your Service

Category

Database Administration & Monitoring

Yann Neuhaus

Microsoft Inspire Partner Event 2019 / Day 3

By | Database Administration & Monitoring | No Comments

dbi services at Microsoft Inspire Conference Core Note Satya Nadella – Day 3 The day started with the Core Note from Satya Nadella. Being alone at the conference allowed me to find one of the very last well-located seat to have a nice view of the Event 😉. I never saw a key note from Satya and I must admit that I was impressed. Giving the opportunity to lead a company because someone deserves it…

Read More
Daniel Westermann

Schedule reboots of your AWS instances and how that can result in a hard reboot and corruption

By | Database Administration & Monitoring | No Comments

From time to time you might require to reboot your AWS instances. Maye you applied some patches or for whatever reason. Rebooting an AWS instance can be done in several ways: You can of course do that directly from the AWS console. You can use the AWS command line utilities as well. If you want to schedule a reboot you can either do that using CloudWatch or you can use SSM Maintenance Windows for that….

Read More
Yann Neuhaus

Microsoft Inspire Partner Event 2019 / Day 2

By | Database Administration & Monitoring | No Comments

dbi services at Microsoft Inspire Conference SQL Server 2019 is in “public preview” stage, live from Microsoft Inspire 2019 – Day 2 Anshul Rampal (SQL Server product marketing team) and Rony Chatterjee (SQL Server Core team / Product Manager) presented the new SQL Server 2019 features in a 20-minutes session. SQL Server is 25 years old! Its new version – SQL Server 2019 – has just been published last night (as “public preview”). @David Barbarin:…

Read More
Yann Neuhaus

Microsoft Inspire Partner Event 2019 / Day 1

By | Database Administration & Monitoring, DevOps, SQL Server | No Comments

dbi services at Microsoft Inspire Conference Summary of my first participation – Day 1 After 20 years in the business of IT Infrastructure, time has come to open my mind 😉 and Microsoft Inspire is the perfect opportunity. It is a partner conference that has quite a different approach compared to other software editors I worked for (e.g. Oracle). Indeed, the Oracle Open World mixes partners and customers, which is not always a good idea…

Read More
Daniel Westermann

Migrating your users from md5 to scram authentication in PostgreSQL

By | Database Administration & Monitoring | One Comment

One of the new features in PostgreSQL 10 was the introduction of stronger password authentication based on SCRAM-SHA-256. How can you migrate your existing users that currently use md5 authentication to the new method without any interruption? Actually that is quite easy, as you will see in a few moments, but there is one important point to consider: Not every client/driver does already support SCRAM-SHA-256 authentication so you need to check that before. Here is…

Read More
Daniel Westermann

Converting columns from one data type to another in PostgreSQL

By | Database Administration & Monitoring | No Comments

Usually you should use the data type that best fits the representation of your data in a relational database. But how many times did you see applications that store dates or numbers as text or dates as integers? This is not so uncommon as you might think and fixing that could be quite a challenge as you need to cast from one data type to another when you want to change the data type used…

Read More
Daniel Westermann

Telling the PostgreSQL optimizer more about your functions

By | Database Administration & Monitoring | No Comments

When you reference/call functions in PostgreSQL the optimizer does not really know much about the cost nor the amount of rows that a function returns. This is not really surprising as it is hard to predict what the functions is doing and how many rows will be returned for a given set of input parameters. What you might not know is, that indeed you can tell the optimizer a bit more about your functions.

Read More