Blog / Database Blog

Points to look for while writing SQL Code

Doyensys 1 min read
Avoiding the Pitfalls of Database Programming – this is a very good material which every SQL developer should read. I’m sure when each developer reads this they can connect with all the mistakes they have done till now while coding

http://edu.ercess.co.in/ebooks/SQL/SQL-Antipatterns-Avoiding-the-Pitfalls-of-Database-Programming.pdf

Related blogs

Database Blog

Query to Identify Initial and Latest Login Sessions in Oracle Database

Please use the query below to identify and provide the SID and Serial#.   col first_seen for a30 col last_seen for a30 SELECT MIN(sample_time) AS first_see…

Venkatesh GK 1 min read
Database Blog

Steps to Renew Default OHS Keystore Wallet in Oracle Enterprise Manager (OEM)

Please follow the below steps.   Prerequisites   Take a backup of the existing wallet. Ensure you have appropriate Oracle user privileges. Verify OMS…

Venkatesh GK 1 min read
Database Blog

How to Unlock Locked SQL Server Logins

How to Unlock Locked SQL Server Logins Introduction / Issue During day-to-day SQL Server administration, users may report that they are unable to connect to the…

SaiKumar 3 min read