Database Administration & Monitoring

How to view and change SQL Server Agent properties with T-SQL queries

Few days ago, after a reboot, we had this warning on the Agent Error Logs on many servers: Warning [396] An idle CPU condition has not been defined – OnIdle job schedules will have no effect(…)

Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c

Since Oracle 21c it is possible to convert the non CDB database into a PDB directly during the upgrade using the Oracle Autoupgrade Tool. This is an important enhancement, because with Oracle 21c the non CDB architecture is desupported,(…)

SQL Server: Using Client Statistics to validate a query regression after a change in the database compatibility level

Few days ago, I have very poor performance on a database that I migrate from SQL 2012 to SQL 2019. The developer Team asks me to upgrade the number of CPU and the Memory to have better performance.

ODA: Quickly solve ILOM and BIOS update errors

Introduction Patching an Oracle Database Appliance is sometimes quite tough and you often struggle to solve failures at different steps. Regarding ILOM and BIOS patching errors, a simple workaround is possible. Errors when patching ILOM and/or BIOS This is(…)

Deploying a KVM-based virtualized X8-2M ODA

Introduction Until now, High-Availability (HA) ODAs could have been deployed either in bare metal or in virtualized mode. Virtualized mode means that instead of installing a classic Linux system on the nodes, an OVM hypervisor (based on Xen) was deployed.

SQL Server: “Cannot resolve the collation conflict” in a Stored Procedure

This week I have a new little challenge by a customer. By executing a “standard” stored procedure, I have the error: Msg 468, Level 16, State 9, Procedure Get_logsessions, Line 56 [Batch Start Line 119] Cannot(…)

SQL Server SCOM database: A lot of errors 777970008 in the errorlog file

Few weeks ago, during a audit, I have a lot of error 777970008 in the errorlog file from the SCOM instance. All 5 minutes, we had 4 lines more in the ErrorLog and the file growth a lot.

Manage ODA patching with Data Guard or Dbvisit Standby

Introduction Building an Oracle infrastructure today without thinking about a Disaster Recovery solution (DR) is quite rare. This became obvious that a backup or a dump will not help if you do not know where to restore or import once(…)

Automate restore from Rubrik with PowerShell (part 2)

As promised during my last Rubrik blog post I’m writing a second one to explain how to: log your different steps in a file add an integrity check after the restore and also improve my first scripting I will(…)

SQL Server: table variables performance limitations

Doing some performance troubleshooting for one of my customers I identified some issues with very large table variables inside Stored procedures. Table variables limitations are not well understood by developers although they are now well documented. Table variable(…)