(Craig Mullins) Naming conventions sometimes instigate conflict within the world of DB2, especially when it comes to views. But, really, it should be very easy. Just always remember, that a view is a logical table.
Other News
JRuby script to access Oracle Coherence MBean attributes
(Pas Apicella) I found a ruby gem known as “jmx4r” to use JMX from JRuby. The aim here was to use that to display details of an MBean’s attributes but found it not as easy as I thought it would be. Here are 2 ways I did that, to be honest using option 2 seemed the better way to do […]
Using jQuery Ajax to call ASP.NET JSON web service
(Suprotim Agarwal) The jQuery Ajax infrastructure allows you to perform asynchronous HTTP requests which makes it easy to call an ASP.NET JSON web service, using this api. Let us see how.
Replicating data loaded with BCP or Bulk Insert
(Chris Skorlinski) Yes you can use both Transactional and Merge Replication to move data inserted using the BCP.exe utility of the Bulk Insert command to Subscribers.
Subterranean IL: Fault exception handlers
(Simon Cooper) Fault event handlers are one of the two handler types that aren’t available in C#. It behaves exactly like a finally, except it is only run if control flow exits the block due to an exception being thrown.
SessionLess Controllers in ASP.NET MVC 3 – SessionState Attribute
(David Hayden) One of the new features in ASP.NET MVC 3 is the [SessionState] Attribute that can be decorated on controllers. Using the attribute, you can completely turn on or off session state, adjust it to readonly, or make it required using a SessionStateBehavior Enum with the following choices:
What are XML Elements and How Do You Create Them
(Darla Ferrara) One advantage XML has over other markup languages is the development of elements. Elements are key structures in XML, but flexible. In other language formats, you must use tags from a list available.
SharePoint 2010 User Profiles Service: Part 3 Adding WCF BCS Model
(Mohamed M Malek) In the previous post I described the exact scenario I am trying to implement and detailed how to create the WCF service and deploy it. In this post I will continue by describing how can we prepare this WCF to be consumed from the User Profiles Synchronization service using BCS.
SQL SERVER – DMV – sys.dm_os_waiting_tasks and sys.dm_exec_requests – Wait Type – Day 4 of 28
(Pinalkumar Dave) Previously, we covered the DMV sys.dm_os_wait_stats, and also saw how it can be useful to identify the major resource bottleneck. However, at the same time, we discussed that this is only useful when we are looking at an instance-level picture.
How InnoDB handles REDO logging
(Ewen Fortune) Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to explain another important mechanism that affects both response time and throughput – The transaction log.