(Andrew Reid) I tried to do a FAST refresh of a materialized view in Oracle 11.2 but it failed with an ORA-12004:
Other News
AngularJS Code Smell: Defining $scope Methods In Directives
(Ben Nadel) I’ve touched on this idea before, in my AngularJS directive mindset post; but, I’ve seen this happen so many times that I wanted to call it out again, as its own concept. If you define $scope methods inside of your AngularJS directives, you might want to consider this a “code smell.”
The Efficacy of Code Generators
Dilip shares experience using code generating tools: Here, is what I have experienced by using some of the popular code generating software tools. There are merits and de-merits in using self generating codes software. And still, I have always looked at them as key contributors. The benefits we experienced It gives many logical clues which perhaps we might have missed. […]
Visual Studio Online REST APIs and Service Hooks
(S. Somasegar) Since we launched Visual Studio Online last November, we’ve seen great adoption and usage across enterprise, small business and personal users, with over a million accounts created so far. With team collaboration, agile development, application insights, and hosted build and test se
How to Change the COLLATION of a SQL Server Column
(Ben Snaidero) You’ve installed SQL Server with all the defaults, created your database and schema then loaded a bunch of data into your database. Now you realize that some or all of the columns in your database needed to have the COLLATION set to be case sensitive.
Engineering behind EXPLAIN FORMAT=JSON (or lack thereof)
(Sergey Petrunia) MySQL 5.6 has added support for EXPLAIN FORMAT=JSON. The basic use case for that feature is that one can look at the JSON output and see more details about the query plan. More advanced/specific use cases are difficult, though.
DB2 Tips n Tricks Part 33 – How to set Client Application Name for Client Connection
(Harishkumar Baburao Pathangay) How to set custom,user friendly Client Application Name for Client Connection Solution:
Learn HTML5 – Part 2: Web Workers
(Manish Tewatia) In this part of the Learn HTML5 series you will learn about the Web Workers API, what is it all about and how to use it with an example.
ore.parallel
(Brendan Tierney) In ORE there are a number ways to get you R scripts to run in parallel in the database. One way is to enable the Parallel option in ORE. This is what will be shown in this post. There are other methods of running various ORE commands/scripts in parallel.
REPL_SCHEMA_ACCESS wait type
(Jack Li) Recently we have worked with a customer on replication latency issue with transactional replication. Customer has over 30 published databases on a single server. All of them are very active. Periodically, they will see up to 30 minutes latency from publisher to distributor.