2013-03-25
2,108 reads
Dwain Camps
Double Counting and Sign Reversals
Make the ad-hoc analysis of identifying potentially double-counted or sign-reversed Accounting transactions simple and painless.
2013-01-07
4,355 reads
Departures from Origins and Arrivals at Destinations
A suggested design for creating flight schedules makes querying easy. Includes basic airport and airlines data. Get started now with this tricky query problem.
2012-12-11
15,234 reads
2012-10-02
2,651 reads
Set Up Grouping Intervals for Excel (SQL Spackle)
So you want to group your data for charting in Excel? Here's how, the easy way!
2012-07-31
5,376 reads
2012-07-30
2,901 reads
Generating Non-uniform Random Numbers with SQL
Some FUNCTIONs to help generate non-uniform random numbers from uniform random numbers including Normal, Multinomial, etc.
2012-07-03
10,756 reads
Generating n-Tuples with SQL
An n-Tuple is a combination of values from rows of a table in pairs (2-Tuple) or triplets (3-Tuple), etc.
2012-05-17
12,915 reads
Financial Rounding of Allocations
When rounded detail quantities are created by an allocation, often the total must foot back exactly to the allocated amount.
2012-03-19
5,879 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers