I was recently reminded of differences in performance for different SQL Server persistence techniques. I had a set of data that was generated by my application needing to be merged into an existing relational database consisting of 8 tables. A root table with three dependent tables. Each dependent table had a one or two dependent tables. Level 1-1 Level 2-1 […]

I have been considering why many companies do not consider No-SQL or Document based storage systems for their applications. Instead they continue to churn out object to relational database mappings with lots of custom code in order to get adequate performance. One of my most recent experiences brought the reasoning to the surface. The individuals making the decision were quite […]

And so the world revolves again, the same script is being played over. The new version of the scenario is centered around all the new tools that are going to make software development easier. Last time we had Java, CORBA, Com, Visual Basic, Power Builder, Oracle Tools, Delphi, and many versions of C and 4GL tools all battling it out […]

Currently this is a big holiday season here in the United States. A big Part of this culture is the exchanging of gifts. Sales increase dramatically for a few weeks, and then drop back to normal levels. For Information Systems based on sales and the processing of sales loads also increase dramatically. If you’ve been around IT for long, you […]

Merging data change has been a common practice for a long time. Microsoft even created a full on Merge command allowing you to perform Insert/Update/ Delete data changes in a single command. What is interesting to me as a consultant is how often I come across web applications that have no concept of merging data. Applications are written passing sets […]

Do you want to speed up the performance of your Entity Framework project? Jonathan Magnan has an extention for Entity Framework doing precisely that. Check it out at http://zzzprojects.com/entity-framework-extensions/ What does it do? In short it reduces the number of round trips from your app server to the database server when executing you Create, Update, or Delete operations. The extension […]

Most database engines have some form of security built in. The security is designed to authenticate the client credentials and to grant or revoke rights against the database objects. Most engines have schemas owning database objects to which users are assigned. Encryption is sometimes included in the engine to product the database contents under different circumstances. Years ago I used […]

Do we really need to differentiate the type of object resulting in a dataset based on consumer usage? Most of the arguments I’ve heard for identifying the kind of object are based around the consumer, such as a reporting tool. Let’s consider tables and views first. The reason we put together views is so that the consumer does not need […]

Aaron shares a pragmatic approach to naming. Based on his response it would appear there is still a great value in how we name our objects. Aaron writes: I think the names we give to things that our applications are built around are really important because these things we created will/should be the language of our system and how we […]

Today I’m circling back around to an old conversation about naming conventions. I’m going to focus on SQL objects, but the concept still applies to any other application that names objects or variables. Over that last few months I’ve come across some interesting naming conventions for SQL Objects. Some are old school and others are new to me. For example, […]