News  
  By product  

ApexSQL News

Product announcements, promotions and other ApexSQL news


Product update alert – ApexSQL Recover 2011 R2

ApexSQL Recover 2011 R2 has been released

Type: New version

About ApexSQL Recover: ApexSQL Recover is a recovery tool for SQL Server databases which recovers deleted, truncated, corrupted or damaged data. It objects and data lost due to drop operations an restores both deleted and online BLOBs as files making it ideal for SharePoint recoveries. For more information visit the ApexSQL Recover product page



About this release:
  • Supports recovery from natively compressed transaction log and database backups
  • Full Microsoft SQL Server 2012 support including recovery of FileTable schema and data
  • A new time filter which allows specifying the timeframe in which the incident had occurred for faster recovery
  • Support for additional SQL server data storage types including vardecimal and FILESTREAM
  • Additional support for direct-to-database recovery for:
    • Data lost due TRUNCATE and DROP operations
    • Tables with missing user defined data type definitions
    • Tables containing calculated columns
    • Tables with missing schema definitions
  • Improved usability - Easier server-side components installation
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Recover product page

Labels: ,

...


Product update alert – ApexSQL Log API 2011 R2

ApexSQL Log 2011 API R2 has been released

Type: New version

About ApexSQL Log API: ApexSQL Log API is an API which provides transaction log reading capabilities to your applications. It audits data and object changes that have affected your SQL Server database, including the ones that have occurred before the product was installed. It restores damaged or missing data and captures information on the user, application and host used to make each change. For more information visit the ApexSQL Log API product page



About this release:
  • Increased performance – up to 40% faster transaction log auditing
  • Undo and redo scripts can be created for DML changes
  • Supports auditing of natively compressed transaction log and database backups
  • Full Microsoft SQL Server 2012 support including auditing, replaying or undoing changes affecting:
    • FileTables
    • Sequences
    • Columnstore indexes
  • Improved usability - Easier server-side components installation
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Log API product page

Labels: ,

...


Product update alert – ApexSQL Log 2011 R2

ApexSQL Log 2011 R2 has been released

Type: New version

About ApexSQL Log: ApexSQL Log is an auditing and recovery tool for SQL Server databases which audits, reverts or replays data and object changes that have affected the database, including the ones that have occurred before the product was installed. It restores damaged or missing data and objects and captures information on the user, application and host used to make each change. For more information visit the ApexSQL Log product page



About this release:
  • Supports auditing of natively compressed transaction log and database backups
  • Full Microsoft SQL Server 2012 support including auditing, replaying or undoing changes affecting:
    • FileTables
    • Sequences
    • Columnstore indexes
  • A new visual results filter which allows filtering by:
    • the time when the change occurred
    • a specific DML or DDL operation
    • the objects affected by the change
    • the user, application and host used to make the change
    • the duration of the transaction
  • Improved scalability – up to 10 million operations can be displayed at once
  • Improved performance - operations are displayed immediately, without waiting for the auditing sources to be fully processed
  • Improved usability - Easier server-side components installation
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Log product page

Labels: ,

...


Product update alert – ApexSQL Edit 2011 R2

ApexSQL Edit 2011 R2 has been released

Type: New version

About ApexSQL Edit: ApexSQL Edit is an integrated SQL development environment providing auto-complete, source control integration, SQL code debugging, profiling, formatting and refactoring. It visualizes objects' interdependecies and allows visual SQL query building. For more information visit the ApexSQL Edit product page



About this release:
  • Performance improvements:
    • Auto-complete loads up to 50% faster
    • Up to five time faster database connectivity
    • Up to 8% faster syntax highlighting
  • Full SQL Server 2012 including support for:
    • Columnstore indexes
    • Geometry and geography auto grid tessellation scheme for spatial indexes
  • Additional auto-complete suggestions including:
    • Labels for GOTO statements
    • INFORMATION_SCHEMA schema, objects and columns
  • Automatic synchronization between live objects and their versioned scripts
  • Object search supports searching for system databases and objects
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Edit product page

Labels: ,

...


Product update alert - ApexSQL Diff 2011 R2

ApexSQL Diff 2011 R2 has been released

Type: New version

About ApexSQL Diff: ApexSQL Diff is a SQL Server database comparison and synchronization tool which detects differences between database objects and resolves them without errors. It generates comprehensive reports on the found differences and can automate the synchronization process between live and versioned databases, backups, snapshots and script folders. For more information visit the ApexSQL Diff product page



About this release:
  • Natively compressed SQL database backups can be used for comparison and synchronization
  • Full SQL Server 2012 support including comparing and synchronizing:
    • FileTables
    • Sequences
    • Search property lists
    • Columnstore indexes
    • Poison message handling attribute for queues
    • Geometry and geography auto grid tessellation scheme for spatial indexes
  • Usability improvements – faster comparison results browsing with the newly introduced Navigation bar
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Diff product page

Labels: ,

...


Product update alert - ApexSQL Data Diff 2011 R2

ApexSQL Data Diff 2011 R2 has been released

Type: New version

About ApexSQL Data Diff: ApexSQL Data Diff is a SQL Server database comparison and synchronization tool which detects data differences and resolves them without errors. It can compare and sync live databases and database backups and generates comprehensive reports on the detected differences. For more information, visit the ApexSQL Data Diff product page


About this release:
  • Natively compressed SQL database backups can be used for comparison and synchronization
  • Full SQL Server 2012 including comparing and synchronizing FileTable data
  • Support for additional SQL Server data storage types including FILESTREAM and SPARSE columns
  • Usability improvements on options and warnings
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Data Diff product page

Labels: ,

...


SQL Server 2012 support roadmap

All ApexSQL products offer support for Microsoft SQL Server 2012 R1
We wanted to make sure that enthusiasts and early adopters can take advantage of the
benefits the latest SQL Server version offers. Ever since SQL Server Denali CTP 1 was released, we worked hard to add support for the latest SQL Server version in parallel to its development. We updated our products for CTP1 and CTP3 shortly after their availability. This effort has culminated in our current level of SQL Server 2012 support that we offer today

SQL Server 2012 ready

We’ve implemented two levels of SQL Server 2012 support:
  1. Basic – The same level of support as for SQL Server 2008 R2 with new constructs for existing objects but without new objects for all data source types
  2. Advanced – Support for all new SQL Server 2012 objects, properties and enhancements including:
  • Contained databases
  • FileTables
  • Search property lists
  • Sequences
  • Columnstore indexes
  • Poison message handling attribute for queues
  • Geometry and Geography auto grid tessellation scheme for spatial indexes
  • User accounts created using Windows principal
  • User accounts created with passwords
  • New database properties
  • Encrypted object support
  • Support for SQL Server Integration Services 2012 packages
  • SQL Server 2012 Management Studio support and integration
All new products like ApexSQL Build and ApexSQL Restore will offer advanced SQL Server 2012 support right 'out of the box'

 Database administration

Basic Advanced
ApexSQL Log
ApexSQL Recover

 SQL development


ApexSQL Audit
ApexSQL Clean
ApexSQL Data Diff
ApexSQL Diff
ApexSQL Diff API Q2 2012
ApexSQL Doc Q2 2012
ApexSQL Edit
ApexSQL Script Q2 2012

 Add-ins


ApexSQL Complete
ApexSQL Profile
ApexSQL Refactor Q2 2012
ApexSQL Version Q2 2012

 Programmable APIs


ApexSQL Diff API Q2 2012
ApexSQL Log API

Labels:

...


ApexSQL Audit 2011 released – Improved performance, redesigned interface and SQL 2012 support

RALEIGH – May 8, 2012 - ApexSQL, a Microsoft Gold Certified Partner and leading provider of Microsoft SQL Server solutions, today announced the release of ApexSQL Audit 2011. The new version includes improved performance, SQL 2012 support, a redesigned interface and many new features

ApexSQL Audit 2011 includes the following new features:
  • Improved performance – up to 35% faster audit results exporting
  • Improved stability when working with more than 10, 000 auditing results
  • Support for Microsoft SQL Server 2012
  • Totally redesigned interface for improved usability

Other new features include:
  • Easier project management
  • Faster and easier audit report creation
  • Streamlined, descriptive options

For more information visit the ApexSQL Audit product page

“ApexSQL Audit 2011 can be a lifesaver when it comes down to quickly identifying who, when and how your application based data was changed. ApexSQL Audit 2011 represents a nearly complete overhaul of interface, engine and performance along with SQL 2012 support”
Brian Lockwood
President

"ApexSQL Audit has been a life saver for me. No longer can our business clients blame the system or my IT staff when errors appear in our data. Thanks to ApexSQL Audit, we can now track 'when' and 'who' made the change and if needed restore old data. ApexSQL Audit has paid for itself in its first week of use."
Andy Zecha
Director of Database Operations
HubX.net

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, recovery, change management, development, documentation and more. Headquartered in Raleigh, North Carolina, ApexSQL is a Microsoft Gold Certified Partner and has over 8,000 customers in over 120 countries worldwide

