Video Programming for IT Professionals
Other News
How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines
(Marcin Przepiorowski) SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query.
MarkLogic: Search API – removing facet constraints using XQuery and xdmp:set
(Alex Bleasdale) This is some partial code outlining an approach for removing facet constrints from a query string. Thanks to David Cassel for suggesting the use of xdmp:set to maintain state throughout the process.
Let’s discuss an older ZPARM for a change: SYNCVAL
(Willie Favero) The SYNCVAL parameter has been around for what seems like forever. Yet, I still find people who do not understand what’s used for. I also still bump into folk who think it pertains only to data sharing.
Understanding MySQL Joins
(Alejandro Gervasio) It’s hard to admit, but sooner or later we have to face the facts: most web developers (including myself) are reluctant to write SQL queries from scratch.
WPF Color Picker VS2010 Style
(Ury Jamshy) As a relatively newcomer to WPF, I decided to create a (yet another) Color Picker control, styled after the Visual Studio 2010 Color Picker. It seemed like a good exercise and also practically useful for many applications. In this article, I describe briefly some of the obstacles I stum
Maintain SQL Server Replication using Source Control
(Kun Lee) My company relies on replication intensively and we have many different SQL Server versions and configurations to support. For example, some publications are replicating data every minute, some continuous and others on demand. In addition, we have several replication articles with differen
Oracle Tip: Counting ROWS for all tables in a Schema
(Vagabond) There are quite a few methods to find out the count of records in the schema tables.
Consuming SQL Server Result Sets as XML with PHP
(Brian Swan) At last month’s SQL Server JumpIn! Camp, one of the SQL Server features that generated some excitement among the participants was SQL Server’s ability to return result sets as XML. I felt a bit foolish for not having investigated this feature, so I’m rectifying that with this post.
Get Your System Humming: 7 Great Tips for Tuning DB2 for i
(Kent Milligan) All of you have users and bosses who regularly ask if it’s possible to make applications and reports run faster on your IBM i. Usually, these applications and reports spend a significant amount of time processing data stored in your DB2 for i databases. This article contains seven DB