bclothier

About Ben Clothier

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

Detangling the new SQL Server ODBC and OLEDB drivers and what about Native Client?

Some of you may already know that Microsoft backtracked on their planned deprecation of OLEDB and provided a new OLEDB driver. However, it can be a headscratcher to figure what you should be using. When we were using SQL Server Native Client, it was pretty easy -- the Native Client had both OLEDB an [...]

Detangling the new SQL Server ODBC and OLEDB drivers and what about Native Client?2018-11-15T09:04:02+00:00

Designing a T-SQL trigger

On occasions when building a project involving an Access front-end and a SQL Server backend, we've run into this question. Should we use a trigger for something? Designing a SQL Server trigger for Access application may be a solution but only after careful considerations. Sometime this gets suggeste [...]

Designing a T-SQL trigger2018-06-18T23:47:49+00:00

Using large parameters for SQL stored procedure with DAO

As many of you already know, SQL Server team has announced deprecation of OLEDB for SQL Server database engine (Read: we can't use ADO because ADO uses OLEDB). Additionally, SQL Azure does not officially support ADO, though one still can get away with it using SQL Server Native Client. However, the [...]

Using large parameters for SQL stored procedure with DAO2017-06-22T23:53:06+00:00

Reporting more granularly than usual

Typically, when we do reporting, we usually do it at a higher granularity. For example, clients commonly wants a monthly report of sales. The database would store the individual sales as a single record, so it's no problem summing up the figures to the month each. Ditto with year, or even going from [...]

Reporting more granularly than usual2016-08-25T22:17:07+00:00

Ways To Do Sequential Numbering in Access

Occasionally we come across project requirements that include the ability to do sequential numbering in Access on a set of data. We cannot just use the auto-number data type because there is no promise of sequentiality but only uniqueness. In other words, if someone creates a record then later delet [...]

Ways To Do Sequential Numbering in Access2015-07-30T20:51:20+00:00

Creating Custom Access Formulas and Using Them Effectively

MS Access has a very powerful support for using expressions in your forms/reports’ controls. For example, showing a sum of some column can be as simple as putting down: [crayon-5c6a86aabf12a192989067/] and we’re done! Now, sometimes, we don’t have simple requirements. We might need to calculate a pe [...]

Creating Custom Access Formulas and Using Them Effectively2018-02-19T18:39:23+00:00

Replicating made simple: SQL Azure Data Sync

On May 13th, at 6:30 PM CST, I will be speaking about how you can easily create a solution that enable you to have your Access program working across broad geographic regions by leveraging SQL Azure Data Sync which is still in preview. In the talk, we will demonstrate how to get set up with replicat [...]

Replicating made simple: SQL Azure Data Sync2014-05-12T00:07:46+00:00

Running Transactions in a Stored Procedure

A lot of times, I write a stored procedure to do several things. More often than not, I might be doing mass inserts, updates or deletions. Now, I'm not your average suspenders-and-belt guy. No, I go one step further and insist on wearing an overall over my suspenders and my belt, thank you very much [...]

Running Transactions in a Stored Procedure2015-09-11T23:05:09+00:00

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+00: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+00:00
Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.