bclothier

About Ben Clothier

This author has not yet filled in any details.
So far Ben Clothier has created 40 blog entries.

Working with XML Data Efficiently – Part Two

This is part two of our two-part series on working with XML data with a SQL Server backend. Part one can be found here. In part one, we showed how much simpler and effective it was to manipulate XML data by doing it directly in the SQL Server layer as opposed to front-end or middle-layer code. The i [...]

Working with XML Data Efficiently – Part Two2016-04-02T00:00:23-05:00

Working with XML Data Efficiently – Part One

This is part one of a two-part series that discusses working with XML data with an SQL Server backend. Part two is discussed here. I've personally found XML files to be something of a bugbear. They're going to require some kind of transformation to get it in a format that's useful for importing or e [...]

Working with XML Data Efficiently – Part One2016-04-02T00:25:45-05:00

Delay Loading Subforms in Access Part 1

In part one, Juan talked about the sequence of events fired when loading a form with a number of subforms in Access and how one can reduce the cascading effects of events being refired due to operations performed during the load. We will talk about how we can delay loading the subforms. By putting o [...]

Delay Loading Subforms in Access Part 12014-11-11T03:01:27-06:00

Easily update all tables that have the same field name

We talked about concatenating multiple records into a single string using FOR XML PATH and we also talked about EXISTS clause. Here's a practical example that incorporates both. In one of our projects, we have an archive database that contains historical data of select tables from the production dat [...]

Easily update all tables that have the same field name2013-11-05T20:12:38-06:00

Easily create a Beta environment in SQL Server

We are specialists in creating Access to the cloud solutions using SQL Server. We therefore maintain a number of databases and our clients are constantly asking us for improvements. Of course, we require that those go through a full cycle of testing and deployment: We copy an existing database using [...]

Easily create a Beta environment in SQL Server2013-10-14T20:12:28-05:00

Whether to exists or not exists, that is the question…

This is second part of 2-part series on SQL clauses. Juan covered the IN() in the first part. We now turn to a close sibling, EXISTS clause. As Juan demonstrated, IN() can be useful for some situations where we want to match a subset of another table without necessarily changing the output due to jo [...]

Whether to exists or not exists, that is the question…2018-02-19T18:36:01-06:00

Mixed Blessings of SQL Triggers

Sometime we take over a project where the original developer used SQL Triggers on the tables and unfortunately, we tend to find that more often, the triggers are not written in most effective manner. I'd like to highlight few common mistakes I see made with using the triggers: Assuming only one row [...]

Mixed Blessings of SQL Triggers2013-09-10T00:45:07-05:00

Automation and Web

Whenever the subject of new web apps introduced with 2013 or web databases introduced with 2010, one common lamentation bought up by people is that they both lack VBA. It is certainly an understandable lamentation; almost all serious Access developers have used VBA and it's VBA that makes it possibl [...]

Automation and Web2013-09-10T00:45:52-05:00

New Access 2013 book, plus meet the authors!

Over the last year, I've been working on a book with Access experts and MVPs Teresa Hennig, George Hepworth and Doug Yudovich, focused on practical examples and techniques for building powerful Access applications. The book covers both new web apps and new solutions to client solutions. Here are few [...]

New Access 2013 book, plus meet the authors!2013-08-23T20:06:53-05:00

Getting a list in comma delimited format with T-SQL

Sometime we want to get data in a list. A good example is getting a list of orders that's coming up for delivery and has other orders that are past due. We would like to know what those upcoming orders are so we can ensure that the past due accounts are settled prior to actually delivering the order [...]

Getting a list in comma delimited format with T-SQL2014-10-22T02:23:57-05:00

Maximizing Code Reuse: Writing design-time automation

This is part two of two-parts on maximizing code reuse. Part one focused on assigning more than one event handlers to same object's event or sharing an event handler for several objects. We now turn to looking at how we can write design-time automation to help us save time in coding. If you enjoy lo [...]

Maximizing Code Reuse: Writing design-time automation2013-06-14T19:31:29-05:00