Geeks With Blogs

A Picture of Me

David Turner, MCPD
MCPD - Enterprise Applications 3.5

David Turner, MCTS
Windows Forms Applications 3.5
ASP.NET Applications 3.5
WCF Applications 3.5
ADO.NET Applications 3.5
Administering TFS 2010

View David Turner's profile on LinkedIn

MCP Virtual Business Card
View my MCP Profile

David Turner blog January 2011 Entries
SQL Constraints – CHECK and NOCHECK

One performance issue i faced at a recent project was with the way that our constraints were being managed, we were using Subsonic as our ORM, and it has a useful tool for generating your ORM code called SubStage – once configured, you can regenerate your DAL code easily based on your database schema, and it can even be integrated into your build as a pre-build event if you want to do this. SubStage also offers the useful feature of being able to generate DDL scripts for your entire database, a

Posted On Monday, January 31, 2011 5:12 PM

SQL Server Express Profiler

During a recent project, while waiting for our Development Database to be provisioned on the clients corporate SQL Server Environment (these things can sometimes take weeks or months to be setup), we began our initial development against a local instance on SQL Server Express, just as an interim measure until the Development database was live. This was going just fine, until we found that we needed to do some profiling to understand a problem we were having with the performance of our ORM ge

Posted On Monday, January 31, 2011 3:43 PM

Copyright © David Turner | Powered by: