(Knut Stolze) IBM DB2 for Linux, Unix, and Windows treats all strings stored in a database as case-sensitive. Some applications can — or even must — ignore the case of letters in strings and just want to retrieve data based on some given, mixed-case input. This article gives an overview of techniq
Other News
The ROI of XForms
(Dan McCreary) This article examines several methods of calculating the Return on Investment (ROI) of adopting enterprise-wide XForms standards. Explore ROI analysis from several different viewpoints, including the standards perspective and issues around vendor lock-in avoidance strategies. Learn ab
Workaround: Debugging Global.aspx.cs Application_Start() with ASP.Net Web Server within Visual Studio
(Vishal R. Joshi) When you add a global.asax file to your “Web Application Projects (WAPs) like below:
Excerpt from eBook Migrating to Oracle Database 11g
(Clint Boulton) In its 30th year, Oracle’s database is the most established software of its kind in the lot, showing that a mature product is OK as long as you lavish it with new perks.
Basics of Serialization in .NET Framework 3.0
(Uday Denduluri) Serialization is the process of converting an object into a stream of bytes. We generally perform serialization for persisting an object and saving a state of an object. The persisted location can be a file or a database. In .NET Framework when an object is serialized it not only pe
Data Encryption in SQL Server 2005 – Part I
(Muthusamy Anantha Kumar) Encryption is the key for data security. Sensitive data such as Social Security numbers, credit card numbers, passwords, etc. should be protected from hacking.
Oracle BI EE 10.1.3.3/2 – Bins and Groups
(Venkatakrishnan J) One of the features that end users generally want is the ability to group multiple dimension attribute values into their own understandable groupings. For example, if we have a Product Name column, then end users would like to group different products under different categories l
Changing the owner of a database
(Louis Davidson) Tonight, as I was creating my sample database for my chapter on implementing the database, I learned something new, that existed in 2005. I had always used sp_changedbowner to change the owner of a database, but I was reading in another section about ALTER AUTHORIZATION earlier to
Optimize T-SQL data types in SQL Server
(Matthew Schroeder) Many SQL Server developers do not give data types a lot of thought when they design database schemas. Initially it doesn’t seem to matter much and the performance looks pretty good, but, over time, the system slows down. Let’s take a look at the various SQL Server data types, the
DBCC Commands
(Buck Woody) When you us the graphical tools in SQL Server, you’re hiding a lot of complexity. The tools have more wizards than a fantasy novel, such as the Maintenance Wizard, the Index Tuning Wizard, and the Backup Wizard and others in SQL Server 2000. In SQL Server 2005 this changed a bit and you