Assigning Permissions and Roles in SQL Server
- 10 December 2022
- Database Performance ManagementTechnology Business
SQL Server applies role-based security rights delimitation. A role is a certain set of rights that can be assigned to a certain user or group of…
How to make SELECT COUNT(*) requests very fast
When you run SELECT COUNT(*), the speed of the results is heavily influenced by the database’s structure and settings.Let’s conduct a survey of the Vo…
SQL SELECT statement
With the SQL SELECT operator, you can get records from one or more tables in an SQL database….
The operation of the PostgreSQL query optimizer
- 8 December 2022
- Database Performance ManagementTechnology Business
PostgreSQL uses a cost-based query optimizer, just like any high-end relational database, to try to make your SQL queries as effective and quick to ex…
PostgreSQL SSL authentication configuration
Maintaining PostgreSQL’s security is something we want to do. Therefore, considering the use of SSL to protect client-server communication only makes …
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!