(Benjamin Wisnewski, Bhargav Perepa, Ilene Seelemann, Kurtulus Yildirim, Rahul Gupta, Soad Hamdy and Vasfi Gucer) Application programming interfaces (API) act as the digital glue that links services, applications, and systems together to create compelling customer experiences. Using APIs you can cre
Editorials
- DataTable Extension To Resolce Column Ordinal Positions By Name
- DataTableReader Extension Methods
- Multiple Results From Queries
Other News
Disable or Enable Controls in a Parent Control, Except for one
(Hannes du Preez) You will encounter a situation where you would like to disable all the controls inside a container control except for one.
Using hibernate default schema as a variable
(Matt Busche) Given you have set up a default_schema in your hibernate configuration
Quickly create A LOT of SQL Instances
(Charlie Pyne) Recently I delivered a demo on Policy Based Management for a customer. To show this off well, I really wanted to have a larger number of SQL servers to show how PBM can be used to manage SQL Server sprawl.
SQL*Net Message Waits
(Hemant K Chitale) Here are some extracts from an 11.2.0.4 AWR Report I ran a simulated workload on this server for about 40minutes and generated this report. I understand that some DBAs may be misinterpreting SQL*Net message time.
Maximizing Database Performance – MySQL Tuning Best Practices
(Janis Griffin) With the added complexity of growing data volumes and ever changing workloads, database performance tuning is now necessary to maximize resource utilizations and system performance. However, performance tuning is often easier said than done.
ORA-39710 and ORA-00704
(Andrew Reid) I tried to use dbua to upgrade a database from Oracle 11.2.0.4 to Oracle 12.1.0.2. Part way through, my PC lost connection with the UNIX server hosting the database.
Oracle DIRECTORY access on OS layer
(Martin Berger) Oracle DIRECTORY objects are very nice to handle access for external tables or other procedures.
7 Essential Steps to Recover a Corrupt SQL Server Database
(Andrew Jackson) Backups are evidently a DBAs foremost approach when caught in a critical crisis condition. However, there are instances where responding to corruption is a part of dealing with it besides just leaving the server in the affected state and restoring from a backup.
Introduction to Structured Query Language (SQL) — Part — 4
Introduction to Structured Query Language (SQL) – Part – 4 In What Manner to Update Information The INSERT statement is castoff to insert new data in a table or relations, then again what if an individual want to perform a modification to a specific data? In this circumstance the Structured Query Language (SQL) statement completes the modification with the help […]
