SQL server xp_cmdshell: How to?

by | Jun 4, 2023 | Latest, SQLServer

Let us take a closer look at the SQL server xp_cmdshell. At Bobcares with the support of our MSSQL support services, we can give you a detailed note on the usage of the xp_camdshell command.     What is xp_cmdshell? The xp_cmdshell is a very powerful extended...

Dynatrace SQL Server: Enabling and management.

by | Jun 4, 2023 | Latest, SQLServer

Let us take a closer look at how to enable the Dynatrace SQL server monitoring with the assistance of our MSSQL support services at Bobcares.     Dynatrace It monitors SQL Server databases across all platforms and analyzes database service activity, allowing...

SQL Server Openquery: A Guide on

by | Jun 4, 2023 | Latest, SQLServer

Let us take a closer look at the SQL server openquery and its functions with the assistance of our MSSQL support services at Bobcares.   Openquery The OPENQUERY function is a tool to do an ad hoc distributed query on a distant data source via the connected server....

MySQL error 1005 (hy000): Causes and solution.

by | Jun 4, 2023 | Latest, MySQL

Let us take a closer look at MySQL error 1005 (hy000) and how to remove it with the support of our MySQL support team at Bobcares.     MySQL ERROR 1005: Can’t create table (errno: 150) (Foreign Key) The example given below will demonstrate a case in which this error...