SQL Server Tutorial
How to Set Up Every Day Database Auto Backup in SQL Server
In the world of database management, regular backups are crucial to safeguard against data loss or corruption. This article provides a step-by-step guide on how to set up daily SQL Server backups on a Windows system.
How to Rename a SQL Server Database
When working with SQL databases for quite a long period of time, you might come across a situation when you need to give your...
How to Automatically Commit SQL Server Database Schema Changes to the GIT Repository
Want to make git 'commit' automatically run every time a database schema is updated? Read more to find out how you can do this...
How to Debug a Stored Procedure with dbForge Studio for SQL Server
The article provides a detailed overview of the SQL Debugger functionality built into dbForge Studio for SQL Server, a powerful IDE for efficient database...
How to Search for Database Objects, Table Data, and Value in SQL Server
A SQL Server database includes plenty of objects – tables, views, stored procedures, functions, triggers, etc. With the increasing complexity of modern databases, it...
How to Build a Job to Import Multiple CSV files into a SQL Server Database
Have you ever faced the necessity to load data from multiple CSV files into multiple database tables? Not so uncommon, right? In this article,...
How to Connect to SQL Server Using SSMS, sqlcmd Utility, and dbForge Studio for SQL Server
In the article, we are going to provide a step-by-step guide on how to connect to SQL Server and execute SQL queries using the...
How to Create Login, User, and Grant Permissions in SQL Server
Read on how to create SQL Server user accounts and manage permissions using SSMS or dbForge Studio for SQL Server.
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 to reuse, manipulate, and access data later. For...
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 based on the four simplest data manipulation operations, which are called CRUD commands in SQL. This acronym stands for Create,...
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...
