(Bryan Bell) To begin: Semantics is the study of meaning. It focuses on the relation between words and phrases and due to the relationship what they mean in context. Semantics is a game changer when it comes to the management of large volumes of structured and unstructured data.
Other News
Concatenate Strings in SQL Server – Different ways
(Madhivanan) There are many ways to concatenate data in a single column. Consider the following table:
Top 10 Index T-SQL Statements That SQL Server DBAs Should Know
(Muthusamy Anantha Kumar) SQL Server DBAs know that indexes in databases are very similar to indexes in libraries. An index in a database is a structure associated with a table or view that speeds retrieval of rows from the table or view.
Scaling Web Databases: Auto-Sharding with MySQL Cluster
(Mat Keep) The realities of today’s successful web services are creating new demands that many legacy databases were just not designed to handle:
ADF BC Application Module Data Control Hints for JDeveloper 11g R2 ADF Libraries
(Andrejus Baranovskis) I got a question from blog reader, based on my previous post – How To Reduce Database Connections and Reuse ViewController Layer. This post is based on ADF library dependencies with ADF BC objects – library is not imported directly into project, but is accessed through proxy l
Histogram on VARCHAR2 column having first 32 character identicals
(Anand) Recently i read the below link and came to know that,while creating histogram on a VARCHAR2 column, Oracle will only consider the first 32 characters in the column. In other words, if the first 32 bytes of the column values are identical all of the values end up in a single bucket of the his
VS2010 Tip – How to Launch ILDASM from VS2010 IDE
(Hima B Vejella) What is ILDASM is Intermediate Language Dissembler SDK Tool that is used to examine MSIL code and the parts of the Assembly. It comes with the installation of Visual Studio IDE. If you want to examine how your compiler is executing your code and debug your program into depth, unders
Coded UI Test: Convert Normal CUIT to Data Driven CUIT using Visual Studio 2010
(Gouri Sohoni) In the previous articles, we have discussed How to create CUIT by using CUIT Builder, How to create CUIT by converting manual to automated and Variations and Editing with CUIT. In this article, we will discuss how existing CUIT can be converted to take up data from any Data Source.
Thinking About Encapsulation And Direct Object References
(Ben Nadel) After reading JavaScript Web Applications by Alex MacCaw, I have been reinvigorated in my desire to learn more about Object Oriented Programming (OOP) and Model-View-Controller (MVC) architectures; both in general and specifically in thick-client applications.
ASP.NET: Exploiting DataSources’ Events
(Peter Vogel) Using the events that are fired by the DataSources when doing retrievals and updates gives you additional control over your application. The DataSources fire *ing events before doing anything (e.g. the Deleting event fires before issuing a delete) and fires *ed events afterwards (e.g.