Database performance for Hibernate developers course

Database performance for Hibernate developers

Have you ever wondered why database operations in your application are slow? Is it because of the database or Hibernate or both? Is there anything that can be done to improve that? What are those mysterious database indexes? Does using Hibernate leave me no field for performance optimization?

 

Image source - Unsplash - https://unsplash.com/photos/iOykDIkZLQw

Dbvisit; what it is and why you should choose this Data Recovery Software

Imagine arriving at your workplace one morning, opening up your computer, and logging into your Oracle Database only to get the dreaded ‘error’ report, which says that all the information you saved the previous day has been wiped away.

Imagine arriving at your workplace one morning, opening up your computer, and logging into your Oracle Database only to get the dreaded ‘error’ report, which says that all the information you saved the previous day has been wiped away.

The mere thought probably makes your skin crawl, right?

Script to kill all database connections

killConnectionsEach SQL Server database administrator and database developer has a set of scripts that should always be somewhere close. One of them is the one that kills a bunch of connections to a database. It can be a group of all connections, those made by a particular login or the ones using a specific database. No matter what actual conditions are, killing dozens or hundreds connections manually is not fun. Here are provide an SQL script that can be easily customized to cover a specific need. The below version destroys all non-background connections to a database called MyDatabase.

MySQL collations - why are there so much problems with them?

Do you share my feeling that any problem with encoding in MySQL database wastes a lot of your time? A few different settings, multiple possible combinations, you tried many of them and it is still not working? Maybe one of them was correct but should I restart MySQL instance, the whole server, the data center? Aaaaargh.

 

Database development environment with Windocks and Liquibase

Database development environment with Windocks and Liquibase

small

I cannot imagine a project in a reputable company without a development environment. A place where developers could deploy unfinished code, test it, play with it or do ad-hoc manual changes without making any trouble to their colleagues. All projects have such place you could say. Not really I would respond.

 

 

We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.