studio for sql server
Creating Stored Procedure for Dropping Local Temporary Tables in SQL Server
Evgeniy Gribkov
Latest posts by Evgeniy Gribkov (see all)
- Creating Stored Procedure for Dropping Local Temporary Tables in SQL Server - June 16, 2021
- Dedicated Link Source Control Repository - May 6, 2021
- Database Version Control Using Source Control for SQL Server - May 5, 2021
In this final part of the three-part article series, we will review creating a script, wrap it in a stored procedure, and will use it for deleting all local temp tables and one particular local temporary table.
(more…)dbForge Studio for SQL Server Has Been Awarded G2 High Performer Spring 2021
Latest posts by dbForge Team (see all)
- dbForge Product Line Is Ready for Windows 11 - October 12, 2021
- Connect to PostgreSQL Database Using psql, pgAdmin, and PostgreSQL Client Tool - October 7, 2021
- SQL Complete Keeps Extending SQL Prompting - October 5, 2021
dbForge Studio for SQL Server is an all-encompassing IDE, designed for efficient development, management, and administration of SQL Server databases. It comprises a set of tools that accelerate and automate a number of related tasks, including data and schema comparison, analysis, and reporting. Today we add another valuable entry to the list of its achievements – the G2 High Performer Spring 2021 award.
(more…)Working with Multiple Branches in Source Control
Latest posts by dbForge Team (see all)
- dbForge Product Line Is Ready for Windows 11 - October 12, 2021
- Connect to PostgreSQL Database Using psql, pgAdmin, and PostgreSQL Client Tool - October 7, 2021
- SQL Complete Keeps Extending SQL Prompting - October 5, 2021
With the help of dbForge Source Control tool that comes as an add-in for Microsoft SQL Server Management Studio and is included in dbForge Studio for SQL Server, you can quickly connect databases you’re working on to your version control system of choice and easily switch between different branches.
(more…)How to Generate Test Data with the Help of SQL Data Generator
Evgeniy Gribkov
Latest posts by Evgeniy Gribkov (see all)
- Creating Stored Procedure for Dropping Local Temporary Tables in SQL Server - June 16, 2021
- Dedicated Link Source Control Repository - May 6, 2021
- Database Version Control Using Source Control for SQL Server - May 5, 2021
In this article, we will examine the process of populating the employee database with dummy data, whose schema we designed in the previous part. Filling a SQL database with dummy data can be very useful when we want to run some tests. The most convenient way is the population of SQL tables with random data with the help of visual data generation tools.
(more…)SQL Database Design Basics with Examples
Evgeniy Gribkov
Latest posts by Evgeniy Gribkov (see all)
- Creating Stored Procedure for Dropping Local Temporary Tables in SQL Server - June 16, 2021
- Dedicated Link Source Control Repository - May 6, 2021
- Database Version Control Using Source Control for SQL Server - May 5, 2021
It is a common practice that a DB architect has to design a relational database tailored to a particular solution.
(more…)Is UNPIVOT the best way for converting columns into rows?
Latest posts by Sergey Syrovatchenko (see all)
- Is UNPIVOT the best way for converting columns into rows? - June 15, 2020
- Find invalid objects in your databases - June 6, 2020
- SQL Server 2016 Stretch Database - July 12, 2016
To start, let’s give definitions and highlight the difference between PIVOT and UNPIVOT operators in SQL Server.
(more…)Pimp the database diffs management with new dbForge Studio for SQL Server v5.8
Latest posts by dbForge Team (see all)
- dbForge Product Line Is Ready for Windows 11 - October 12, 2021
- Connect to PostgreSQL Database Using psql, pgAdmin, and PostgreSQL Client Tool - October 7, 2021
- SQL Complete Keeps Extending SQL Prompting - October 5, 2021
We are glad to announce that we have just rolled out the new dbForge Studio for SQL Server, v5.8. This version features massive improvements of data and schema comparison features, including redesigned diffs presentation, and provides as convenient and effective management and deployment of data and schema diffs as never before. (more…)
Automatic Schema Comparison Log Delivery via Email
Latest posts by dbForge Team (see all)
- dbForge Product Line Is Ready for Windows 11 - October 12, 2021
- Connect to PostgreSQL Database Using psql, pgAdmin, and PostgreSQL Client Tool - October 7, 2021
- SQL Complete Keeps Extending SQL Prompting - October 5, 2021
In this article, we will show how to set up automatic email delivery of the log file when a comparison of multiple SQL schemas fails. The task will be completed by means of dbForge Studio for SQL Server. Specifically, we will use its command-line functionality, allowing to perform routine tasks in both, command prompt and PowerShell. In this article, we will focus on the command prompt.
(more…)
Make Connection More Secure with dbForge Studio for SQL Server v5.7
Latest posts by dbForge Team (see all)
- dbForge Product Line Is Ready for Windows 11 - October 12, 2021
- Connect to PostgreSQL Database Using psql, pgAdmin, and PostgreSQL Client Tool - October 7, 2021
- SQL Complete Keeps Extending SQL Prompting - October 5, 2021
We are glad to inform our SQL Server users that we have just released a new version of Devart’s IDE for SQL Server, – dbForge Studio for SQL Server v5.7. In this version, we have implemented support for the Active Directory – Universal with MFA authentication. (more…)
Devart keeps upgrading its SQL Server IDE to be innovative
Latest posts by dbForge Team (see all)
- dbForge Product Line Is Ready for Windows 11 - October 12, 2021
- Connect to PostgreSQL Database Using psql, pgAdmin, and PostgreSQL Client Tool - October 7, 2021
- SQL Complete Keeps Extending SQL Prompting - October 5, 2021
Devart is always trying to keep in touch with the times and provide its users with more and more opportunities for successful and effective databases management. That is why we have released a new version of dbForge Studio for SQL Server v.5.6 with the changes aimed at supporting the latest technologies in the world of database development. (more…)