Labels: ,

...


Product update alert - ApexSQL Audit 2011

ApexSQL Audit 2011 has been released

Type: New version

About ApexSQL Audit: ApexSQL Audit is an auditing tool for SQL Server databases which captures the data changes that have occurred on the database including information on who made the change, which objects were affected by it, when was it made, as well as information on the SQL login, application and host used to make the change. It stores all captured information in a central repository and exports them in print friendly formats. For more information visit the ApexSQL Audit product page

About this release:
  • Improved performance – up to 35% faster audit results exporting
  • Improved stability when working with more than 10, 000 auditing results
  • Totally redesigned interface for improved usability
  • New data maintenance wizard
  • Easier project management
  • Faster and easier audit report creation
  • Streamlined, descriptive options
  • Support for Microsoft SQL Server 2012
  • ...and more

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Audit product page

Found a bug?
We encourage and reward evaluator feedback with our ApexSQL VIP and ApexSQL Top Gun programs.
Send an email to support@apexsql.com or post on the Support forum

Labels: ,

...


Product update alert - ApexSQL Version 2012 Beta

ApexSQL Version 2012 Beta has been released

Type: Beta

About ApexSQL Version: ApexSQL Version is SQL Server Management Studio add-in which allows you to version control SQL databases and objects directly from inside SSMS. It integrates with all major source control systems and provides you with all versioning benefits, without the need for an additional source control client. For more information visit the ApexSQL Version product page

About this release:
  • Supports SQL Server 2012 including:
    • SQL Server Management Studio 2102 integration
    • FileTable objects versioning
  • Live objects and their versioned scripts can be updated simultaneously or separately
  • Usability improvements including:
    • Intuitive default path for mapping configurations storage
    • Customizable layout of source control wizard
    • ...and more
  • Known issues from Alpha release are fixed

What are pre-releases?
These are betas/community technology previews that are released in advance of a major version. They give the community early access to the new technology and help to shake out any problems not uncovered in testing

Ready to try it?
Download it here

See also:
Release notes
Download
ApexSQL Version product page

Found a bug?
We encourage and reward evaluator feedback with our ApexSQL VIP and ApexSQL Top Gun programs.
Send an email to support@apexsql.com or post on the Support forum

About ApexSQL Version
ApexSQL Version is a SQL Server Management Studio add-in which incorporates SQL database version control capabilities into SSMS. ApexSQL Version easily integrates with all major source control systems and provides all versioning benefits

Labels: ,

...


Top guns for March 2012 announced

We’ve announced the Top gun for March 2012:

#1 Claude Hebert with 100 VIP points
#2 John Morrelles with 75 VIP points
#3 Jonathan Rhoads with 60 VIP points
#4 Fin Gold with 50 VIP points

Congratulations to all winners

How can I become a VIP?
We encourage and reward community feedback with our community programs

If you find bugs in our software, including pre-releases, or take the time to help other posters on our forum, you’ll be credited with points towards our VIP program that can earn gear (i.e. t-shirts), cash and VIP recognition.

Note: bounty in effect. Read more about it in New bug bounty on ApexSQL products - earn double and even triple VIP points by reporting bugs for selected products

Labels:

...


Formatting screen mockups and examples datasheet

We’ve posted mockups of our SQL formatting interface along with some before and after examples for popular options in a datasheet. Hopefully, this will provide a quick and convenient way to browse the nearly 200 formatting options

Click here for the datasheet

Here is an example screen mock-up and a few before and after examples



About ApexSQL Refactor
ApexSQL Refactor is a SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code, database tables and much more

About ApexSQL Edit
ApexSQL Edit is a SQL Server code editor with advanced SQL formatting, refactoring and autocomplete functions. Edit SQL using code snippets and templates in a single integrated environment.

Labels: ,

...


Press release - ApexSQL Profile 2012 released - SQL code performance profiling at the line level

Raleigh – March 26, 2012 - ApexSQL, a Microsoft Gold Certified Partner and leading provider of Microsoft SQL Server solutions, today announced the release of ApexSQL Profile 2012. This new SQL Server Management Studio add-in allows performance profiling of stored procedures and user defined functions at the line level and generates comprehensive reports containing statement execution times, variable and parameter changes and more

