In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.
Did you know there’s an easier way how to create dynamic web sites? Learn how Kentico CMS for ASP.NET will increase your productivity and help you win more clients.
A wizard that allows you to FTP an application to a remote server and then launch the configuration wizard from the web browser to update the database connection.
This article will enhance your vision on the usage of Robustness Analysis in conjunction with Model View Controller, using UML with application in ASP.NET. This article is a sequel to my articles on Architecture and Design with ASP.NET.
Most systems that use Stored Procedures make use of SQL parameters to send and receive information from the database. The code to create these SQL parameters and then populating them is repeated throughout the system. This article describes how to automate this code.
This article provides a way for automatically testing SQL embedded in your Data Access Layer (DAL) before publishing a new release of your application.
ASQLDataGrid is a useful component when working with RDBMS applications. It is capable of automatically constructing and executing SQL statements based on its properties.
ASQLDataGrid is a useful component when working with RDBMS applications. It is capable to automatically construct and execute SQL statements based on its properties.
The generalized class has static functions that return dataset and datareader objects , It accepts string(name of xml tag that stores the query) and value to be supplied in case query accepts parameters
A trigger is a database object that is bound to a table. In many aspects, it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure".
In Part 1, we built a simple web chat using Silverlight 2. We are going to add functionalities so that users are able to choose from multiple chat rooms as well as chat privately with other users.
A plug-in for VS.NET that stores code snippets in a database. From the plug-in you can add code, search the database for code snippets. Also includes examples on how to integrate with the IDE as a plug-in.
This article is going to be served as an introduction to Expert C# 2005 Business Object by RockFord Lhotka which was written for business application developer.
Anybody can write code! With a few months of programming experience, you can write "working applications." Making it work is easy, but doing it the most efficient way requires more work than just making it work!
SQL DDLs for creating table structures and inserting the data for a set of tables suitable for producing pick lists for validation of the Month Names, Month Numbers, Days in each Month and Years in the 20th Century
This article compares various approaches to storing, editing, and displaying structured content on the web. It shows the advantages and disadvantages of using XML and relational SQL databases.
To dynamically generate a Google Map with combined data sources from an external web service or API and from an internal MS SQL database, using AJAX and the ASP.NET environment.
Convert a datetime value to .NET-compatible Ticks using a T-SQL User-Defined Function. Useful for interoperation between .NET and unmanaged environments such as ASP and VB6