SQL Server

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...

Linking and Comparing SQL Server and PostgreSQL Databases

In this article, we will describe how to link a PostgreSQL Database to SQL Server, compare and deploy the PostgreSQL data against SQL Server...

How to automatically synchronize data in two SQL Server databases on a schedule

Data in SQL databases often needs to be synchronized in real time – this can be achieved by checking one database for updates and...

Welcome to the Future of SQL Database Development!

We are thrilled to announce the most notable addition to our dbForge for SQL Server product line in years, dbForge DevOps Automation for SQL...

Devart sponsored SQLSaturday 857 in Kyiv, Ukraine

SQLSaturday is one of the largest free-to-attend IT events in Ukraine, and Devart was its Gold Sponsor this time. We had a lot of new...

SQL Server 2016 Stretch Database

On June 1, SQL Server 2016 was released. It brought a large number of novelties into normal development, including the long-announced Stretch Database technology...

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...

Backup and Restore Databases in SQL Server

In this article, we will talk about the benefits of backing up SQL Server databases, different backup types, and backup strategies. The immediate purpose of...

SQL Server 2016 CTP3.1 – What’s New for Developer?

Not that long ago, I remember Microsoft's CEO Satya Nadella has been announcing a new version of SQL Server 2016. And all of a...

SQL Server Typical Maintenance Plans: Automated Database Backups

There are a lot of posts appealing to one simple truth – need perform backups on a regular basis. People will always be divided...

SQL Server Index Fragmentation In-depth

In this article, we will drill down into the SQL Server index fragmentation issue and how to tackle it. We will figure out why index fragmentation is a problem and how it affects overall performance and discuss how to detect and avoid it.

Generate Meaningful Test Data with Data Generator for SQL Server

Why is meaningful test data important? While developing an application, you need to make sure you are testing it under conditions that closely simulate a...

SQL Complete Enhanced Functionality

While working on the new version of SQL Complete, we focused on adding the most needed features discussed on Devart's uservoice site – devart.uservoice.com....

Capturing SQL Server Trace Data

One of the best ways to gather information about SQL Server workloads is to capture trace information. In this article, we will look at...

Connecting to SQL Server from Android and iOS in Direct Mode Using SDAC

Using SDAC in Direct Mode for access to SQL Server from iOS and Android platforms doesn’t significantly differ from the one on Mac OS...

Analyzing SQL Server Events with help of Events Profiler

dbForge Studio for SQL Server provides the SQL Events Profiler tool that captures SQL Server events from a server. The events are stored in...

SQL Server Typical Maintenance Plans – Part 1: Automated Index Defragmentation

It's incorrect to consider a database as a stable unit, since various kinds of undesirable situations can appear over time — database performance degradation,...

dbForge Studio for SQL Server is Ready for Work!

Devart proudly presents dbForge Studio for SQL Server — a new set of SQL Server tools for database developers and administrators. All users who have...

SQL Complete is ready for SQL Server 2012 now!

Devart Team is glad to announce the new release of SQL Complete v3.5. It includes support of all versions and editions of SQL Server,...

SQL Complete extends its functionality

Devart Team is glad to announce the new release of SQL Complete v3.1. The new version includes some improvements in both Standard and free...

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....

Moving Database Objects from One Schema to Different Schemas

Database development is not limited to an initial copy of a database. On your road you meet multiple enhancements, refactoring, upgrade and many other...

Enjoy Creating Complex Queries with SQL Query Builder!

Devart development team is glad to present dbForge Query Builder for SQL Server, a modern and affordable tool that will bring you confidence in...

Dare Compare Your SQL Data Much Faster!

We compared some best-of-breed SQL data comparison tools with dbForge Data Compare for SQL Server to find out which one is faster to compare...

Meet Performance-Leading SQL Comparison Tool

Devart announced the release of a new version of the professional tool for SQL server data comparison and synchronization - dbForge Data Compare 2.00....

Ensuring Quality of dbForge Schema Compare for SQL Server, v 2.0

The most important characteristic of any software is its quality. The quality, according to the model specified in the ISO 9126 standard, consists of...

Backup Comparison and Database Versioning Added in Schema Compare for SQL Server

Schema Compare for SQL Server 2.00 compares schema snapshots, database backups, and database changes in version control systems to accelerate the work of advanced...

How to Migrate Databases of Different SQL Server Versions

Need to move databases from SQL Server 2000 to SQL Server 2005 - 2008 or vice versa? dbForge Schema Compare for SQL Server can successfully...

Bulletproof database synchronization with dbForge Schema Compare for SQL Server v1.50

Devart, a vendor of native connectivity solutions and database development tools for Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite databases, has announced...

What’s New in dbForge Schema Compare for SQL Server v1.10

Devart has released today the improved version 1.10 of dbForge Schema Compare for SQL Server, a sophisticated tool specially designed to meet your specific...

Coming Soon: dbForge Schema Compare for SQL Server v1.10

After analyzing our users' feedback on the first release of dbForge Schema Compare for SQL Server. We decided to change our roadmap for this...

New product: dbForge Data Compare for SQL Server!

Introduction Devart Company has launched a new product line for working with SQL Server databases. Recently we have released a beta version of the first...

Social

Products