(Lars Besselmann-Hamandouche, Nick Bletzer, Simon Dickerson, Leonardo Rodriguez Leon, Roberto Mascarenhas, Giuliano Diniz de Morais, Rajath Ramesh and Carla Sadtler) Cloud computing provides companies with many capabilities to meet their business needs but can also mean that a hybrid architecture is
Other News
SQL Server – Know your query SET options – Properties window and DBCC USEROPTIONS
(Nakul Vachhrajani) The properties and behaviour of each session to a SQL Server instance can be handled individually via use of various SET options. As we multi-task during the day, we tend to forget the exact SET options that we choose for a particular user session. The focus of the day is how to
Java Generics in Oracle
(Michael McLaughlin) Somebody posed the question about using a Comparator in the sorting examples provided in this earlier post on Updating Table View Columns (columns using a Varray or Nested Table of a single scalar data type). It seems the individual thought that you can’t use Java Generics insid
DB2¡äs Got Talent ¨C Have You?
(Laura) This month our partners, DBI Software launch their second ¡°DB2¡äs Got Talent¡± competition to find real talent within the world of DB2. Open to DB2 users from both the LUW and z/OS camps this contest is designed to enable DB2 professionals from around the world share their knowledge and be
What Are the Differences Between DB2 for i and SQL Server SQL Syntax?
(Michael Sansoterra) It’s apparent by emails I’ve received that some SQL Server developers are having an opportunity to delve into the DB2 for i realm. Even though SQL would ideally be a platform-neutral, standards-based language, the truth is there are many SQL syntax and feature differences among
SQL Server integration with CLR aka SQL CLR (Part V – Creating a SQL server trigger in SQL CLR)
(Vishvvas) This is next write-up in the multipart series for SQL Server Integration with CLR aka SQL CLR and discusses the creation of SQL server trigger through SQL CLR.
Archiving Oracle
(David Fitzjarrell) Archiving older data is a complex task; local, national and sometimes international regulations dictate when, how and for how long the archived data must remain available. Add to that the seemingly insurmountable task of storing all of this data electronically and what appears, f
Topological vs Non-Topological Simplification/Generalization of Aggregated Area Geometies in Oracle
(Simon Greener) Oracle’s sdo_util.simplify function simplifies geometric object on the basis of a single geometry at a time. Using it on polygon data that totally covers an area, can and will cause major deformation of the shapes destroying topological integrity. This article describes the problem a
New Built-In TSQL Functions in SQL Server 2012
(Arshad Ali) SQL Server 2012 (Code named SQL Server Denali) introduces 14 new built in functions in four different categories with one existing function (LOG) being modified to have an optional second base parameter:
Running multiple websites in a single hosting space
(Bipin Joshi) Develop a solution that supports multiple websites in a single hosting space and database.