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…
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.…
Please see my other Telerik articles. Customizing an input field within a grid In this article I’ll demonstrate how to customize a grid’s input field. Within the grid I have a field: FederalTaxID. A requirement was added to enforce this field’s unique format and provide the user a helpful hint as the enter data. First,…
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…
Please see my other Telerik articles. Providing a dropdown column filter In my Telerik Grid Dropdown article (link), I demonstrated how to use a dropdown within a grid column, allowing users to choose between predefined choices. However, the column’s filter method wasn’t very precise in that since the column only provided a predefined set of…
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…
Please see my other Web articles. Miscellaneous Visual Studio: Publishing Profile
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…
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…
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…
