Today I was introduced to a library new to me that has been out there for more than 6 years. LinqJs is a library bringing Linq styled syntax to the JavaScript world. At the core, what Linq does for you is to remove all of the iteration logic from your visible code so that the things that you are intending […]

Again I am going to delay providing my optimized group by example using Entity Framework. The reason for the delay is that I want to fully implement the framework behind my example so I can prove out my understanding of the code that I write, and the code it generates when calling the database. So, today I want to drop […]

Today I am supposed to be demonstrating how to do aggregation efficiently through the use of Linq syntax. I am unable to complete that editorial today as promised, so am going to take a moment to share a little bit of personal conflict that applies to us all at some time or another. I’ve been writing software for more than […]

Today I want to talk about a common issue where we want to get a distinct list from a parent table, having a filtered value from a child table that may have many records. Here’s an example to explain the scenario, and it’s one that happens quite often. Let’s say you want to get a list of regions. For each […]

One of the cool features of Entity Framework is the ability to execute queries against multiple tables in a single round trip. It does this by combining all of the attributes from each table into a single result set. This works really well until you start joining to related tables with more than one record. When you think of an […]

Where have use cases gone when it comes to documenting software? I’ve been given all kinds of requirements, many from templates with all kinds of things for analysts to complete. However, I haven’t seen a Use Case in years. A use case is very simple, yet provides some very valuable information. It defines a business process your system must implement. […]

We’ve been talking about optimizing a database when it has a lot of data, at least from an indirect standpoint. What starting me on the topic was the use of an INSTAEAD OF trigger for something other than improving performance. INSTEAD OF triggers were designed to allow a DBA to spread data from a single large table across multiple tables […]

Today I want to review the concept of the INSTEAD OF trigger, and the original reason it was added to SQL Server. When earlier versions of SQL Server were continuing to be adopted by bigger and bigger data sets it would sometimes degrade in performance as the number of records increased. We started getting millions, billions, and even trillions of […]