Sharing Learnings
In DBeaver’s SQL Server connection, one can use Windows authentication if the computer is joined to the domain and the integrated windows credentials can be used to authenticate to the SQL server. If the computer is not joined to the domain, then one of the alternatives is to use Kerberos authentication. Previously, one can code … Read more
After upgrading to RHEL8 or Centos8, connecting to SQL server using trusted authentication may fail with the following error: rc4 encryption is still heavily used in AD environments but it is already disabled by default. Therefore, to re-enabled it again, simply call: After that, reboot the server and the SQL connection would work.
There is a good article on connecting DBeaver to MS SQL Server with Kerberos Ticket Cache in Windows. I only chanced upon this article after I have fixed by issue without using a Kerberos Cache. You would have noticed that when you select Kerberos, the User name and password prompt is grayed out. Choose another … Read more
In my work, I need to obtain data from large databases with several highly normalized tables of at least 10 million records. I have been using INNER join queries with indexes to optimize the queries and reducing the execution speed. However, this does not work for large result sets. The time taken is simply too … Read more