SSRS: Conditional Background Colors

Configuring Background Colors Based on Multiple Factors In this article I’ll demonstrate how to change the background color of cells based on multiple conditions. First, I’ll start with a series of currency values. As you can see, the values will vary widely. The user of this report will receive many pages with these types of…

MVC: Links to External Sites

Display External Links within a View Sometimes within a View, a requirement dictates the use of links to sites external to the current project. Since Html.ActionLink() doesn’t allow for a target to an external site, I satisfied the requirement using the following approach. First, I stored with each record needing an external link the link…

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-Editor Template

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,…

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…

Telerik: Grid-Dropdown Column Filter

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…

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…