Currently Browsing: SQL

Geometry data type support

LINQ to SQL and Entity Framework don’t support the geometry data type… boo…
read more

Great OR/M resources

Today I had a conversation with a co-worker that started with my declaration of not wanting to ever have to code a stored procedure. Adamantly I know that there are places where sprocs are the solution to a problem but in today’s landscape I feel those are edge cases. Our argument..err..I mean conversation had all the usual discussion points. co-worker points: sprocs are faster sprocs are more secure sprocs provide a layer in n-tier My points: the dollar cost of milliseconds of speed true see comments; but all queries should be parameterized hence not a valid argument. an unnecessary abstraction...
read more

ASP.NET MVC SiteMap

Note: This code does not support caching or security trimming. It is simply a way to build something that compares to the .NET TreeView control using the MVC pattern. Recently one of my clients had the "perfect storm" of requirements, restrictions, deadlines and policies that lead to the need to develop a MVC TreeView(ish) control.   Requirements: Database storage – Site administrations needed a simple interface into editing and I was not about to write something to update XML files. NOT use the SQL Service Broker for easy SQL caching support – Security concerns….I...
read more

Content Segregation is a bad idea

In the past, when building small web applications with up to a couple concurrent users, I’ve placed the database on the same system as the web server. Blasphemy!!!…not really. You see, knowing that database systems will entirely consume their allocated memory allows for clear capacity planning. There are many factors that need to be taken into consideration when designing an architecture and for the sake of this post lets just say that: This system does not require a ridiculous amount of memory This system does not require HA And really, while every project sponsor will tell you that their...
read more