SQL Server Tools

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, as well as how to check SQL Server user permissions on the database using T-SQL and dbForge Studio for SQL Server.

(more…)

Don’t Miss the Latest Maintenance Update of SQL Complete 6.9

Here comes the maintenance update of dbForge SQL Complete, your favorite SSMS and Visual Studio add-in for context-sensitive code autocompletion, formatting, and refactoring.

(more…)

How to Automatically Track Database Schema Changes With PowerShell Scripts

In the article, you will find a detailed guide on how to automatically monitor a SQL Server database for schema changes and automatically create a report and log file. The examples of scripts to set up the process are provided.

(more…)

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 article. Here we tried to gather together different methods—any of them could turn out to be useful for your particular case. Without further ado, let’s get started!

(more…)

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 the SQL Server database.

(more…)

Relationships in SQL – Complete Guide With Examples

In this article, we are about to take a close look at the SQL Server relations, including one-to-one, many-to-many, and many-to-one relations, and get into details of creating those with the help of dbForge Studio for SQL Server.

(more…)

Review SQL Complete on GetApp!

Enjoying dbForge SQL Complete? Why not share your opinion in a review?

This would take just a few minutes of your time yet would be very important to us.

(more…)

Update Your dbForge Tools to Prevent Diagram Control Errors

If you are using any dbForge tools for SQL Server, MySQL, Oracle, and/or PostgreSQL, please make sure you have read this post.

(more…)

Software Development Life Cycle Tutorial with Examples

SDLC (Software Development Life Cycle) is a series of steps for developing, improving, and sustaining a software system. Learn more about the stages and best practices. 

(more…)

SQL Complete Keeps Extending SQL Prompting

We are happy to announce that the new version of dbForge SQL Complete has been released. We have been working on the implementation of the new features and fixing the faults in the existing ones to make your everyday working experience better. dbForge SQL Complete is a perfect solution for those database developers who treasure their time. With this add-in, you might actually feel that the application reads your mind and predicts your next step, taking away the painstaking work. The award-winning SQL Complete is available for Visual Studio and SSMS.

(more…)