| GENERAL |
| PRODUCT SPECIFIC |
|
ApexSQL News Product announcements, promotions, discussions, and other ApexSQL Tools news Product Update Alert - ApexSQL Edit 2008.11 A Medium Feature, Major Fix version of ApexSQL Edit 2008.11.0171 has been posted. Use the following link for downloading. Here are the complete release notes for the new version. Auto-updater will work on this version. Please note: in case of updating from ApexSQL Edit 2005 your settings will be lost. Make sure you backup your settings before as described here. In case of updating from ApexSQL Edit 2008 your settings will be kept and the application will be updated correctly. Labels: ApexSQL Edit ...Newsletter - August 2010 Click here for ApexSQL's August 2010 Newsletter. Labels: Newsletters ...ApexSQL Diff 2010 Released – New features, faster, and easier! CHAPEL HILL – July 26, 2010 – ApexSQL, a Microsoft Gold Certified Partner and leading provider of Microsoft SQL Server solutions, today announced the availability of ApexSQL Diff 2010. The new version includes support for native backups, huge performance improvements, usability improvements and many new features. ApexSQL 2010 includes the following new features and improvements. • New Data source: Native Database Backups • Improved performance - from 25-100% faster • Totally redesigned interface for improved usability • New visual object filter • Easier project management • Faster and easier synchronization Other new features • Support for encrypted objects for SQL Server 2005 and 2008 • Support for Team Foundation Server 2010 beta • Improved performance when handling large result sets • Tons of other usability improvements based on user community feedback "ApexSQL Diff 2010 is the culmination of several man years of combined R&D, usability testing, performance profiling and feature development," said Brian Lockwood, President and CEO of ApexSQL. "We have added tons of features, both large and small, but at the same time significantly improved the performance and ease of use of the software. We've received incredibly enthusiastic responses to pre-releases of this product underscoring the tremendous performance and value this new version offers our customers" Brian Lockwood, President and Co-Owner of ApexSQL "I have been using ApexSQL Diff and absolutely love it. Fantastic product well done." Ben Jackson Senior Developer Sage Technology For more information see our Detailed summary on the new features of ApexSQL Diff 2010 or visit the ApexSQL Diff Product Home. About ApexSQL ApexSQL is a leading vendor of tools for Microsoft SQL Server. ApexSQL products help SQL Server developers and DBAs accomplish complex tasks quickly, easily and accurately, including Database Auditing, Recover, Change Management, Development, Documentation and more. Headquartered in Chapel Hill, North Carolina, ApexSQL is a Microsoft Gold Partner and has over 8,000 customers in over 120 countries worldwide. Press contact: Dave Jeweek, +1 919.968.8444 x15, david.jeweek@apexsql.com Labels: ApexSQL Diff, Press Releases ...ApexSQL Refactor 2010.03 Released – Smart Rename, Move Schema and Improved Formatting ApexSQL is excited to announce the release of several new features for our SSMS add-in, ApexSQL Refactor. This upgrade will be free for all existing customers of with current Software Assurance plans. Here’s a quick summary of what is new. Smart Rename and Move Schema Refactoring Smart renaming of object, columns, and parameters is now available in ApexSQL Refactor, along with the ability to easily change the schema of objects. This set of Refactors implements name changes and automatically updates all referencing objects throughout the database.  Smart Rename Objects – Change the name or schema of tables, views, functions, and stored procedures. Smart Rename Columns – Rename columns within tables and views. Smart Rename Parameters – Rename parameters within functions and stored procedures. Remove Parameter Refactoring Also in the new release of ApexSQL Refactor is Remove Parameter refactoring, (previously released in ApexSQL Edit v2008.10). This feature allows users to easily remove parameters from stored procedures and functions, automatically updating all dependent objects.  Formatting Interface facelift We’ve given our formatting interface a major face lift including improved navigation, organization, visual help and formatting previews.  These additional features will complement our current set of refactors, which include: • Qualify Object Names – Add missing schema and data source name to object and column names. • Expand Wildcards – Replace * in SELECT * with explicit list of referenced columns. • Generate Client Code (i.e. C#, Java, VB.NET) – Translate scripts for use in client languages. • Encapsulate as Scalar Function – Extract scalar expressions into new scalar function and replace with function call. • Encapsulate as Inline Table-Valued Function – Extract queries into new table function and replace with function call. • Encapsulate as Stored Procedure – Create stored procedure based on selected code fragment and replace it with a procedure call.  Even more refactors coming soon! We are planning to release even more refactors soon including • Find Unused Variables and Parameters – Find and highlight all unused variables and parameters. • Add Surrogate Key – Generate surrogate key and add foreign key columns to linked tables. • Replace One-to-Many link with Associative Table – Automatically create associative table based on complex one-to-many links. • Encapsulate as View – Store queries as views for use in future scripts. • Expanded Formatting Options – Improved automatic script formatting features and controls. • Introduce Parameter – Add parameters to functions and procedures and automatically update all function or procedure calls. • Change Signature – Change order of parameters within functions and procedures and automatically update all function or procedure calls. Labels: ApexSQL Refactor ...Product Update Alert - ApexSQL Refactor 2010.03 A Medium Feature, Minor Fix version of ApexSQL Refactor 2010.03.0028 has been released. Use the following link for downloading. Here are the complete release notes for the new version. Labels: ApexSQL Refactor ...Coming soon in ApexSQL Edit - New refactors, decryption and sql error highlighting We are excited to announce several new features soon to be released in ApexSQL Edit. The new version is in final testing and should be released in July. This upgrade will be free for all existing customers of ApexSQL Edit 2008 under Software Assurance Smart Rename and Move Schema Refactoring Smart renaming of object, columns, and parameters will be available, along with the ability to easily change the schema of objects, while automatically updating all referencing objects throughout the database.  Smart Rename Objects – Change the name or schema of tables, views, functions, and stored procedures. Smart Rename Columns – Rename columns within tables and views. Smart Rename Parameters – Rename parameters within functions and stored procedures. Remove Parameter Refactoring This refactor will allow users to easily remove parameters from stored procedures and functions, automatically updating all dependent objects.  Inline Script Error Highlighting This feature will automatically detect and highlight more than 250 common syntax and semantic errors in real time.  Object Decryption for MSSQL 2005 and 2008 We’ve added support for decrypted objects in SQL Server 2005 and 2008 to allow them to be scripted, refactored etc just as easily as un-encrypted objects. Formatting Interface facelift We’ve given our formatting interface a major face lift including improved navigation, organization, and visual help and formatting previews.  These additional features will complement our current set of refactors, including: • Qualify Object Names – Add missing schema and data source name to object and column names. • Expand Wildcards – Replace * in SELECT * with explicit list of referenced columns. • Generate Client Code (i.e. C#, Java, VB.NET) – Translate scripts for use in client languages. • Encapsulate SQL into as Scalar Function – Extract scalar expressions into new scalar function and replace with function call. • Encapsulate as Inline Table-Valued Function – Extract queries into new table function and replace with function call. • Encapsulate as Stored Procedure – Create stored procedure based on selected code fragment and replace with procedure call.  Even more refactors coming soon! We are planning to release even more refactors soon including • Find Unused Variables and Parameters – Find and highlight all unused variables and parameters. • Add Surrogate Key – Generate surrogate key and add foreign key columns to linked tables. • Replace One-to-Many link with Associative Table – Automatically create associative table based on complex one-to-many links. • Encapsulate as View – Store queries as views for use in future scripts. • Expanded Formatting Options – Improved automatic script formatting features and controls. • Introduce Parameter – Add parameters to functions and procedures and automatically update all function or procedure calls. • Change Signature – Change order of parameters within functions and procedures and automatically update all function or procedure calls. • More formatting options – more than double the current set of formatting options to offer much more power and granularity. Labels: ApexSQL Edit ...ApexSQL Diff 2010 Pre-Release Preview After more than a year of development and internal testing, ApexSQL Diff 2010 is in the final phase of beta testing with select beta testers and VIPs. This new version has a completely new interface, great new features including the ability to compare against a native backup, improved performance and usability and much more. ETA for release is July, and will be a free upgrade for existing customers of ApexSQL Diff with active Software Assurance plans. Here’s a quick preview of what’s coming in the new release. Totally redesigned interface for improved usability The new state of the art, Office 2007 interface includes ribbon bar, Diff button, quick access toolbar and more.  Slice and Dice compared objects visually New object filter offers custom grouping and a powerful visual filter to build complex expressions quickly and easily  Manage projects easier • Open, Delete, Pin and Un-Pin all with a single mouse click • Filter by location or recently used through the same pick list control  Faster and easier synchronization • Lots of visual cues to make syncing easier including Visual progress indicators, Datasource information and sync direction • Many new ways to show information like grouping actions by execution order, object, or action type • More ways to sync a database including sync now, create script, update scripts folder, update source control  Cool New color schemes Who said comparing databases had to be boring?  New Datasource: Native Database Backups In addition to live databases, script folders, source control projects, and database snapshots, ApexSQL Diff 2010 will include the ability to use native backups as datasources.  Other new features • Seamless support for encrypted objects for SQL Server 2005 and 2008 • Support for Team Foundation Server 2010 beta • Quick and easy inline default handling. Set default preferences without leaving new project dialog. • Improved performance when handling large result sets • Tons of other usability improvements based on user community feedback • And much more … For more information see our detailed summary on the new features of ApexSQL Diff 2010. Labels: ApexSQL Diff ...Product Update Alert - ApexSQL Recover 2008.06 A Medium Fix version of ApexSQL Recover 2008.06.0838 has been posted. Use the following link for downloading. Here are the complete release notes for the new version. Auto-updater will work on this version. Labels: ApexSQL Recover ...Product Update Alert - ApexSQL Log 2008.06 A Medium Fix version of ApexSQL Log 2008.06.0838 has been posted. Use the following link for downloading. Here are the complete release notes for the new version. Auto-updater will work on this version. Labels: ApexSQL Log ...Product Update Alert - ApexSQL Refactor 2010.02 A Minor Fix version of ApexSQL Refactor 2010.02.0025 has been released. Use the following link for downloading. Here are the complete release notes for the new version. Labels: ApexSQL Refactor ...Product Update Alert - ApexSQL Debug 2008.05 A Minor Fix version of ApexSQL Debug 2008.05.0028 has been posted. Use the following link for downloading. Here are the complete release notes for the new version. Known Limitations: - x64 editions of SQL Server can't be debugged Labels: ApexSQL Debug ...Product Update Alert - ApexSQL Edit 2008.10 A Medium Feature, Major Fix version of ApexSQL Edit 2008.10.0169 has been posted. Use the following link for downloading. Here are the complete release notes for the new version. Auto-updater will work on this version. Please note: in case of updating from ApexSQL Edit 2005 your settings will be lost. Make sure you backup your settings before as described here. In case of updating from ApexSQL Edit 2008 your settings will be kept and the application will be updated correctly. Labels: ApexSQL Edit ...Product Update Alert - ApexSQL Diff API 2008.03 A Medium Feature, Medium Fix Release version of ApexSQL Diff API 2008.03.0013 has been posted. Use the following link for downloading. Here are the complete release notes for the new version. Changes: - Application evaluation period has been changed from 30 to 14 days - The following new datasources are now supported: Script Folder in Structure mode Source Control (Subversion, Microsoft Visual SourceSafe, Team Foundation Server, SourceGear Vault) in Structure mode Backup in Data mode Labels: ApexSQL Diff API ...Product Update Alert - ApexSQL Debug 2008.04 A Minor Fix version of ApexSQL Debug 2008.04.0027 has been posted. Use the following link for downloading. Effective this version, the evaluation period has been changed to 14 days. Here are the complete release notes for the new version. Auto-updater will work on this version. Known Limitations: - x64 editions of SQL Server can't be debugged Labels: ApexSQL Debug ...ApexSQL Refactor 2010: Out now! The first commercial version of ApexSQL Refactor 2010 has been released. Click here for more details on initial offer. Use the following link for downloading. Effective this version, the evaluation period has been changed to 14 days. Here are the complete release notes for the new version. Auto-updater will work on this version. Known Limitations: - This version cannot be run successfully on machines where ApexSQL Debug 2008.03 or lower is installed Labels: ApexSQL Refactor ...Product Update Alert - ApexSQL Log API 2008.05 A Medium Feature, Medium Fix version of ApexSQL Log API 2008.05.0834 has been posted. Use the following link for downloading. Effective this version, the evaluation period has been changed to 14 days. Here are the complete release notes for the new version. Auto-updater will work on this version. Labels: ApexSQL Log API ...Product Update Alert - ApexSQL Recover 2008.05 A Minor Feature, Medium Fix version of ApexSQL Recover 2008.05.0834 has been posted. Use the following link for downloading. Effective this version, the evaluation period has been changed to 14 days. Here are the complete release notes for the new version. Auto-updater will work on this version. Labels: ApexSQL Recover ...Product Update Alert - ApexSQL Log 2008.05 A Medium Feature, Medium Fix version of ApexSQL Log 2008.05.0834 has been posted. Use the following link for downloading. Effective this version, the evaluation period has been changed to 14 days. Here are the complete release notes for the new version. Auto-updater will work on this version. Labels: ApexSQL Log ...Newsletter - December 2009 Click here for ApexSQL's December 2009 Newsletter. Labels: Newsletters ...First commercial ApexSQL refactor version to be released - $99 initial offer ApexSQL Refactor 2010 will be available before the year ends. This will be ApexSQL Refactor's first commercial version. You can purchase this software for an introductory price of $99 (price will eventually be changed to $199). To take advantage of this introductory offer, enter INTROPRICE99 coupon code upon checkout. Purchase Orders will also be accepted. Apart from the formatting feature already available in the FREE version, ApexSQL Refactor 2010 also contains the following: 1. "Qualify Object Name" Refactor which fully qualifies all object names found in the SQL code 2. "Expand Wildcards" Refactor which replaces wildcards found in the SQL code with the actual object names 3. "Encapsulate As Scalar Inline Function" Refactor which encapsulates selected SQL code into scalar inline functions 4. "Encapsulate As Table Inline Function" Refactor which encapsulates selected SQL code into table inline function 5. "Encapsulate As Stored Procedure" Refactor which encapsulates selected SQL code into stored procedure 6. "Copy SQL Code As" Refactor which encapsulates SQL code into a customizable client code language syntax and copies it to clipboard Shortly after the initial 2010 release, we'll be adding the following refactors too: 7. Smart Rename columns - Renames columns in tables and views. 8. Smart Rename objects - Replaces all occurrences of old object name with new object name. This includes functions and procedures. 9. Smart Rename Parameters - Generates ALTER statement to modify function/procedure declaration and all other occurrences of the parameter to new parameter name. 10. Remove Parameters - Removes parameter from function and procedure declarations and calls. More will be added in subsequent versions; check out our Refactor Roadmap to see what's coming soon. Labels: ApexSQL Refactor ... |
