MVC: Custom Validation

Using Custom Validation within a View While MVC provides many robust attributes within a Model to satisfy many validation scenarios, some situations exist which require custom logic to validate a user’s input. This article will illustrate how to implement your own routines to validate user input. First, create a new class which contains a “using…

T-SQL: Common Table Expressions

Performing Recursive Queries. Prior to SQL Server 2005, performing recursive actions on data required the use of temporary tables, cursive, or some other memory-intensive method. Now, performing such operations requires much less code and avoids the previous performance increase. For this example, we’ll begin with a generic table containing information about people. On the “Person”…

T-SQL: Rank()

Ranking Functions There are several new impressive advancements in the latest version of t-sql; this article will focus on “Ranking” functions. Prior to the release of SQL Server 2005 with its t-sql enhancements, working with blocks of related data was clunky at best. T-sql authors mostly relied on “GROUP BY” statements and then had to…

SSAS Viewing a Cube in Excel

Using Excel to View Cubes and Configure Pivot Table Reports Similar to my article SSAS BIDS Cube Browser, Microsoft provides another tool for any end user to view a cube’s measures and dimensions to configure highly analytical reports. First, use the wizard under the Data tab to configure an connection to your cube. In the…