Thursday, November 20, 2008
We wish DeWitt and the Jim Gray Systems Lab great success!
Wednesday, November 12, 2008
- Support for SQL Server 2008
- Support for Sybase SQL Anywhere 10.0 and up
- Adds a “choose objects” page in the GUI where you can specify what object types you want to document.
- Support for all DBMS platforms in the "exclude objects" GUI. Previously this GUI supported only SQL Server.
- Support for arbitrary HTML in database comments – see /pt command line switch.
- Analysis Server: support for XML comments in MDX scripts. This enables documentation of calculated members.
- Support for cross database and cross server dependencies (through linked servers)
- Support for column dependencies (which columns of which table a stored procedure selects or updates.
- SQL Server: support for XML comments on objects that don't have their DDL stored on the server, such as tables. This is implemented with extended properties.SQL Server: add extended properties filter. Using this you can restrict by name the extended properties that are fetched by xSQL Documenter.
xSQL Documenter generates compiled CHM and html database documentation for virtually all DBMS platforms including SQL Server, DB2, Oracle, MySQL etc.
You can read more about xSQL Documenter and download your copy from: http://www.xsql.com/products/database_documenter/
Wednesday, November 5, 2008
- when you define a custom comparison key for a table in xSQL Data Compare the database schema (structure) is not affected - no changes are made to the schema;
- the custom comparison key can include multiple columns from the table in question;
- the key must be unique - that is the combination of the values of the columns included in the key should uniquely identify a row in that table.
- the comparison key defined on one of the tables in the comparison should match the comparison key defined on the other table - the rows from both tables in the comparison are paired based on the key values.
Tuesday, November 4, 2008
And remember your mail-in ballot must be received by the county election officials before the polls close otherwise your vote won't count. So, don't drop the ballot at the post office today - you are too late - instead, hand-deliver it to any precinct in your county (the one where you are registered to vote).
Monday, November 3, 2008
A survey conducted by SQL Server Magazine showed that about 81 percent of the participants are still on SQL Server 2000 and only about 40 percent are using SQL Server 2005. I am willing to bet that one year from now over 50% of those same people will be already using SQL Server 2008 - there are just too many cool and very useful features in SQL Server 2008 that make it really hard to pass.
All xSQL Software tools support SQL Server 2008.