(Pinal Dave) One of the most common data integration tasks I run into is a desire to move data from a file into a database table. Generally the user is familiar with his data, the structure of the file, and the database table, but is unfamiliar with data integration tools and therefore views this t
Other News
jQuery Appends Multiple Elements Using Efficient Document Fragments
(Ben Nadel) Earlier today, in my blog post on using jQuery’s $.map() method, I talked about creating a buffer of detached DOM (Document Object Model) nodes. The value-add behind that post was the fact that the DOM nodes remained detached as long as possible; this allows them to be created and config
Smarter is: Putting renewable energy on the map
(David Geer) Vestas Wind Systems of Aarhus, Denmark uses IBM InfoSphere BigInsights to analyze location-specific data, such as wind speed, temperature, humidity, atmospheric pressure, and precipitation, in order to predict wind farm performance. This helps them to install wind turbines at optimal lo
JSON Compared to XML
JSON Compared to XML XML is a much older specification and has been used for over a decade. JSON is much newer, requiring a much smaller string to define an object and the data the string contains. XML was designed to define, organize and contain data. JSON was designed to pass objects from one process to another in the form […]
Will JSON Replace XML?
Will JSON Replace XML? JavaScript Object Notation (JSON) is a technique for passing structured data across processes in the form of a string. This technique results in the ability to pass JSON data across network protocols that prefer string traffic, such as HTTP. Data can be serialized into a JSON string much the same as XML. The key difference is […]
SQL Server Reporting Services – Insufficient Rights Error
(Franco Lopes) At times when we successfully deploy the reports to the report server and try to view them through report manager we may encounter am insufficient rights error. This article focuses on resolving that error.
DATEFROMPARTS function – SQL Server Denali
(VidhyaSagar) Yesterday we discussed about time function, today we are going to see DATEFROMPARTS function which is new in SQL Server Denali. It will return a date value for the specified year, month and day. All the arguments should be valid else error is thrown, if you have NULL value in argument
SQL Server – New Table Value Parameter
(piyush.bajaj.2007) Table-Valued Parameter is a new parameter type which has been introduced with the arrival of SQL Server 2008.
dNFS configuration and Hybrid Column Compression
(Marcin Przepiorowski) After my post about Hybrid Column Compression Kevin Closson suggested that there is a chance that Oracle doesn’t check what kind of storage is sitting behind NFS volumes. I followed after that idea and I had checked if I was able to create table with HCC on Open Filer or build
On the methodvalue attribute in layer.xml file
(Geertjan Wielenga) The methodvalue attribute can be in form of pgk1.pkg2.ClassName.methodName which should point to existing class with static method usually having no, one or two arguments.