Finding parameters and SQL variables that are only defined in the existing SQL Server stored procedures and functions, but never actually used, is not a problem, but for maintaining complex code, with dozens of parameters and variables you’ll need a tool like ApexSQL Refactor – a free SQL Server Management Studio and Visual Studio add-in, and useful SQL query formatter
March 9, 2015How to create DDL and DML SQL scripts for specific SQL database objects only
ApexSQL Script is a SQL Server database migration tool which can create SQL scripts by converting SQL database objects and data into a single or multiple deployment SQL scripts, .NET solutions, or executable installers. In many cases when moving a SQL database, there’s no need to migrate the entire SQL database, but only a part of it.
March 5, 2015How to improve SQL code layout and presentation
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.
March 4, 2015How to preview SQL Server code structure and control flow
In this article, we’ll introduce the Code structure feature in ApexSQL Complete. ApexSQL Complete is a productivity add-in for SSMS and Visual Studio, that features SQL auto-complete, SQL formatting, and more. The Code structure feature allows the user to easily view and find all important code blocks, and to review the SQL code structure of the query.
March 4, 2015How to export a SQL database directly to source control
SQL database scripting tool ApexSQL Script natively integrates with the Subversion, Microsoft Visual SourceSafe, Git, SourceGear Vault, and Team Foundation Server source control systems.
ApexSQL Script allows to export complete SQL database, or just a couple of its objects, to one of the mentioned source control systems.
March 4, 2015How to track executed SQL Server queries
In this article, a feature in ApexSQL Complete that keeps track of executed queries will be introduced. ApexSQL Complete is a productivity add-in for SSMS and Visual Studio, that features SQL auto-complete, SQL formatting, and more.
March 4, 2015How to create and use T-SQL code snippets
In this article, the snippets feature in ApexSQL Complete will be described along with examples of using snippets macro variables.
March 4, 2015How to create SQL Server documentation showing database dependencies visually
ApexSQL Doc features a built-in graphical dependencies viewer that can assist you in visually conveying your database dependencies in the final document.
March 4, 2015How to document a SQL Server database with extended properties
ApexSQL Doc, a SQL Server documentation tool, displays descriptions for SQL database objects using the extended properties that are stored in the SQL Server database. The Extended property editor feature allows you to add or edit your database object descriptions using the extended properties that are stored in your SQL Server database.
March 4, 2015Documenting SSIS packages
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 well as properties and expressions used for each component.
March 4, 2015
