20Sep 2013 by Grant Fritchey 4 Comments

Web Design & Azure

Azure
I've listened to tons of programmers and DBAs complain about the look of Windows Azure. But, I'm friends with several design people, work with some pretty darned good designers at Red Gate, and I live in sin with a graphic artist (AKA: Mrs. Scary). While the developers and DBAs complain, lots of the designers seem pretty happy with it. Microsoft has a pretty serious team working on it. You can see an interview with them that tells you a little bit about how they did it. I thought it was interesting. And don't forget, that little contest to win a car ends in just over a week. This is almost your last chance to connect your MSDN account to a zero-cost Azure account and enter for a chance. Or not.…
Read More
21Mar 2008 by Grant Fritchey No Comments

Top vs. Max

T-SQL
The company I work for has a very well defined need for versioned data. In a lot of instances, we don't do updates, we do inserts. That means that you have to have mechanisms for storing the data that enables you to pull out the latest version of all the data or a particular version of all the data, or the data at a particular moment in time, regardless of version.  That means maintaining a version table and a series of inserts into various tables. Some tables will have pretty much a new row for each version, some tables may only have one or two versions out of a chain. With the help of a very smart Microsoft consultant, Bill Sulcius, we have a mechanism that works very well. However,…
Read More