This article shows a quick overview of ERD aka data model diagrams created by reverse engineering most commonly used SQL Server sample databases. The models are shown in different layouts and styles, using the reverse engineering capabilities of ApexSQL Model.
March 22, 2018ApexSQL Monitor 2018 R2 – Product update alert
ApexSQL Monitor 2018 R2 has been released
About ApexSQL Monitor: ApexSQL Monitor is a Windows and SQL Server monitoring tool with a wide range of monitored metrics. It tracks Windows, SQL Server, AlwaysOn Availability Group and Failover Cluster instances, and database metrics on multiple local and remote machines and SQL Server instances. It monitors the most important SQL Server statistics, memory, buffer, and page metrics – batch requests per second, user connections, target and total server memory, buffer cache hit ratio, batch requests, page life expectancy, page reads and writes per second, and more. ApexSQL Monitor also tracks SQL Server wait statistics including the individual query wait statistics. Monitoring these metrics enables you to identify and troubleshoot performance problems, establish trends, set baselines, and generate built-in or custom reports.
March 21, 2018What’s new in ApexSQL Developer: ApexSQL CI/CD toolkit Web dashboard
The ApexSQL CI/CD toolkit Web dashboard is a standalone web dashboard that allows quick set up, configuration and execution of CI/CD workflow pipelines initiated manually, on a schedule or on a commit.
March 20, 2018ApexSQL Source Control 2018 R3 – Product update alert
ApexSQL Source Control 2018 R3 has been released
About ApexSQL Source Control: ApexSQL Source Control is a SQL Server Management Studio add-in to version control SQL databases and objects. It integrates with all major source control systems and allows database developers to work together on a shared or a dedicated database copy. ApexSQL Source Control provides full object versioning features such as object locking with team policies management, detailed view of changes history, conflict resolution, labeling and more.
March 15, 2018ApexSQL BI Monitor 2018 R2 – Product update alert
ApexSQL BI Monitor 2018 R2 has been released
About ApexSQL BI Monitor: ApexSQL BI Monitor is an agentless SQL Server Analysis, Integration, Reporting services and Windows performance monitoring tool. It is designed for monitoring performance metrics in real-time with built-in performance metrics information and tuning advice. It tracks performance counter categories such as MDX, a storage engine for SQL Server analysis services (SSAS), the pipeline for SQL Server integration services (SSIS), and web and windows service categories for SQL Server reporting services (SSRS) including a drill-down ability with time slicing for detailed performance analytics. ApexSQL BI Monitor provides configurable real-time alerting and alert notifications. ApexSQL BI Monitor generates detailed reports with information about the monitored system and on collected metrics data with the highest impact on the monitored SQL Server services.
March 15, 2018ApexSQL Refactor 2018 – Screen shot tour
ApexSQL Refactor is a SSMS and Visual Studio add-in which formats and refactors SQL code and objects using 15 code refactors and over 200 formatting options; locates and highlights unused variables, qualifies objects and expands wildcards, encapsulates SQL into views, procedure, safely renames SQL database parameters and objects and splits SQL tables without breaking dependencies.
March 14, 2018ApexSQL VM Monitor 2018 R2 – Product update alert
ApexSQL VM Monitor 2018 R2 has been released
About ApexSQL VM Monitor: ApexSQL VM Monitor is an agentless virtualization monitoring tool that supports monitoring of Microsoft Hyper-V and VMware ESXi hypervisors. It tracks system performance metrics of monitored hypervisor hosts, host devices, and virtual machines. ApexSQL VM Monitor comes with the ability of real-time performance alerting based on predefined threshold values or established baselines. It is also able to generate detailed reports with information about the monitored hypervisors, virtual machines and their performance during specified periods of time.
March 9, 2018ApexSQL Plan 2018 R2 – Product update alert
ApexSQL Plan 2018 R2 has been released
About ApexSQL Plan: ApexSQL Plan is a SQL query analysis and optimization tool. It identifies performance issues and deadlocks, analyzes stored procedures, SQL Server query issues, and query execution plans, and helps you understand query performance characteristics.
March 8, 2018Microsoft SQL Server historical sample database diagram tour
This article presents an overview of graphical dependency diagrams generated from most commonly used SQL Server sample databases shown in different layouts and styles, using the dependency rendering capabilities ApexSQL Analyze.
March 7, 2018ApexSQL Build 2018 – Product update alert
ApexSQL Build 2018 has been released
About ApexSQL Build: ApexSQL Build is a SQL database deployment tool that builds new databases and updates existing ones by packaging SQL scripts, SQL script folders, database snapshots, and scripts under version control into a single deployment SQL script, a .NET solution, or an executable installer. It allows specifying the objects to be created or updated, ensures error-free deployment, and more.
February 27, 2018