ssms

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

Adventures of CLR Types in .Net Framework

Summary: This article describes the issue occurred with execution of the a polygon instance of the geography type and the possible solution for it.

Once I stumbled upon the following query:


DECLARE @g1 GEOGRAPHY;
SET @g1 = geography::Parse(‘POLYGON ((0 0, 1 0, -1 1, 2 2, 0 0))’);
SELECT @g1
go

(more…)

New version of add-in that can replace native Intellisense for SSMS is available!

When working on the new version of SQL Complete, we were focused on the idea of providing the most needed functionality to our users. Such course has already become the strategy of our product development. Our intention is not just to pack the product with features, but to give our users a tool that can make their work more effective. The result of this course was implementing more than a dozen of features and adding integration of SQL Complete with Visual Studio. We hope the integration will be useful for a wide range of prospective users. (more…)