(Andrew Reid) I noticed recently that, when you create a role, it is automatically granted to you with the admin option. You can see what I mean in the example below, which I tested in Oracle 11.2:
Author: SSWUG Research
Oracle 12cR1, UDF Pragma and HyperLogLog
(Alex Fatkulin) One interesting enhancement in 12cR1 PL/SQL is UDF pragma which has the following description:
How to configure Log4j in Java program without XML or Properties File
(Javin Paul) Sometime configuring Log4j using XML or properties file looks annoying, especially if your program not able to find them because of some classpath issues, wouldn’t it be nice if you can configure and use Log4j without using any configuration file e.g. XML or properties.
ASP.NET MVC CustomModelBinder with JQuery Collection
(Vaishali Tanwar) Ever faced a situation in ASP.NET MVC where you need to dynamically create multiple instances of derived class objects ( where collection of base class is used as a property in another class), and save the main class in just a single click ?? (This could do wonders for you and save
Cutting SAP Down To (a Manageable) Size
(Martin Hubel) The DBA wouldn’t touch it as there are 83,000 tables in SAP. He was busy with other applications, and he had no time in dealing with a big package that was a mess. During development, there had been no DBA assigned to the project, and now it was time for some database attention to get
Accelerating Analytics Queries
(Thuan Bui) The preponderance and variety of data available to today’s enterprises open up tremendous opportunities across many industries. Organizations increasingly have access to a treasure trove of structured and unstructured data that can lead to keen insights on aspects of the business to help
DB2: How to find records with non-printable characters (SQLSTATE 01517)
(Mark Jacobsen) If you run a select statement and get the following error…
Particle Swarm Optimization Using C#
(James McCaffrey) Particle swarm optimization (PSO) is a technique for finding approximate solutions to difficult or impossible numeric optimization problems. In particular, PSO can be used to train a neural network.
ASP.NET N-Layered Applications – Implementing a WCF 4.5 Frontend (Part 8)
(Imar Spaanjaars) This is Part 8 in a series of 10 that show you how to build N-Layered applications using ASP.NET 4.5 and Entity Framework 5 Code First. In this part you’ll see how to build a WCF service that makes use of the model and repository projects I have shown in the first five articles in
ALTER TABLE and downtime, part II
(Josh Berkus) Now, you’ll note in part I that I said that doing certain ALTER operations was “free”, in quotes. That’s because these operations aren’t actually worry-free; there’s the major issue of locking.