(Rami Sayar) Have you heard of a protocol called ORTC? You can use it to embed audio and video calling in your HTML5 web app without any plugins!
Other News
Impact from adaptive hash index and innodb_thread_concurrency in MySQL 5.7.5
(Mark Callaghan) I have been evaluating micro-benchmark results for point and range queries in MySQL 5.7, 5.6, 5.5, 5.1 and 5.0. In this post I document the impact from disabling the InnoDB adaptive hash index and using innodb_thread_concurrency.
Modeling Function Based Indexes in Oracle
(Jeff Smith) Function based indexes [DOCS] have been part of Oracle Database since at least version 8. Instead of just indexing someone’s name, you could also index the values returned by a function call over that name.
Oracle Event Processing 12c: java errors when deploying a new OEP project
(Michel van Zoest) Sometimes when you create a new OEP project in JDeveloper 12c and you deploy it for the first time, you might get a list of java errors. They might look a bit like this:
12.1.0.2 Introduction to Zone Maps Part II (Changes)
(Richard Foote) In Part I, I discussed how Zone Maps are new index like structures, similar to Exadata Storage Indexes, that enables the “pruning” of disk blocks during accesses of the table by storing the min and max values of selected columns for each “zone” of a table. A Zone being a range of con
Query Plan Evaluation
How are you query plan evaluation skills? Reviewing a query plans is often the easiest way to find out why a specific query is not performing well. You can use the standard reports in SQL Server to identify long running queries, or queries that use a lot of resources. Once identifying those queries you can attempt to execute them and […]
SSWUGtv: Today, Steve discusses Cross Versioned Systems.
Video Programming for IT Professionals
Understanding the sqlcmd utility – to run scripts, stored procedures, and Transact-SQL commands from the command line.
Understanding the sqlcmd utility – to run scripts, stored procedures, and Transact-SQL commands from the command line Author: Basit A. Farooq The sqlcmd utility is a Microsoft Win32 command prompt utility, which you can you to run scripts, stored procedures, and Transact-SQL commands from the command line. The sqlcmd utility establishes an OLE-DB connection to the database. To use sqlcmd...
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
The DB2Night Show #142: DB2 LUW Sage Performance Advice with Scott Hayes
(Scott Hayes) 100% of our audience learned something! Based on his IDUG Phoenix Top 10 presentation, Scott presents a new way to think about and analyze DB2 LUW performance.
Database Basics for Beginners
(Craig S. Mullins) Every now and then I get e-mail from readers of my blogs asking introductory/beginner questions about databases and DBMS. I cannot take the time to answer all of these e-mails in-depth, so I thought I blog a quick post with some good resources for folks.