Other News

Community

LTRIM RTRIM doesn’t always work

(Israel Cris Valenzuela) It is a frequent occurrence that we must remove leading and trailing whitespaces from a string before additional processing or sending it to another layer in an application. We can’t always control how the data is entered. The data might come from another system, a data conv

Editorials

SQL Merge

SQL Merge One typical task of an SQL developer is to merge two sets of data. For example, you may have a data entry screen where users may modify existing data, delete rows, and insert rows into the same set. Then you wish to merge these modifications with the existing set of data in your relational database. There are a […]

Editorials Encryption/Data Security Townsend Security

Back to the Cloud

Featured Article(s) Troubleshooting SQL Server 2008 performance counters problems In this article, Alexander Chigrik explains some problems that you can have with SQL Server 2008 performance counters. He also tells how you can resolve these problems.SQL Server 2012 Release – Beginning to Understand the Changes SQL Server 2012 brings a while series of changes to the platform, from more crystalized […]