Dave Jinkerson, Author at FMT

Search Archive
Beyond WebAPI Conventions, Migrating to WebAPI 2
Trending @Microsoft: Routing, by Convention, is how ASP.NET WebAPI matches a URI String to an action. WebAPI 2 supports a new type of routing, which leverages attributes. As the name implies, attribute routing uses attributes to define routes rather than Parametrized Strings, as in WebAPI. Attribute routing provides more control over the URIs and scale of a web API. This implies… Support for Hierarchical URI schemes Eliminating magic route templates Intuitive route constraints HTTP Method attributes Route prefixes …And WebAPI 2 now provides the attributes to easily support application modeling. WebAPI and WebAPI 2 are complementing technologies and can be mixed and matched within the same API; let's look at the similarities, strengths, and weakness of the WebAPI versions… WebAPI by convention… Routing tables Routing templates Routing actions HTTP Methods OData query MapHttpRoute WebAPI 2 by attribute… Routing tables Routing attributes Routing actions HTTP attributes OData query MapHttpAttributeRoute Migrating from […]
Optimizing SQL Server Files and File-Groups Made Easy
Recently I had the opportunity to work with a client on a very large Web Application; the database for this application was composed of hundreds of tables, indexes, file-groups, and files; including a dozen partition-functions and as many partition-schemes, spanning both clustered and non-clustered indexes. The client was requesting to improve performance in their database as they moved this massive application to Azure Services. In order to accomplish this, I had to complete three of the following tasks: Move all clustered indexes into fewer file-groups, with a minimal number of files in each group. With a current configuration of 150+ file-groups the client was looking for a better management strategy, which aligned the number of file-groups with their Azure hardware. Clean up the file and file-group naming conventions and make recommendations on best practices. Over the years many developers have created new SQL file-groups, with no clear convention in mind, […]
 FMT Consultants, LLC.
Privacy Policy

Contact Us


Newsletter Sign-up

menu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram