How To

SQL Server Table Variables Overview

In the article, we are going to explore the basics of SQL Server table variables, compare local temporary table vs global temporary vs table variable, and examine a query execution plan performed with dbForge Studio for SQL Server.

(more…)

Automated Database Deployment and Releases with Jenkins and dbForge

Introduction into CI process

The modern software development process is impossible without constant improvement. There will be multiple builds for each change, and it is only an accomplished build tested in its entirety that can be pushed to production.

(more…)

Create Full SQL Server Database Backup with dbForge Studio for SQL Server

The backup process is an important link in the chain of successful database administration and robust data protection. In this article, we are going to apply a comprehensive solution from dbForge Studio for SQL Server that allows quick and efficient database backup and restore.

(more…)

How to Install 15 dbForge SQL Tools in 15 Minutes Using Chocolatey

Getting prepared for work need not take long, no matter whether you deal with physical or digital tools. Undoubtedly, there are better things to spend time on than make your way through a dozen wizards, however simple and convenient they might be. And if you are a SQL database developer or administrator, we can give you a quick example and equip you with a set of 15 top-notch tools in next to no time with even less effort.

(more…)

Introduction to SQL Server Temporary Tables

We all need to refer to temporary tables quite often. They are necessary to deal with interim aggregations or outputting intermediate results. However, it is also essential to delete temporary tables after using them. 

In this article, we’ll examine the basics of temporary tables and define how they differ from table variables. Then, we’ll learn how to delete temporary tables correctly, and we’ll create a stored procedure for deleting temporary tables in a current session.

(more…)

How to View MySQL Server Log Files

Sooner or later, every developer and DBA faces the necessity to find out the reasons for slow database performance. This article will take a detailed look at how to set up MySQL Server logging, what types of MySQL Server logs exist, and how to work with them.

(more…)

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, macOS, and Linux. This product is a lightweight modern environment for SQL code development with numerous embedded features. Its goal is to simplify the users’ daily tasks and continually improve their professional experience.

(more…)

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 main principles of database restore available in Microsoft.

(more…)

Using dbForge Studio for Oracle to Automate Oracle Database Deployment

When raising issues related to increasing performance and improving Oracle database reliability and integrity while developing and deploying databases, the real value lies in automating the process and managing changes securely.

(more…)

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 implementation and automation of the SQL Server backup process.

(more…)