Infrastructure at your Service

 
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
Dominique Althuser

Email Spoofing

By | Security | No Comments

Have you ever had this unhealthy sensation of being accused of facts that do not concern you? To feel helpless in the face of an accusing mail, which, because of its imperative and accusing tone, has the gift of throwing us the opprobrium? This is the purpose of this particular kind of sextortion mail that uses spoofing, to try to extort money from you. A message from a supposed “hacker” who claims to have hacked…

Read More
Daniel Westermann

Migrating your users from md5 to scram authentication in PostgreSQL

By | Database Administration & Monitoring | No Comments

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
David Barbarin

SQL Server containers and docker network driver performance considerations

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

Few months ago I attended to the Franck Pachot session about Microservices and databases at SOUG Romandie in Lausanne on 2019 May 21th. He covered some performance challenges that can be introduced by Microservices architecture design and especially when database components come into the game with chatty applications. One year ago, I was in a situation where a customer installed some SQL Server Linux 2017 containers in a Docker infrastructure with user applications located outside…

Read More
David Barbarin

Deploying SQL Server on Azure virtual machine with Terraform

By | Cloud, DevOps, SQL Server | One Comment

We are entering now to the infrastructure as code world and provisioning a SQL Server infrastructure is not excluded from the equation. This is especially true when it comes the Cloud regardless we are using IaaS or PaaS. One great tool to use in such scenario is certainly terraform and I introduced it during the last PowerSaturday pre-conference named “DBA modern competencies”. Installation paradigms in the cloud differ from what we usually do on-premises either…

Read More