Programs developed by ApexSQL Software |
|
|
|
|
ApexSQL Edit is a powerful IDE especially designed for advanced SQLServer developers including integration with source control, Intelliprompt, sql formatting, data editing and advanced features not found in other SQL IDEs like procedure/column Intelliprompt, Collapsing Regions, Snippet Editors and more.
ApexSQL Edit has been modified to provide many new features, including support for Microsoft SQL Server 2005, centralized mapping, Object Explorer, code snippets, object notes, context sensitive options while editing such as What Is...
|
|
ApexSQL Audit proves a comprehensive, enterprise level active data auditing tool for Microsoft
|
|
ApexSQL Script
|
|
Increase productivity - Reduce Errors - Standardize your Code Base - Automate repetitive coding tasks with Template Based Code Generation
|
|
ApexSQL Enforce is a revolutionary new solution for Industry Best Practices adherence and Custom Standards enforcement for SQL Server Databases. ApexSQL Enforce empowers users to create complex custom rules by leveraging the power of full programming languages like C# and VB.NET.
With ApexSQL Enforce, you can--
Ensure adherence to design standards in "real time"
Facilitate upgrades to new versions of SQL Server by identifying potential conversion problems before the database is ported
Automatically reverse or fix detected violations using generated "FixSQL" scripts
Enforce Naming conventions and ensure that SQL reversed words and special characters are not used.
|
|
Finding objects like stored procedures, views, and/or user-defined functions, or even columns that are not referenced (anymore) in either the database itself and/or the client code is a very tedious task, that almost no one I know likes to undertake. Even a medium-sized database can call for a lot of trouble and endless hours of work.
Well, sure, there is a build-in system table named sysdepends in SQL Server that is supposed to do exactly this job. But unfortunately, it is not very difficult to bring this table out of synch with reality. So, you cannot rely on the mechanisms SQL Server provides itself.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|