(Andrew Reid) This was tested on Oracle 11.2. I created a table with one VARCHAR2 column, which was 15 characters long:
Author: SSWUG Research
5 Performance Tips from the 2013 Holiday Rush
(Dave Beulke) Since this holiday season is shorter and more people hate the mall crowds, billions will be spent online this season. Unfortunately for management, lack of application development testing, up-to-date standards, and performance procedures will hinder profitability through poor performa
Parallel replication: off by one
(Giuseppe Maxia) One of the most common errors in development is where a loop or a retrieval by index falls short or long by one unit, usually because of an oversight or a logic in coding.
Using XPath to Query the Internet
(Bruce Yang cp) Once upon a time, people used HTML to ship data, year after year. Internet became the biggest datasource of the world, but unlike databases that have SQL, Internet has the lack of a query language. Fortunately, HTML is just like XML, and is easily translated to XML.
SQL Diagnostics Project Part 1 – Configuring Custom SQL Data Collections
(Tim Chapman) This blog post will be part 1 in a multi-post series where I show you how to create your own custom SQL Server troubleshooting data collections, how to load the data into a SQL Server database, and how to create your own custom reports based on the data you collect.
Creating a SQL Server Linked Server to SQLite to Import Data
(Graham Okely) You have data in SQLite databases on mobile devices you would like to import into SQL Server. In this tip we walk through the steps on how to import this data into SQL Server.
Visualizing A Git Merge Without A Rebase
(Ben Nadel) I’ve been using Git (and GitHub) fairly heavily for about the last 2 years. And, slowly but surely, I’m getting better at it. That said, I still have trouble mentally visualizing some of the operations.
ADF Development Survival Kit – Essentials for ADF Developer
(Andrejus Baranovskis) This post is about our second session on UKOUG Tech12 conference. We were presenting and describing essential tools for successful ADF development. These tools are not available from Oracle, but can be implemented by yourself.
DB2 Tips n Tricks Part 18 – How to Find Routine Name from Package Name
(Harishkumar Baburao Pathangay) How to Find Routine Name from Package Name Types of Routines – UDF or Stored Procedure Admin View : SYSCAT.ROUTINEDEP
Postgres 9.3 feature highlight: COPY TO/FROM PROGRAM
(Michael Paquier) Postgres 9.3 brings a new option for COPY allowing to pipe data with an external program, both in input and output. This feature has been added in the following commit: