Thursday, September 28, 2023

SQL Server Tutorial

Automating Bulk Data Import from MS Access to SQL Server

In the article, you'll learn how to automate the bulk data import from MS Access to SQL Server using dbForge Data Pump and PowerShell command-line.

Understanding Pull Requests, Merge Requests, and dbForge Source Control for SQL Server

Read on to learn the difference between merge and pull requests and explore how to version-control SQL Server databases using dbForge Source Control.

Create and Connect to an Azure SQL Database on Heroku: A Step-By-Step Guide

In today's digital landscape characterized by rapid technological advancements and a multitude of innovative solutions, the seamless integration of diverse platforms is paramount for efficient application development. This guide delves into the process of creating and connecting an Azure SQL Database on the Heroku platform, offering step-by-step instructions and insights to help you bridge the gap between two powerful cloud services.

How to Use OPENQUERY in SQL Server

We are thrilled to share the exciting news that our dbForge tools now support SQL OPENQUERY, a powerful feature introduced in SQL Server 2022. With this integration, our users can take full advantage of this feature's capabilities, enabling seamless execution of queries on remote data sources directly from our tools.

Mastering IF THEN Logic in SQL Server

Exploring the advanced usage of IF-THEN statements and understanding how dbForge Studio SQL Server aids in handling these tasks will be the main focus of this article.

Complete Guide to SQL Server Concatenation

In this article, we will explore the fundamentals of SQL Server concatenation, delve into different techniques for concatenating strings, and uncover advanced concepts that can take your string manipulation capabilities to the next level.

Overcoming the Challenges of SQL Server Version Upgrades and Downgrades With dbForge Compare Bundle

Navigating the process of SQL Server version upgrades and downgrades can be a daunting task, often accompanied by various challenges and complexities. However, with the assistance of the dbForge Compare Bundle, businesses can overcome these hurdles and streamline the upgrade process.

CREATE TABLE in SQL Server – Guide With Examples

Creating a table is the core of the database design and one of the fundamental skills for all database professionals. This article will review default methods of creating tables on Microsoft's SQL Server.

How GPT Chat Can Help You Generate CRUD Procedures for SQL Server Tables

In today's technological landscape, artificial intelligence has carved a significant niche for itself, offering unparalleled assistance in numerous domains. One such domain is database development, where the AI model, such as ChatGPT, has been gaining increasing recognition.

How to Use ChatGPT to Write SQL JOIN Queries

SQL JOINs are a fundamental aspect of relational database management and allow for the retrieval of data from multiple tables based on a specified condition. With the advent of advanced language models like OpenAI's GPT, it is now possible to leverage their capabilities to write SQL JOIN queries most efficiently.

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 Install SQL Server on Linux (Ubuntu)

It may be news to many database developers and administrators that SQL Server actually performs better on Linux. In this article we will go...

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

Create ER Diagram for SQL Server Database Using SSMS and SQL Designer

Entity Relationship Diagrams are widely used for analyzing database structure and troubleshooting issues with logic or deployment. In this article, we provide a detailed...

How To Export SQL Server Data From Table To a CSV File

In this article, we are going to export a table from SQL Server to a .csv file using four different tools. Besides, you will...

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

SQL Query Optimization: How to Tune Performance of SQL Queries

In the article, we are going to examine how to optimize SQL queries and improve query performance by using SQL query optimization tips and...

How to Create Login, User, and Grant Permissions in SQL Server

In the article, we are going to examine how to create a new user account and grant/revoke permissions and roles on a database object,...

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

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

How to Rollback Committed Transactions on MS SQL Server

The MS SQL Server database management system suggests that all changes are carried out via transactions. Transactions are created to ensure the ACID requirements: A...

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

We quite often face the task of migrating database directory data. And the database for a recruitment service, which we created in the previous...

SQL Database Design Basics with Examples

It is a common practice that a DB architect has to design a relational database tailored to a particular solution. One Friday evening, I was...

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

Social

Products