(Aman) In our previous posts, we have understood what is a compute instance and what role VCN plays in making a compute instance interact with other compute instances or to the outer world.
Other News
Did You Know #34 – DST Patches with PDB
(Liron Amitzi) When I worked on Oracle Cloud 20c for my Data Dictionary Changes post, I ran into a problem with DST difference.
Guru: A Simple, Effective Way To Compare Data Using SQL
(Ted Holt) One thing I have learned over the years is that no matter how much technology changes, people always ask the same questions like: “Why does the computer say we have 50 widgets when we only have 45?” and “Can you tell me who changed the due date of order number 12345?” and “How do sales of
A Quick how-to RMAN backup to OCI Object Storage
(Martijn Pronk) This is a quick how-to article on setting up RMAN to backup to Object Storage on OCI.
Java Feature Spotlight: Text Blocks
(Brian Goetz) In Java Futures at QCon New York, Java Language Architect Brian Goetz took us on a whirlwind tour of some of the recent and future features in the Java Language. In this article, he dives into Text Blocks.
The Very Best of Extended Events
(Grant Fritchey) Over the next couple of months, I’ll be putting on a number of different sessions teaching about the tools supplied by Microsoft, for free, that can help you when tuning your queries. One of the most important of these tools is Extended Events.
PART I: Deadlock and Starvation in DBMS
Deadlock Definition A deadlock is a condition in which two or more transactions wait indefinitely to unlock the lock. Deadlock is considered one of the most feared complications from DBMS, as no task is complete and is pending forever. Example: The T1 transaction blocks certain rows in the student table and has to update certain rows in the classification table....
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Display Data in Tabulator.js Table from ASP.NET
(avinash jorige) This article gives a walk-through of the jQuery Tabulator plugin used to display data stored in the database using ASP.NET Ado.net.
ercona XtraBackup: Backup and Restore of a Single Table or Database
(Manish Chawla) The backup and restore of a complete database is an extensive exercise. But what if you need to restore just one table which has been mistakenly modified by an incorrect query?
SQL SERVER – Scrollbar in the Middle – Bugs Fixed by SSMS Team
(Pinal Dave) I recently installed the latest version of the SQL Server Management Studio for one of my demo sessions. While preparing for it I realized that one of the things for which I used to make fun of SSMS is no longer available.