ApexSQL Profile 2012 includes the following new features:
  • Performance profiling of stored procedures and user defined functions
  • Visual, line-by-line SQL code profiling
  • Variable and parameter change history
  • Performance testing of default or custom parameter values
  • Comprehensive profiling reports exportable to Microsoft Excel and PDF
  • Performance profiling of encrypted objects
  • Support for SQL Server 2012, 2008 R2, 2008 and 2005

“With ApexSQL Profile 2012 you can really see how each line of your SQL code performs and easily detect potential bottlenecks at a glance. This is an essential tool for anyone tasked with writing high-performance SQL or performing tuning applications”
Brian Lockwood
President

"Can I tell you exactly how awesome this program is!"
Amanda Myers
Web Developer/Programmer
Pensacola Software

For more information visit the ApexSQL Profile product page

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, recovery, change management, development, documentation and more. Headquartered in Raleigh, North Carolina, ApexSQL is a Microsoft Gold Certified Partner and has over 8,000 customers in over 120 countries worldwide.

Labels: ,

...


Product update alert - ApexSQL Profile 2012

ApexSQL Profile 2012 has been released

Type: New product

About ApexSQL Profile: ApexSQL Profile is a SQL Server Management Studio add-in which allows performance profiling of stored procedures and user defined functions. It tracks SQL code performance at the line level and generates comprehensive reports containing statement execution times, variable and parameter changes and more. For more information visit the ApexSQL Profile product page

About this release:
  • Allows performance profiling of stored procedures and user defined functions
  • Identifies SQL code performance at the line level
  • Displays variable and parameter changes
  • Allows custom parameter values
  • Generates comprehensive profiling reports exportable to Microsoft Excel and PDF
  • Supports profiling of encrypted objects
  • Supports SQL Server 2012, 2008 R2, 2008 and 2005

Ready to try it?
Download it here

See also:
Release notes

Found a bug?
We encourage and reward your feedback with our ApexSQL VIP program.
Send an email to support@apexsql.com or post on the Support forum

Labels: ,

...


Product update alert - ApexSQL Refactor 2011

ApexSQL Refactor 2011 has been released

Type: New version


About this release:
  • SQL Server Management Studio 2012 RC0 support
  • SQL Server 2012 RC0 support
  • Known issues from the previous version are fixed

Ready to try it?

See also:

Found a bug?
We encourage and reward your feedback with our ApexSQL VIP program.
Send an email to support@apexsql.com or post on the Support forum

About ApexSQL Refactor
ApexSQL Refactor is a SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code, database tables and much more. It is a SQL Server Management Studio add-in which improves readability, consistency and standardization of the code. It formats and refactors the code using 10 code refactors and over 160 customizable formatting options. For more information visit the ApexSQL Refactor product page

Labels: ,

...


Top guns for February 2012 announced

We’ve announced the Top gun for February 2012:

#1 Claude Hebert with 145 VIP points
#2 Jonathan Rhoads with 75 VIP points
#3 Karla Woltman with 60 VIP points
#4 Ulises Reyes with 60 VIP points
#5 John Morrelles with 55 VIP points

Congratulations to all winners

How can I become a VIP?
We encourage and reward community feedback with our community programs

If you find bugs in our software, including pre-releases, or take the time to help other posters on our forum, you’ll be credited with points towards our VIP program that can earn gear (i.e. t-shirts), cash and VIP recognition.

Note: bounty in effect. Read more about it in New bug bounty on ApexSQL products - earn double and even triple VIP points by reporting bugs for selected products

Labels:

...


Product update alert - ApexSQL Complete 2011 Beta

ApexSQL Complete 2011 Beta has been released

Type: Beta

About ApexSQL Complete: ApexSQL Complete is SQL Server Management Studio add-in (soon to be available for Visual Studio) which speeds up coding. It completes SQL code statements automatically, fills in SQL code fragments and much more. For more information visit ApexSQL Complete product home

About this release:
  • Known issues from Alpha release are fixed

What are pre-releases?
These are betas/community technology previews that are released in advance of a major version. They give the community early access to the new technology and help to shake out any problems not uncovered in testing

Ready to try it?
Download it here

See also:
Release notes
ApexSQL Complete product home

Found a bug?
We encourage and reward evaluator feedback with our ApexSQL VIP program.
Send an email to support@apexsql.com or post on the Support forum

