SQL Server
What Is Azure Data Studio and How to Get Started with It?
Azure Data Studio is one of the best-known and most popular solutions for database specialists who work with local and cloud platforms on Windows,...
Restore SQL Server Database Backup Using T-SQL Script and SSMS
The third article in the series about SQL Server backup and restore will take us through the database restore process and demonstrate the two...
Implementing a Scheduled Automatic SQL Server Backup Process
Now that we have reviewed the backup basics in the first article of our series dedicated to SQL Server backup, let’s proceed to the...
How to Set Up Extended Events in SQL Server
Extended Events is a helpful and convenient solution designed to monitor your system performance. First introduced in SQL Server 2008, it has become the...
How to Check SQL Server Query History
The data stored in the history of queries are among the most valuable for any DBA. Tracking back the SQL Server query history is...
How to Synchronize a Table in SQL Server
Database synchronization is an everyday necessity. You need it regularly when you have several similar databases that serve the same “user.”
The typical situation is,...
Azure Data Studio vs SSMS: Who’s the Winner?
For 15 years, SSMS has held the title of the top SQL Server database tool. That's no easy feat, especially in the software world,...
Continuous Delivery of Database Changes to SQL Server When Working Remotely
In the process of software product development that involves a database, one of the key points is the possibility of continuous delivery of changes...
Working with Multiple Branches in Source Control
With the help of dbForge Source Control tool that comes as an add-in for Microsoft SQL Server Management Studio and is included in...
SQL Unit Testing Stored Procedure with dbForge Unit Test for SQL Server
Unit testing is an essential component of the database DevOps process. Its primary goal is to test the constituent parts of the database objects...
Database Reverse Engineering
In our fast-changing world, observations of certain events, operations, and processes determine the development of business and implementation of any solutions or ideas. Such...
How to Export and Import SQL Server Database Data to a SQL Script
Data migration is a common challenge in the field of database development, management, and administration. This guide will illustrate the process of exporting database data to a .sql file and subsequently importing it into the target database.
Devart Joins the Winners’ Circle of 2020 DBTA Readers’ Choice Awards
For the second year in a row, readers of DBTA — a magazine focusing on data, information management, and analytics — choose Devart products...
Searching for Invalid Objects with SQL Complete
The present article deals with one of the bottlenecks in the work of database developers and administrators, namely the occurrence of invalid objects and...
Database DevOps Tools for Continuous Integration
Over the past few years, CI has come to be one of the best practices for software development. Indeed, it has numerous advantages: including...
How to Export and Import JSON Data Via dbForge Data Pump for SQL Server
In the previous articles, we studied the basic rules of SQL database design, created a database schema diagram for a recruitment service, and filled...
Find Invalid Objects in SQL Server Databases
In the course of time, we can experience situations when some certain database objects have not been distributed on one or several databases...
Pivot Tables and Reporting in SQL
Quite enough, there’s a need to change how data is displayed in a database so that the users could analyze it more easily. One...
Compare and Find Data Differences Between Two Tables in SQL Server with SSIS and dbForge Tools
Systems often work with distributed databases that contain distributed tables. Distribution is supported by various mechanisms, including replication. In this case, it is...
Is UNPIVOT the Best Way for Converting Columns into Rows?
To start, let's give definitions and highlight the difference between PIVOT and UNPIVOT operators in SQL Server.
The PIVOT and UNPIVOT relational operators are used...
Meet new Standard edition of SQL Tools
We are delighted to announce the release of the brand new Standard Edition of our SQL Server mega tool pack, dbForge SQL Tools.
Our principal...
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...
Export SQL Stored Procedure to a File and Generate Its Script
In previous articles, we have reviewed a general algorithm of finding and deleting incomplete open transactions in SQL Server databases, created a table for...
Find and Delete Incomplete Open Transactions in SQL Server – Part 3
In two previous articles, we have reviewed a solution for deleting incomplete open transactions in SQL Server.
By incomplete transaction, we shall basically understand an...
How to Create Custom SQL Server Replication for Read-only Databases
Quite often there’s a need to create a read-only replica of a SQL Server database. This might be required, for example, for the purpose...
Find and Delete Incomplete Open Transactions in SQL Server – Part 1
Frequently enough, MS SQL Server open transactions are incompleted and their initiators forget about them. This is quite a commonly encountered situation in routine...
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 on the basis of 4 simplest data
manipulation operations that are called by the acronym CRUD. This
acronym stands for Create, Read,...
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...
How To Generate and Fill a Doubly Linked List Table
Introduction
In this article, we’ll learn how to fill a doubly linked list table with SQL test data. In such tables, there can be various...
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...
Getting Real Currency Exchange Rates with SQL Server Data Generator
This article will demonstrate how to get live currency exchange rates with the help of Python and dbForge Data Generator for SQL Server.
The currency...
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...
Enabling AUTO_CLOSE Is a Bad Idea?
From a personal perspective, allowing a production database to run with AUTO_CLOSE option is not the best practice. Let me explain why you should...
What is faster inside SUM & AVG: 0 or NULL?
There are three aggregate functions that are most often used in practice: COUNT, SUM and AVG. The first one has already been discussed previously,...
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...
How to reduce MSDB size from 42Gb to 200Mb
Recently I've got a spare minute to see why an old test server was running too slow... I had nothing to do with this,...
