Managing Connection Strings for Web Farms in ASP.NET 2.0

IntroductionWhat do I do with my connection strings? How do I encrypt them to protect my logins? Where should I store them? How can I share them across servers? These are questions that have plagued developers for ages. With .NET 1.0/1.1, a consensus has formed on storing this information in the web.config file. Encryption is fairly simple using the framework encryption libraries and letting...

Read More »

Using COALESEC Function in SQL SERVER

COLAESEC() Function When developing queries in SQL Server, dealing with nulls can often be challenging. The COALESCE function was included in SQL 2005 to help deal with these issues. First let’s take a look at what COALESCE can offer. Generally, COALESCE function receives a sequence of values and a default value to used when all of items in the sequence of values are null. From here the function...

Read More »

GLOBAL SEARCH IN SQL SERVER

--EXEC SearchAllTables 'A38010088' --GO Here is the complete stored procedure code: CREATE PROC SearchAllTables (     @SearchStr nvarchar(100) ) AS BEGIN     -- Copyright Ã�© 2002 Narayana Vyas Kondreddi. All rights reserved.     -- Purpose: To search all columns of all tables for a given search string     -- Written by: Narayana Vyas Kondreddi     -- Site: http://vyaskn.tripod.com     -- Tested...

Read More »

UPDATE QUERY USING CASE STATEMENT IN SQL SERVER

One of the keys to SQL Server database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation. By doing this, some transactions can be shorted, and performance boosted. --First Create a Table CREATE TABLE [dbo].[UsingCaseInUpdateQuery]( [id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NOT NULL, [gender] [varchar](50) NOT NULL, [address]...

Read More »