Tags: sql

Query across servers in Microsoft SQL Server 2005

If your organization/project has data repositories spread across more than one database server, chances are that you will eventually want to pull data from more than one server instance in a single query. If you want to perform these cross-server queries without setting up a persistent Linked Server configuration, a particular configuration option is required. Read More →

Using the ConnectionStrings element in ASP.NET web.config

If you are building a series of web applications that may rely on duplicate data (such as connection strings for pages that query databases), or you want to separate certain constants from your other code, you need a centralized method for storing and referencing that data. In this case, the ConnectionStrings element in the web.config file of either your application’s root directory, parent directory, or the web server root directory–depending on your application’s inheritance–can prove incredibly useful. Read More →