(Rohit Pasrija) One of the features which is extensively used with SharePoint 2010 is Ribbons controls. In this post we would be creating a custom ribbon and open up a application page when ribbon is clicked using client object model using javascript
Other News
How to restore Oracle Grid Infrastructure OCR and vote disk on ASM
(Marcin Przepiorowski) After reading the book about Oracle RAC (see previous post) I decided to test recovery of OCR (Oracle Cluster Registry) file and vote disk placed on ASM disk groups. This is an operation I never did before. I was lucky enough and my ASM based RAC installation never had similar
The most dangerous game: Hunting down bad SQL query performance
(Don Jones) Once you’ve fine-tuned your databases’ indexes, maxed out your hardware and gotten the fastest disks money can buy, you’ll hit a limit on how much performance you can squeeze from your SQL Server machines.
Reset 11g XE APEX Password
(Michael McLaughlin) I’ve been busy working on other things since APEX 4 shipped. After I got through the installations of Oracle Database 11g XE (see prior posts), figuring out the default user name and password for APEX Administration became a tedious task. The documentation didn’t really help poi
DB2 Temporal Tables Performance: Three Important Modeling Considerations
(Dave Beulke) In previous blog entries I have talked about how to set up your DB2 temporal tables and how DB2 10 handles the temporal considerations nicely through the SYSTEM_TIME and BUSINESS_TIME definitions.
Some DB2 commands for the pureScale feature that saved my box…
(Henrik Loeser) Some days ago I told you about db2greg and how I used it to repair a DB2 pureScale demo cluster. Well, there are more commands that help to repair an inconsistent cluster, some are new DB2 commands.
Retrieving Data from MySQL via Python
(Tony Darnell) In an earlier post Connecting to MySQL with Python, we only returned a single result line from a “SELECT VERSION()” query. We will now take a look at returning multiple rows of data from a MySQL database using Python.
Creating and Managing Stored Procedure in SQL Server 2008
(Vishal Nayan) They are one or more SQL programs stored in a database as an executable object. They can be called interactively, from within a client application or from another stored procedure and from within triggers. We can pass parameters to and return from stored procedures to increase their u
Managing dynamic entities with Master Data Management Server and Master Information Hub
(Soma Shekar Naganna, Chitra Iyer and Lee McCallum) This article describes how and when to attach specs to entities of IBM InfoSphere Master Data Management Server and IBM InfoSphere Master Information Hub, allowing a lighter way for extending from and managing entities of the data model.
Optimize a SQL Server Analysis Services Measure Group Partition for Performance
(Siddharth Mehta) In SQL Server Analysis Services(SSAS), each measure group by default has at least one partition. When a cube is created, this partition would not have any aggregation schemes defined, so these partitions are not optimized for performance. As you know, aggregations are pre-calculate