Thursday, January 16, 2020

Basic T-SQL Cursor syntax

›
I'm always looking for the basic syntax to create a cursor. I do it rarely, as is proper for SQL Server, so I have to remind myself of t...
Friday, October 12, 2018

Checking for the Existence of Database Objects for Idempotent Code

›
I am constantly having to search for the best way to determine if a certain kind of database object exists because there is no one way that ...
Wednesday, December 6, 2017

Displaying a button in a DevExpress DataGrid cell

›
This post is a perfect example of the primary purpose of this blog: to document obscure and difficult-to-remember steps to accomplish tasks ...
4 comments:
Tuesday, December 5, 2017

Using Two List Boxes to Manage Key Word Tags (or Similar Values)

›
Recently I started using OutSystems as a web development tool because Microsoft decided to abandon Access Web Apps and replace it with a n...
5 comments:
Wednesday, March 30, 2016

Geocoding on the Cheap (i.e. Free)

›
It has been a long time since I've been so excited about sharing a database technique on my blog as I am about this one. Geocoding enabl...
Monday, March 7, 2016

Using an Operational DB Key as a "Fact" in Factless Fact Tables

›
As most of the readers of this blog know from other communication sources, I recently moved from Shelby Systems, Inc. to Custom Data System...
1 comment:
Wednesday, September 25, 2013

A First Glance at Prepared Queries or, as I think of them, "Temporary Stored Procedures"

›
Since my last post I have taken a new position as DBA / Business Intelligence Developer at Shelby Systems, Inc. In my new role I am still do...
2 comments: