ssms

Store and Share Static Data in Updated Source Control!

We are pleased to announce the release of the new version of our MS SSMS add-in for easy tracking and deployment of changes, dbForge Source Control for SQL Server, v2.0.  The updated version allows version-controlling static data, includes support for the latest SQL Server and Microsoft SQL Server Management Studio, and more. (more…)

Execution history in SQL Complete

dbForge SQL Complete includes the whole range of options that provide possibilities for powerful optimization and great performance increase. Execution history is an important part of this list. It is included into the Standard and Express edition package. The feature stores basic information about executed SQL statements for a certain period. (more…)

Keep going to improve productivity with dbForge SQL Complete

The Devart team brings together the interests of its clients and best usability practices in a new version of SQL Complete 6.0.  Read on to find out what useful features we have prepared for you in the new release. (more…)

Creating Linked Server in SSMS using ODBC

SQL Server Management Studio is an ideal environment for managing infrastructure of SQL Server database and SQL Server itself. With SSMS, you can easily connect to your SQL Server instance, configure and monitor database objects, as well as execute queries. Besides this, there is a possibility to create an ODBC connection to external data from SSMS.

(more…)

Possibility to connect to Azure Multi-Factor Authentication completed!

The new release of SQL Complete 5.9 brings simplicity to your SQL coding and provides an additional security approach to safeguard access to your data. Let’s take a closer look at what this release delivers. (more…)

Tidy SQL with SQL Complete

In this article, we will talk about how to keep SQL code clean and highly readable. We will also discuss how to stop suffering from messy and unformatted code. In addition, we will talk about how to force all team members to adhere generally accepted coding standards with no efforts. (more…)

SQL Server 2016 RC0

The news about Microsoft’s intention to “chum” SQL Server with Linux keeps floating around. But I haven’t heard a single word about SQL Server 2016 Release Candidate, that recently became available for download. (more…)

Find invalid objects in your databases

DBA has a number of duties that are primarily targeted at supporting of database performance capabilities and data consistency. The administrator can use the CHECKDB command to easily verify the data consistency; however, in case they need to find an invalid object in a database schema, some difficulties may occur.

(more…)

How to Build a Database from Source Control

There is no doubt that database developers can and should benefit from using source control systems. Regardless of the type of source control system, developers also must think over the development model. They must also consider how they wish to build and deploy databases from source control.

In this article, we will discuss several approaches of how to build databases form source control. (more…)

SQL Server Index Fragmentation In-depth

There is no way to avoid index fragmentation in any SQL Server environment. It does not depend on your SQL Server version or I/O subsystem you have, or your hardware. In this article, we will drill down into SQL Server index fragmentation issue. We will figure out why index fragmentation is a problem and how it affect on overall performance, discuss how to detect and avoid it. (more…)