(Scott Lysle) This article shall describe an approach to working with delimited text files. In general it will discuss the construction of the connection strings and schema.ini files needed to bind to a delimited text file and it will define an approach for editing and saving delimited text files.
Other News
IBM Cognos Proven Practices: IBM Cognos BI – Working with Tab Controls in IBM Cognos Active Report
A brief video illustrating how to use tab controls in an IBM Cognos Active Report.
Overview of Peer-to-Peer Transactional Replication in SQL Server 2008
(Murali Krishnan) Some time back, I was discussing multi-master database replication requirements which have data redundancy and read performance improvements. As per our need, we have multiple locations and the databases should be synchronized continuously and users can connect to any location if n
Security
Security When we think about security we often focus on things such as encryption, policies, procedures, building access processes, passwords and the like. We even look into tools for secure Email messaging. However, many of us walk around with the keys to the company residing in our laptop. Often, if we are developers, we have the source code in some […]
Parallel Query Deadlocks
SSWUGtv – New Show! Will the cloud HELP our databases? Laura Rose, the news of the day and more. Also, the first in a series of segments on scale up vs. scale out and options that are available. [Watch the Show] Previously… Interview with Denny Cherry, SQL Server MVP and SSWUG.ORG Class Presenter. We also have the latest news on […]
HOWTO: Consume Anydata via XMLType (and back)
(Marco Gralike) This was a small mind exercise on the OakTable website (OakTable Challenge)for a person regarding how to go from a relational table to anydata datatype table and back, which I, of course, approached via an “XMLType” of way thinking.
Custom Exception Registration for ADF BC EO Attribute
(Andrejus Baranovskis) Sometimes customers prefer to implement business logic validation completely in Java, without using ADF BC declarative/Groovy validation rules. Thats fine, we can code business logic validation in ADF and implement different custom validation methods on VO/EO level.
How to Work with Managed Metadata Columns by Using the SharePoint Client Object Model
(Kaushalendra Kumar) Managed metadata is a hierarchical collection of centrally managed terms that you can define and then use as attributes for items in Microsoft SharePoint Server 2010. Managed terms can act as sources of data for columns in libraries or lists.
Using jQuery As A Named Module In RequireJS
(Ben Nadel) With the release of jQuery 1.7, there’s been some amorphous buzz about the support between AMD (Asynchronous Module Definition) script loaders and the jQuery library. I say, “amorphous,” because I simply don’t understand what that support entails.
Quoting text JavaScript/Python style
(Shlomi Noach) Unless your MySQL is configured to use ANSI_QUOTES in sql_mode, you are able to quote your text in one of two forms: using single quotes or double quotes: