Fix SQL syntax errors and typos using ApexSQL Complete
Auditing Features Comparison: ApexSQL Log vs. ApexSQL Comply These two tools differ in many aspects. It’s up to you to decide which one suits your needs best
ApexSQL Audit has a variety of interface features to allow viewing and trigger management managing of existing triggers
The main feature of ApexSQL Audit is generation of triggers that capture and store data changes due to INSERT, UPDATE, and DELETE statements.
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 […]
It takes far less time for ApexSQL Log 2013 to read data sources and show them in the grid, due to significantly improved performance
A free SQL code complete add-in that helps you define shortcuts consisting of a few characters that will be replaced by larger SQL code fragments.
ApexSQL Build’s custom post-deployment SQL scripts allow augmentation and customization of the deployment process with additional custom script
Whenever building a SQL Server database, it must determine which objects to include in it. ApexSQL Build provides a detailed object analysis for building a database or for a database update deployment, with an ability to customize the SQL database objects and include dependent objects automatically. Selecting objects is easy and allows to easily customize […]
In this article will be explained how to customize SQL databases documentation using ApexSQL Doc. Documentation for MySQL databases can be customized in the same way, explained in this article, but using ApexSQL Doc for MySQL. Using the default settings and options when documenting a SQL database via ApexSQL Doc and ApexSQL Doc for MySQL does not […]
In a SQL database lifecycle two major deployment tasks are: the building of a new SQL database and an upgrade of the existing one. ApexSQL Diff is a SQL database comparison tool that can help for both of them; it allows deploying SQL scripts saved in a script folder to a new or an existing […]
A SQL Server database can have stored procedures, tables, defaults, views etc. that aren’t being used anymore, and unless you determine which of your objects are truly unreferenced you will be stuck with them, or risk breaking your database if you delete a wrong object
ApexSQL Doc is a SQL documentation tool that allows documenting of SQL Server Integration Service (SSIS) packages, Analysis Service databases (SSAS), multiple SQL databases, Tablau sites and SharePoint farms easily and automatically. ApexSQL Doc allows you to quickly develop a summary of your SSIS Packages. It can visually display the control and data flow as […]
Easily reattach previously used virtual SQL databases at any time, making it very useful in large-scale testing and development environments
In this article, improving of T-SQL code layout and presentation using various features and options in ApexSQL Complete will be described. Additionally, the Code structure feature will be examined, how ApexSQL Complete highlights identifiers with brackets, how it manages closing characters, aliases, and column list. The Code structure feature The Code structure displays the internal […]
It is not a rare case that a DBA inherits SQL Server databases with many unused SQL objects. By using ApexSQL Clean, it is easy to clean a SQL database from these unneeded objects and prevent extra objects from making an impact on development by slowing it down and increasing the maintenance workload (e.g. all […]
Choosing a primary key is one of the most important steps in a database design. There are two types of a primary key – a natural key and a surrogate key. In this article it will be described how to apply database refactoring on a SQL Server database and replace a natural key with a […]
Applies to ApexSQL Doc and ApexSQL Doc for MySQL Summary This article explains how to speed up the SQL database documentation process using ApexSQL Doc and ApexSQL Doc for MySQL. Description Some features of ApexSQL Doc and ApexSQL Doc for MySQL, are time-consuming but may be optional for some situations. Those documenting options are grouped […]
ApexSQL Clean can help determine all dependencies in a SQL database; it also analyzes the impact of potential changes and deletions on SQL database, and determines object interrelationships within the database, between different databases, SQL scripts and even applications When trying to remove SQL Server database objects, which have objects that depends on it, there […]
A SQL Server has multiple instance-level settings and objects, depending on the version. These can have a significant effect on SQL Server’s behavior and performance, and it is important to keep track of their configuration or even document them, for that matter. ApexSQL Doc, as an efficient SQL Server documenting tool, offers the possibility to […]
