(Jeff Smith) We recently covered how to set the classification type of multiple tables in a data model, but today I want to show how to make these easier to identify in your model.
Author: SSWUG Research
COMMIT / ROLLBACK in Oracle and PostgreSQL
(Lucas Wagner) The use of transactions in relational databases allows a database architect to logically group SQL into chunks of SQL code which can execute using an “all or nothing” strategy. In case of disaster, such as power loss or a network outage, grouping a selection of SQL statements into a t
Overview of XML and JSON Generation From Java Object
(Debadatta Mishra) This article provides you a brief view of generating XML and JSON from the Java object. Have you ever thought of any situation where you previously generated a XML file and due to some change your architect or manager told you to convert the Java object to JSON?
Bananas, pants, and DB2 with BLU Acceleration
(Henrik Loeser) Have you ever fed a banana to a young child? It would have been banana puree, i.e., mashed bananas (there are even instructions for that!). When you think about it, after feeding the banana puree you have a happy child – and a fork, a spoon, a plate and maybe more to wash. As a grown
ADF Essentials 12c ADF BC ‘BO_SP’ ORA-01086 Error
(Andrejus Baranovskis) It seems like there are differences running same ADF application on WebLogic and on Glassfish runtime. These differences are minor but could cause some headache to the developers. In this particular case, I would like to describe ORA-01086: savepoint ‘BO-SP’ never established
CREATE SCHEMA IF NOT EXISTS in 9.3 and tiger geocoder
(Leo Hsu and Regina Obe) One of the new features in PostgreSQL 9.3 is CREATE SCHEMA IF NOT EXISTS someschema;. We were so excited about this new feature that we started using it in the tiger geocoder loader routine. For some reason we thought it was available since 9.1 which gained CREATE TABLE IF N
Showing the Same Code in Several Windows
(Richard Carr) When working with large files it is sometimes necessary to view several areas of the code at the same time. If these areas are far apart, it can be useful to view the same source file in multiple Visual Studio editor windows.
SQL Server Tip: Assign Ownership of Jobs to the SysAdmin Account
(Michael K. Campbell) As with most SQL Server best practices, this one comes with a few caveats—in that it might not be the best option in all environments or scenarios. But, for most servers deployed in most SMBs—especially where a few users might have the ability to create jobs or where there migh
Concatenation of Different SQL Server Data Types
(Chad Churchwell) Is there a way to concatenate different data types in TSQL that does not require me to convert everything to the same data type.
Central jQuery Version Control
(Sitang Ruan) This article describes a way for central control of jQuery version in an application which will make code consistent and make it easy to upgrade jQuery.