Author: Ben Taylor

Disruption
Editorials

Disruption

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 […]

Optimizing Group By Queries
Editorials

Optimizing Group By Queries

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 […]

Optimizing Entity Framework Queries
Editorials

Optimizing Entity Framework Queries

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 are Use Cases?
Editorials

Where are Use Cases?

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. […]

Improving Performance With Partitions
Editorials

Improving Performance With Partitions

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 […]

Federated Views
Editorials

Federated Views

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 […]

Editorials

INSTEAD OF Triggers

It’s happened again. That conundrum of expedience over longevity. The design for the immediate, the just get it done mentality, over building software using well proven design patterns that last. I was talking with a colleague who asked me what I thought about making a database change using a Materialized View and an Instead Of trigger to handle a simple […]

Editorials

Is Kotlin in Your Future?

I’ve been reading a lot of support growing for Kotlin, a language developed by Jet Brains. Kotlin is a statically typed language that compiles to run in many environments including using the JavaScript language and the Java Virtual Machine. On thing that sets Kotlin apart from other languages is that it generates code that can be run based on other […]

Editorials

Report Viewer With Objects

Today I was talking with a friend about the Report Viewer web control that ships with visual studio. The Report Viewer control is a multi-purpose tool for presenting RDL defined reports in a web site. What makes it really cool is the fact that it is truly multi purpose. Right out of the box it has some really cool features […]

Tool Selection – Can it be done?
Editorials

Tool Selection – Can it be done?

I remember the days when you could be a full stack developer only knowing a couple of software languages. Generally you had to know SQL and another language for the user application. Perhaps you were writing applications in Visual Basic, Power Builder, Oracle Forms ( I know I have left a lot of other tools out, because these were the […]