SQL Server: Maintenance Plan

Please see my other Database Development articles. Ensure successful disaster recovery for databases This section describes steps taken for database to backup data in preparation for a disaster. Recovery Model Of the three recovery models provided by SQL Server for its databases (Full, Simple, Bulk), the Full recovery model was chosen for its ability to…

SQL Server: Disaster Recovery

Please see my other Database Development articles. Ensuring Recovery from a Disaster This section describes how to recover data lost due to a disaster. As described in the last section, each database regularly performs the following backup types: Full: A complete copy of the database at a point in time. This occurs once a week.…

Telerik: Grid-Dropdown

Please see my other Telerik articles. Using dropdowns within grids In this article I’ll demonstrate how to use a dropdown within a Telerik grid. First, I’ll begin with the View Model used with CRUD operations on the grid. Regarding the first View Model, you’ll notice the UIHint decoration. This attribute instructs the website to use…

Visual Studio: Publishing Profile

Configuring Visual Studio for Dynamic Changes during Publish This article describes how to use setup a publishing profile to publish the site and configure sections of the site’s configuration file to change depending on the profile chosen. For example, when publishing the site to the testing layer, the database connection strings should target the testing…

Refactoring: Boundaries

Please see my other Web Development articles. Ensuring Separation of Concerns When refactoring a web application, the following table represents a high-level overview of technologies/tools and the appropriate use of each, along with examples of how their boundaries for us may be violated. Keep in mind for each tool is intended boundary and look for…

T-SQL: Subquery with Sum

Please see my other Database Development articles. Performing a subquery while Sum-ming a column In this article I will demonstrate how to use a subquery with SUM() to return parent records and related child records while aggregating currency amounts. First, I’ll start with a a couple customer records, each with two order records with a…

Telerik: Display Success/Failure Notification

Please see my other Telerik articles. Providing feedback to users upon submitting a page In this article I will demonstrate how to use Telerik’s Notification control to display a Success or Failure message to the user after a submit operation, providing them feedback whether or not it worked. I’ll start with a common grid with…