(Adriaan de Jonge) Service Oriented Architecture usually implies heavyweight technology for large enterprises. The advantages of the SOA architectural pattern also apply to smaller environments. To follow SOA principles, you don’t necessarily need all the overhead that is useful in larger environmen
Other News
ASP.NET basics: Working with the TextBox control
(Tony Patton) Developers often overlook basic programming options in favor of new or cool ways to deliver results. This is true for many of the standard ASP.NET features. A good example is the TextBox Web control, which offers plenty of options for building applications. This week, I take a closer l
Becoming a Certified Informix Professional
(Eric Herber) Have you ever thought about becoming a certified IBM Informix professional? This article will give you an overview of the current IBM certification test 918 – System Administration for IBM Informix Dynamic Server 11.
Secrets of the MySQL Client Command Line
(W. Jason Gilmore) Graphically oriented MySQL administration tools abound, but for true speed and no-frills management perhaps nothing is more effective than the command-line driven MySQL client. However, the inordinate amount of typing due to executing common queries, determining what database you’
Encrypted Tablespaces in Oracle 11g
Starting with Oracle 11g, we can now encrypt an entire tablespace instead of encrypting a single column. With the increased security concerns pertaining to data, this new feature can definitely help a lot. Data from encrypted tablespace remains encrypted when data is written to the operating system
Why Bulk Import?
(Sunil Agarwal) Most IT shops using SQL Server need to load/import large amount of data obtained from external sources or from another Database Server into SQL Sever. It is typcially done using the optimized insert path provided by SQL Server through Bulk Insert and BCP commands. Customers often won
MDX Numeric Functions: The Min() Function
(William Pearson) In this article, we will introduce another “staple” MDX numeric function, the Min() function. Min(), like Max(), is one of several aggregate functions with which we can choose to perform aggregations upon a set of values. (We introduce other aggregate functions within individual ar
Oracle BI EE 10.1.3.3/2 – Adding Watermarks to Delivered PDF Documents – Using PDF Merger API of BI Publisher
(Venkatakrishnan J) In the previous blog entry we have seen how to go about delivering documents to a local file system using the Delivery Manager API of BI Publisher. Along the same lines, lets look at another very interesting feature which is the PDF WaterMarking feature. Many a time you might wan
Close Those Loopholes: Stress-Test those Stored Procedures
(Alex Kuznetsov) In some cases, stored procedures will work perfectly as long as there is no concurrency, but then fail intermittently in a more realistic multi-user environment. I will explain this in more detail, as well as provide some examples, below. In this article I shall demonstrate a few si
Using Oracle’s SDO_NN Operator – Some examples
(Simon Greener) This little article was occasioned by someone emailing me and asking me: Actually I do have a topic for you – clustering. Before we moved to Oracle Spatial, we had a request for a client to: “Show us all the stores that are close to each other”. I’m somewhat embarrassed to say tha