SQL Server
Enjoy Continuous Integration in TeamCity with dbForge DevOps Automation
We are thrilled to inform our users of dbForge DevOps Automation for SQL Server that we have extended the range of supported automation systems...
How to Generate and Use CRUD Stored Procedures in SQL Server
Most database systems operate based on the four simplest data manipulation operations, which are called CRUD commands in SQL. This acronym stands for Create,...
Pimp the database diffs management with new dbForge Studio for SQL Server v5.8
We are glad to announce that we have just rolled out the new dbForge Studio for SQL Server, v5.8. This version features massive improvements...
Performing audit changes and rollback transactions is now simpler than ever
There is an old joke that goes something like this: “There are two types of system administrators – those who don’t back up their...
Devart sponsored SQLSaturday Kharkiv 2019
For the past decade, Devart has been actively supporting SQL Saturday events including this year's conference in Kharkiv, Ukraine. As usual, Devart was a...
Devart sponsored SQL Saturday Lviv 2019
We are delighted to inform you that Devart was a Gold sponsor of the SQL Saturday Lviv 2019 event that took place on September 21 in...
A New Look of Differences in Compare Bundle!
We are thrilled to announce a huge update of our SQL Server comparison tool pack, dbForge Compare Bundle for SQL Server. The new versions...
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...
Automatic Schema Comparison Log Delivery via Email
In this article, we will show how to set up automatic email delivery of the log file when a comparison of multiple SQL schemas...
How to quickly generate documentation for your SQL Server database
In this blog post, we will learn how to quickly create a comprehensive documentation of an SQL Server database using SQL documentation tool from...
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...
Generating Related Data Elements with SQL Data Generator
Recently we got an interesting question from our user:
The docs don't address directly, but how can we generate three related data elements,...
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...
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...
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....
Improving Performance for Parsing UNION Clause in SQL Complete
Devart's prompt SQL tool can help SQL Server developers and DBAs to write SQL smoothly, with code-completion. SQL Complete works with current and older databases, thanks to backwards compatibility.
SQL Complete: Parsing performance improved!
SQL Complete allows developers to use IntelliSense when they write SQL queries in SQL Server Management Studio. The tool will tell you the exact formatting you should use for your SQL commands while you are writing them and will therefore help you write fast, perfectly formatted SQL statements.
How To Create SQL Query in One Shot
In this article we describe how to quickly design a MySQL query visually using a special GUI tool - Query Builder.
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....
Synchronizing SQL data between a company database and a data warehouse
Recently we've received a question from one of our customers asking how to synchronize data between companies servers and a data warehouse server. Let's...
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...
Table data verification for safe schema synchronization
Preserving data in tables after synchronization is one of requirements for successful schema synchronization. dbForge Schema Compare for SQL Server offers two mechanisms of...
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...
