Blog

DBX 10.1.7 Released

Changes in this version: - added explicit identification of SQL2008 (would previously fail with 'unsupported version') - fixed stylesheet references when printing tabs While I don't have an available SQL2008 instance to test against, to the best of my knowledge...

read more

CF-style List functions in SQL Server

The built-in string handling functions in t-sql are all well and good, but there really aren’t any graceful ways of handling lists. As any CF developer that’s been around a while knows, lists are pretty commonplace in practice, and there are times when it makes more sense (or you’re required) to do list handling at the db level rather than at the front end.

read more

DBX 10.1.6 Released

Nathan Strutz pointed out a bug where DBX would not run from a site running on a port other than 80. This stemmed from a cross-site scripting fix added in v10.1.3 which did not consider the port. This has been resolved. Other changes in this version: - added print...

read more

DBX 10.1.5 Released

I didn't post for the 10.1.4 release, so here are the changes for that: 10.1.4: - More complete table DDL output - fixed bugs in table DDL In the 10.1.5 version, a Data Sample tab was added for tables and views which simply outputs the TOP X rows for the item (I was...

read more

DBX 10.1.3 Released

Under certain deployment conditions, specifically using hosts file entries and resolving a server which may have multiple IPs/sites configured on it, the relative path references to JS and CSS files can create a cross-site scripting condition which prevents the...

read more

DBX 10.1.2 Released

Right on the heels of the 10.1.1 release, the 10.1.2 version adds DDL create script output for tables, views, sp's and udf's. The DDL functionality previously existed for all objects except tables (via the View Schema button in detail view), but the new version adds...

read more

DBX 10.1.1 Released

Added a bit of code to attempt to handle errors generated after using DBX at least once (and having cookies set) and then changing the value DBX uses to encrypt cookie data (yielding invalid results). Easiest solution is simply to delete all cookies, close the...

read more

DBX 10.0.8 Released

Been sitting on a few changes for a while, hence the leapfrogging on the version. New in this version is the Tuning Console, a SQL2K5-specific feature which is essentially a set of DMV's I find useful for performance debugging. Using the Tuning Console (specifically,...

read more