As mentioned in ApexSQL Edit vs. ApexSQL Search features, ApexSQL Edit is a complex SQL development environment equipped with numerous features to deal with source control integration, SQL debugging, profiling, formatting, refactoring, and auto-complete
April 5, 2013ApexSQL Edit refactoring feature vs. SQL refactoring add-in
ApexSQL Refactor is a free SQL formatting add-in for SQL Server Management Studio and Visual Studio derived from the ApexSQL Edit’s refactoring feature but further optimized and improved. Among other things it offers full SQL Server 2012 support, meaning that FileTable refactoring is now fully supported, which was not the case with ApexSQL Edit
April 4, 2013ApexSQL Edit SQL performance profiling vs. ApexSQL Profile add-in
ApexSQL Profile is another SSMS add-in evolved from the ApexSQL Edit’s feature that can profile stored procedures and/or functions, in order to fine-tune them and pinpoint their bottlenecks
Even though the basic functionality is the same, the ApexSQL Profile add-in is additionally refined and better optimized which improves its accuracy and efficiency. It is now possible to performance profile SQL within SQL Server Management Studio, identify inefficient SQL at a glance, analyze SQL performance at the line level and even track variable and parameter history
April 3, 2013ApexSQL Edit version control vs. SQL Server database version control add-in
ApexSQL Source Control, derived directly from the ApexSQL Edit’s Source control integration feature, is an SSMS and VS add-in that can source control SQL Server databases from SSMS. They share the same functionality, but the newer ApexSQL Source Control add-in has an improved and better-optimized engine that makes it more reliable. Unlike ApexSQL Edit, ApexSQL Source Control fully supports SQL Server 2012 objects and has significantly improved performance (up to 300% faster in some cases)
April 1, 2013ApexSQL Complete vs. SSMS – Part 2 – Auto-complete DDL and DML statements
ApexSQL Complete is a free add-in that integrates into Visual Studio and SQL Server Management Studio. One of the key functionalities of the add-in is the auto-complete SQL feature. Auto-complete fills in SQL keywords as well as database, schema, object, parameter and variable names automatically.
In this article, we will examine some additional features, like in the previous article, of ApexSQL Complete vs. SSMS and see how they compare.
March 26, 2013ApexSQL Complete vs. SSMS – Part 1 – Object recognition
ApexSQL Complete is a free add-in that integrates into all current Visual Studio and SQL Server versions. It allows faster coding by completing SQL statements automatically, fills in SQL fragments, generates outlines for the SQL script structure, speeds up coding with snippets, and much more.
One of the key functionalities of ApexSQL Complete is its auto-complete feature. Auto-complete fills in SQL keywords as well as database, schema, object, parameter and variable names automatically. Additionally, it completes entire SQL fragments, such as JOIN statements or cross-database queries, in a single click.
March 25, 2013ApexSQL Edit vs. Add-ins – Part 2: Visual database dependencies
Another feature ApexSQL Search has inherited from ApexSQL Edit is the possibility to visualize all SQL objects’ dependencies. This includes relationships between encrypted objects, system objects, SQL 2012 objects or objects stored in databases encrypted with Transparent Data Encryption (TDE). However, even though both ApexSQL Search and ApexSQL Edit have similar features that can be used to visualize dependencies, the capabilities of ApexSQL Search surpass the original feature set in ApexSQL Edit
March 22, 2013Visual Studio 2012 support, batch formatting and profile saving: ApexSQL Refactor 2013 released
Raleigh – March 20, 2013 – ApexSQL, a Microsoft Gold Certified Partner and major provider of Microsoft SQL Server solutions, today announced the release of ApexSQL Refactor 2013. The new version of our SQL formatter supports Visual Studio 2012, features SQL script and script folder batch formatting and also introduces formatting profile saving and sharing.
March 20, 2013ApexSQL Data Diff has gone PRO
We’ve now released two versions of ApexSQL Data Diff – Developer and Professional
What’s the difference?
ApexSQL Data Diff Professional has the following additional features:
- Support for native or natively compressed database backups
- Pre and post-synchronization scripts
- Command Line Interface (CLI)
Visual Studio 2012 support, extended properties visual editing and automatic query editor tab renaming: ApexSQL Search 2013 released
Raleigh – March 20, 2013 – ApexSQL, a Microsoft Gold Certified Partner and major provider of Microsoft SQL Server solutions, today announced the release of ApexSQL Search 2013. This new version of the FREE add-in Supports Visual Studio 2012; introduces visual editing of SQL objects’ extended properties; and automatically renames multiple opened query editor tabs to reflect their contents
March 20, 2013
