Database Development Zone

emoving extra empty spaces is a pretty common task that seems very simple, but in reality it is not as trivial as you may assume. The first impulsive solution that

rocessing text or long strings in SQL has never been an easy task. SQL is a powerful language for performing fast operations on data sets, but when it comes to

ince its first release, Microsoft SQL Server Reporting Services (SSRS) has supported a plethora of data sources. Out of the box, its data modules, called data extensions, allow you to

racle recently released version 1.0 of SQL Developer, its free PL/SQL development IDE. Formerly known as Project Raptor, Oracle SQL Developer is based on the same IDE platform as JDeveloper

atabase performance is one of the most critical characteristics of almost any application, and for the developer or DBA it usually depends on how fast they can retrieve data. Hence,

n index on a computed column can boost your SQL Server query’s performance or even implement a complex business rule. (Computed columns do not store their own values; their values

hen I was writing code for user interfaces, I needed to present data in different ways. Logically it wasn’t difficult, but since the presentation layout was often quite different from

n our increasingly interconnected world, it’s more and more important for code to be able to handle time zones gracefully. For example, if call centers in Bangalore and London use

ML, Arrays, DataSets, database tables, collections of all types?all these have a common attribute; they are data stores that hold sets of data values or objects grouped together for some