About ApexSQL Complete
ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in which speeds up coding, completes SQL codestatements automatically, inserts code blocks, identifies unused parameters and variables and much more

Labels: ,

...


New bug bounty on ApexSQL products - earn double and even triple VIP points by reporting bugs for selected products

Report bugs for ApexSQL Complete, ApexSQL Version, ApexSQL Data Diff, ApexSQL Diff and ApexSQL Log and get more VIP points. For more information check our VIP program page

What?
Report bugs, get VIP points and win prizes! If you encounter a bug in any of our products send an email to our support team at support@apexsql.com
Bugs found in next products are rewarded with double VIP points:
  • ApexSQL Complete
  • ApexSQL Version
  • ApexSQL Data Diff
  • ApexSQL Diff

and bugs found in ApexSQL Log are rewarded with triple VIP points!

For how long?
Until we release our next maintenance releases of these products.

How?
We’ll be offering internal builds and direct access to our team to help verify fixes, reproduce bugs and help VIPs in any way we can.

Download the newest versions of these tools and report any bugs you find! We look forward to your feedback!

Labels:

...


We are happy to announce our St. Patrick's day special: 20% off on ApexSQL Universal Studio

Save $500 on ApexSQL Universal Studio with 2 year subscription (Premium support & Free upgrades)!

Get all ApexSQL products together, plus our upcoming products and save $500 by purchasing ApexSQL Universal Studio by March 17, 2012



**Click here to purchase directly online and receive your activation keys immediately!**

For more information on this offer contact our sales team at sales@apexsql.com

Labels:

...


Press release - ApexSQL Refactor 2011 released - SQL 2012 support and formatting options improvements

Raleigh – March 9, 2012 - ApexSQL, a Microsoft Gold Certified Partner and leading provider of Microsoft SQL Server solutions, today announced the release of ApexSQL Refactor 2011. The new version features SQL Server 2012 support and includes many other improvements


ApexSQL Refactor 2011 includes the following new features and improvements:
  • Support for SQL Server Management Studio 2012
  • Support for SQL Server 2012
  • Improved usability for recursive functions and procedures
  • Enhanced formatting options

“With ApexSQL Refactor 2011 you can refactor your code in latest SQL Server, with great speed and error-free”
Brian Lockwood
President

"The Refactor is a great help, and I'm glad to have found something that works well and is easy![sic]"
Michael Jenkins
Programmer/Analyst
International Mission Board

For more information visit the ApexSQL Refactor product page

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, recovery, change management, development, documentation and more. Headquartered in Raleigh, North Carolina, ApexSQL is a Microsoft Gold Certified Partner and has over 8,000 customers in over 120 countries worldwide.

About ApexSQL Refactor
ApexSQL Refactor is a SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code, database tables and much more

Labels: ,

...


Sneak Peek - ApexSQL Build 2011 – Database building, updating and deployment made easy

ApexSQL Build builds and updates databases directly from individual or multiple scripts, snapshots or source control. It streamlines the database deployment process by simultaneously executing upgrades on multiple databases. Databases and database updates can be packed into a script, C# project and/or .NET executable file for remote deployment. ApexSQL Build can consolidate multiple scripts into a single script and/or any of the other previously mentioned formats.



Here is a quick look at the ApexSQL Build features:

Pack databases from different sources
Create deployment packages directly from SQL scripts, script folders, database snapshots or source control



Update databases without errors
Ensure that updates are propagated without errors using proprietary dependency analysis algorithms that ensures proper execution order



Create databases builds in different formats
Package the database build as an executable, a C# project or a single SQL script



Build and update databases from source control
Connect to a source control repository, point to a project or label, and build all of the files into a deployable medium (script, .NET executable or C# project)



Customize deployment options
Specify the deployed database properties



Update more than one database simultaneously
Apply changes to multiple databases in a single step



Choose objects to include in the build
Specify which objects will be included in the deployment package



Review changes before execution
Check deployment impact prior to its execution including warning levels and messages



Add additional scripts to the deployment process
Augment your deployment with custom scripts that will be run on the successfully deployed database



Consolidate multiple scripts into a single script or package for error-free execution
Parse and refactor the execution-order of all objects in one or more scripts then combine them to a single, executable SQL script, C# project file or .NET executable while ensuring error-free execution



Support for SQL Server 2012, 2008 R2, 2008, 2005 and 2000
Full support for SQL Server 2012, 2008 R2, 2008, 2005, and 2000 objects and enhancements

Labels: ,

...