In this article we’ll describe how to improve T-SQL code layout and presentation using various features and options in ApexSQL Complete. We’ll examine the Code structure feature, how ApexSQL Complete highlights identifiers with brackets, how it manages closing characters, aliases, and column list.
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.
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.
In this article, we’ll introduce a feature in ApexSQL Complete that keeps track of executed queries. ApexSQL Complete is a productivity add-in for SSMS and Visual Studio, that features SQL auto-complete, SQL formatting, and more.
In this article we will describe the snippets feature in ApexSQL Complete and give examples of using snippets macro variables.
ApexSQL Doc features a built-in graphical dependencies viewer that can assist you in visually conveying your database dependencies in the final document.
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.
ApexSQL Doc is a SQL documentation tool that allows documenting of SQL Server Integration Service (SSIS) packages and multiple SQL databases, 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.
No matter how well managed your systems are, accidents may still occur, and potentially lead to disastrous consequences. In order to ensure that there is a disaster recovery solution available, it is always good to have a standby copy of a primary database on another SQL Server instance.
The first way to achieve this is to utilize the SQL Server Log shipping.
Even a superficial reading of books and articles on SQL Server performance monitoring will tell you that SQL Server memory pressure is the first thing you should monitor. Not the only thing, far from it, and some CPU, I/O and internal SQL Server counters are critically important to get the complete picture but it’s the memory counters that often show us the first indication of suboptimal performance