(David Cassel) I just got my first taste of one of the new features in MarkLogic 7: the ability to do partial document updates through the built-in REST API. It made me happy.
Author: SSWUG Research
Build and Deploy Stored Procedures with IBM Data Studio
(Cindy Russell) Learn the benefits of stored procedures and how to use IBM Data Studo to create and deploy them. Data Studio is free software from IBM.
Using Collections In Oracle
(David Fitzjarrell) Collections are an interesting lot. They can be one of the most useful tools in the Oracle arsenal, yet they can also be very frustrating to implement. For those unfamiliar with them, a collection/varray is defined as “an ordered group of elements, all of the same type.
ORA-04042
(Andrew Reid) If you try to grant execute access to a non-existent procedure, you get an ORA-04042. You can see what I mean in the example below, which I ran in an Oracle 9 database:
Applying IBM InfoSphere Information Analyzer rules for operational quality measurements
(Harald Smith) A key challenge in the day to day management of any solution is in measuring whether the solution components are meeting IT and business expectations. Given these requirements, it becomes incumbent upon IT to build processes where performance against these objectives can be tracked.
Using hidden columns for range partitioning (Temenos T24)
(Henrik Loeser) In one of my post regarding performance tuning for Temenos T24 on DB2 I hinted that a hidden column could be used to range partition a table. There have been questions on how to do it and what to use.
SharePoint Designer 2013: Where did Split & Design view go?
(Unbounded Solutions) When SharePoint 2013 rolled out, our Microsoft SharePoint Consultants had a lot of fun exploring the new features and the new functionality. Yet when it came time to do some branding work, something wasn’t feeling right.
jQuery – How to select Nodes by ID and Class Name? – Example
(Arun Ramachandran India) Before going to the example directly, let’s refresh the important points to ponder while selecting nodes by Tag Name,ID and Class Name.
Understanding how SQL Server handles Service Isolation
(K. Brian Kelley) When I look at who is connected to my SQL Server, for instance by sys.dm_exec_sessions, I see a login that hasn’t been granted access when I check the Logins folder. I know the login is the SQL Server Agent service account. I see “NT ServiceSQL Agent” but I don’t see any connectio
How to recover table structure from .frm files with MySQL Utilities
(Miguel Angel Nieto) Table structures are stored in .frm files and in the InnoDB Data Dictionary. Sometimes, usually in data recovery issues, we need to recover those structures to be able to find the lost data or just to recreate the tables.