SQL Server Tutorial
How to Export SQL Server Data to an Excel File
If you are in search of the optimal way to export data from SQL Server to Excel spreadsheets, look no further. Just check this...
Understanding a SQL Schema
The article describes the basics of a database schema, the advantages of using schemas, and covers how to create, modify, and delete them in a SQL Server database.
How to Automatically Synchronize Multiple Databases on Different SQL Server Instances
In this article, we share a step-by-step guide on how to compare the schema and data of multiple SQL Server databases from the command...
How to Write Complex Queries in SQL Server
One of the regular jobs performed by a database administrator and developer is creating and executing queries of higher complexity to resolve complicated tasks....
Recovering Accidentally Deleted Data with dbForge Transaction Log
Read on about how to recover deleted files using redo and undo scripts generated with the help of dbForge Transaction Log. In addition, the article covers some basics of ACID properties in transactions and best practices for rollback operations.
How to Set Up Version Control of Your SQL Server Database from Scratch
Version-controlling SQL Server databases in GitHub has never been easier with Devart solutions. You can commit and revert changes, view and resolve conflicts, track...
How to Use SQL Server DBCC SHOW_STATISTICS
Database statistics are a powerful weapon. They store a vast array of information about the database data that helps identify slow-running queries and allows...
How to Create Customizable CRUD Operations with SQL Complete
Working with SQL databases and tables usually implies performing daily data-related tasks using the CRUD operations in order to re-use, manipulate, and access data...
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...
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 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,...
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...
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.
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...
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...
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,...
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...
