Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
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 & Ajay Jagannathan D2B2 – HYDRA- SQL Server 2022 IQP Deep Drive – Advanced – Kate Smith, Derek Wilson &…
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 size in PostgreSQL is 8kB (same as in Oracle), so something needs to happen when a row comes in which…
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, welcome to the lobby! Going to the rooms: After selecting your session, you select the room name and you start!…
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 across data warehouses and big data systems. Azure Synapse brings together the best of SQL technologies used in enterprise data…
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 Tuning Magic Show yesterday & today. It’s every time good to do a refresh and learn about the performance and tuning. It’s good to have…
The Conference POUG (Polish Oracle User Group or rather Pint with Oracle User Group) organizes as usual his annual conference in Poland in September to discuss about Oracle topics. The 7th edition of 2022 took place in Wrocław on September 9 and 10. Speakers arriving from all over the world presented technical sessions to Polish enthusiastic attendees. Two parallel tracks…
By Mouhamadou Diaw In this blog, I describe the patching of an ODA X8 from 19.9 to 19.11. We use following patches p32790643_1911000_Linux-x86-64.zip : Oracle Database Appliance Server Patch for ODACLI/DCS Stackp30403673_1911000_Linux-x86-64.zip : Oracle Database Appliance GI Clone for ODACLI/DCS stackp30403662_1911000_Linux-x86-64.zip : Oracle Database Appliance RDBMS Clone 19.11.0.0.210420 for ODACLI/DCS stack Patching the Oracle Database Appliance Server Before starting the…
One of my customer asked me some days ago to create a PowerShell script to patch its SQL Server instances. After a reflection time, the first step will be to download the last Service Pack and the last Cumulative Update depending of the SQL Server version and after to apply those patches to the SQL Server instances. In this blog…
By Mouhamadou Diaw Dbvisit 11 is released since a few months ans now is referenced as Dbvisit Standby MultiPlatform v11 ( Dbvisit StandbyMP 11 ) for Linux and Windows. It brings revolutionary improvements, including being able to manage both Oracle and SQL Server DR from a single GUI. In this blog I am showing how to install Dbvisit StandbyMP on…
If you are new like me in the ODA world, there is a chance that you don’t know the workaround for the ODA Administration console, asking you to reset the oda-admin’s pasword each time ! The solution is really simple. In some cases, you must accept certificats for the DCS-controller on port 7093 and DCS-agent on port 7070. Here we…
BASH: make function to return arbitrary values, not only numbers
Presentation of the Backup Recovery solution provided by Microsoft Azure for Azure Database for MySQL Server
