ssms

How to Search for Database Objects and Table Data in SQL Server

Hello and welcome to the fourth part of our series of articles that will help you discover how to design and work with databases. This time we are going to delve into an intricate matter of data and object search in SQL Server, which will be further conducted first with the help of standard scripts and after that, using the dbForge Search tool.

(more…)

Find invalid objects in your databases

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

(more…)

New version of dbForge Source Control for SQL Server released

We are excited to announce that a new version of the SSMS add-in for SQL Server database change management, dbForge Source Control for SQL Server, v2.1, has been just rolled out!

(more…)

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…)