(Andrejus Baranovskis) If you are working with Oracle UCM 11g, I can imagine you may encounter hard times, when thinking about content security architecture design. But really, its not so complex – as it looks first, just there are lots of confusion between Security Groups, Accounts and Access Contr
Other News
Using Visual Studio Debugger Attributes
(Bipin Joshi) Visual Studio provides a rich debugging experience to developers, helping them write robust and bug free code. In simple projects, the inbuilt facilities of Visual Studio debugger may be sufficient for your purpose, however, while debugging complex projects you may want to enhance the
TechTip: Cast Binary Data to Built-in Data Types
(Michael Sansoterra) Whether it be a hash value, raw data from another system, or something else, every once in a while, I find myself manipulating binary data within an application. However, in SQL, it’s a royal pain to convert binary data to another built-in data type.
Performance impact: stored procedures, SQL batches, and CPU usage
(Linchi Shea) What is the simplest way to drive a CPU to 100% using T-SQL? If it’s a language like C++ or C#, the simplest way is to create a tight loop and perform some work that uses CPU cycles inside the loop. For instance, the following tight loop in C# can peg a CPU to 100%:
HADR as a migration tool – a cool way to migrate data!!
(Jeyabarathi(JB) Chakrapani) In this article you can read about an unconventional and cool way of using the DB2 HADR tool for data migration. I presented this method of using the DB2 High Availability Disaster Recovery feature as a tool to migrate a database for the 2011 spring “DB2’s got talent”
More on OR-conditions considered bad… And an apology..
(Anders Karlsson) In my recent post on OR-conditions I made a mistake, and I appologize for that. I made the statement that MySQL will only use 1 index per statement, whatever you do.
Using Temp Table in SQL Server And Adding Columns Dynamically
(Amit) While creating a stored procedure it’s often necessary to create temporary tables to hold temporary operational data. To do that there are options available in SQL Server you can use; Cursors, #Temp tables or Table variables.
A Simple XML Parser from Scratch
(rj45) This is an implementation of a subset of the XML classes provided in .NET. This may be useful since it does run faster than the .NET classes, although it has less features and has some bugs. If you know exactly what data you need from a document, this is a fast approach to pull it out.
IBM Cognos Proven Practices: IBM Cognos BI – Use the Member Function or a Calculated Measure to Enhance a Dimensional Report
(Vijendra Sawant) A brief video illustrating how to use the Member function or a Calculated Measure to ensure the output of a calculation returns a member which can be referenced in another dimensional function.
SSRS 2008 R2 KPIs with bullet graphs
(Siddharth Mehta) Key Performance Indicators are typically displayed in a scorecard with stop light indicators, which are either red, amber or green light icons. The limitation for these kind of indicators is that you can see the actual and target values in two different fields as well as see the st