(Arpit Jain) In this article I will show you how to add a table highlighting feature in a HTML table. I assume that you have some basic knowledge of HTML, CSS3 and jQuery. If you are not familiar with jQuery then check the links provided at the end of the article.
Author: SSWUG Research
10 MySQL settings to tune after installation
(Stephane Combaudon) When we are hired for a MySQL performance audit, we are expected to review the MySQL configuration and to suggest improvements. Many people are surprised because in most cases, we only suggest to change a few settings even though hundreds of options are available. The goal of th
Different Approach for DB Constraint Error Handling in ADF
(Andrejus Baranovskis) Let’s be honest – no matter how developer friendly and stable validation rules support would be in ADF BC, there will be always use cases when validation logic will be executed directly in DB, by check constraints for example.
Search Today and Beyond: Optimizing for the Semantic Web
(Kerstin Recker) Search has changed dramatically over the past year and semantic technology has been at the center of it all. Consumers increasingly expect search engines to understand natural language and perceive the intent behind the words they type in, and search engine algorithms are rising to
Using R with databases
(Grant Hutchison) R is not just the 18th letter of the English language alphabet, it is a very powerful open source programming language that excels at data analysis and graphics. This article explains how to use the power of R with data that’s housed in relational database servers. Learn how to use
The difference between SELECT ANY DICTIONARY and SELECT_CATALOG_ROLE
(Hemant K Chitale) I’ve seen some DBAs confused about these two “privileges” or “roles”.
Progressive Server-side Validation by Group in ASP.NET
(Peter Vogel) I didn’t know this until my fellow instructor at Learning Tree (and author of Learning Tree’s ASP.NET Web Forms course), Kevin Rattan, pointed it out to me: when you trigger validation at the server by calling the Validate method, you can pass the name of a Validation Group to the meth
10 Monthly Maintenance Tasks for SQL Server
(Jason Strate) Are you doing what you must to ensure that your SQL Server environment is behaving as you, or your manager, expects that it is?
How to move databases configured for SQL Server AlwaysOn
(karthick Krishnamurthy) This article describes how to change the location of the data files and the log files for any Microsoft SQL Server 2012 database which are configured with SQL Server AlwaysOn with minimal downtime.
ORA-00604, ORA-04092, ORA-06512 and ORA-00942
(Andrew Reid) I saw an ORA-00604 in a database recently and decided to see what might have caused it. The test below was run in an Oracle 9 database and shows one possible reason for an ORA-00604. Strangely enough, when I repeated the test in Oracle 10 and Oracle 11 databases, the ORA-00604 did not