Encrypting Web.config sections in ASP.NET 2.0

Now you can actually encrypt any section of your Web.config file on-the-fly and programatically. If you have full access to your Web server, you can encrypt your connection strings with this single command-line located in the in the %windows%\Microsoft.NET\Framework\versionNumber folder. Read more...

Introducing ASP.NET 2.0 with Visual Studio 2005 Plus Grid View

The following article introduces you to designing and working with an SQL Server 2005 database using the Visual Studio 2005 Integrated Development Environment. You will also learn how to work with the “Grid View” control. Read more...

Retrieving SQL Server 2005 Database Info Using SMO: Basics

The following article focuses on retrieving SQL Server 2005 information using SMO together with Visual Basic 2005 and Visual Studio 2005. SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating Microsoft® SQL Server™'s database and replication management. SQL-DMO is a dual interface COM, in-process server implemented as a dynamic-link library (DLL). SQL-DMO encapsulates SQL Server components, presenting the attributes of the component piece to you as the properties of an object instance. We can alter the properties of the instance, or use object methods to automate SQL Server administration, including replication. Read more...