Author: Abhishek Sharma
-
New Features of Oracle 19c-
Oracle Database 19c refers to the 19th version of the Oracle Database, which is a relational database management system (RDBMS) developed and marketed by Oracle Corporation. The “c” in 19c stands for “Cloud,” indicating Oracle’s commitment to cloud computing and cloud-based solutions. Oracle 19c is the successor to Oracle Database 18c and comes with several…
//
-
Oracle Database Locking Mechanism
In the field of database management, maintaining data integrity and controlling concurrent access is paramount. Oracle Database, a robust relational database management system, employs a sophisticated locking mechanism to achieve these objectives. In this comprehensive guide, we delve into the intricacies of the Oracle Database Locking Mechanism, exploring key terms and concepts integral to its functionality.…
//
-
Materialized Views in Oracle
A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table. Basic Syntax- The full syntax description for the CREATE MATERIALIZED VIEW command is available in the documentation. Here we will only concern ourselves with the basics. –Normal …
//
-
Trigger and create a simple logon Trigger
Introduction- In order to connect using SSMS or client apps, SQL Server offers Windows and SQL authentication methods. For DBAs, security is always the first priority, particularly in the production setting. We can manage database access by giving users the minimal and suitable permissions for their task. SQL Server’s provide and DENY statements can be…
//
-
Normalization in SQL Server
Introduction- Normalization in SQL Server is a crucial concept in database design that aims to organize data efficiently, reduce redundancy, and maintain data integrity. It involves structuring relational databases to ensure that they meet certain criteria regarding the relationships between tables and the dependencies among their attributes. Normalization’s primary objectives are- Eliminating Redundancy- Redundant data…
//
-
OFFSET Command in SQL Server
Introduction- In SQL Server, the OFFSET command is used in conjunction with the ORDER BY clause to specify the number of rows to skip before starting to return rows from a query. This is particularly useful for implementing pagination in applications or when you need to skip a certain number of rows before fetching results.…
//
-
Extended Events in SQL Server
Introduction- Extended Events (XEvents) is a highly scalable and adaptable event-driven monitoring system that debuted with SQL Server 2008. It is intended to assist database administrators (DBAs) and developers in gathering extensive information on SQL Server behavior, such as performance issues, query execution, and system diagnostics. Extended Events’ architecture provides for minimum performance effect, making…
//
-
Correlated Subquery
Introduction- A correlated subquery is a SQL query in which the values of the inner query (subquery) are derived from the outer query. Essentially, the subquery is conducted many times, one for each row processed by the outer query. This makes correlated subqueries very useful for complex data retrieval scenarios, but they can also be…
//
Search
Categories
- Azure (7)
- About Us (1)
- Azure SQL Database (6)
- My SQL (53)
- About Us (1)
- DBMS Concepts (20)
- Handbook (1)
- MySQL Architecture (19)
- MySQL Basics (29)
- MySQL L1 (14)
- Oracle (34)
- PostgreSQL (37)
- About Us (1)
- DBMS Concepts (21)
- PG Hand Book (1)
- pg_ High Availability (4)
- pg_Backup (4)
- pg_basic (11)
- SQL Server (132)
- About Us (1)
- Azure SQL Database (4)
- Backup and Recovery (17)
- Backup Tools for SQL Server (3)
- DBA Worries Continued (27)
- DBMS Concepts (28)
- High Availability (12)
- Installation and Configuration (23)
- L1 DBA (59)
- Monitoring (17)
- Performance Tuning (29)
- Power Shell Script (6)
- Security (12)
- SQL DBA Hand Book (2)
- SQL Scripting (16)
- SQL Server Reporting Services (2)
- Uncategorized (3)