SQL Server Tools
Devart Joins the Winners’ Circle of 2020 DBTA Readers’ Choice Awards
For the second year in a row, readers of DBTA — a magazine focusing on data, information management, and analytics — choose Devart products...
Searching for Invalid Objects with SQL Complete
The present article deals with one of the bottlenecks in the work of database developers and administrators, namely the occurrence of invalid objects and...
New Git Client Has Been Implemented in dbForge Source Control v2.2
We are thrilled to announce that a new version of Source Control - our advanced SSMS add-in for SQL Server database change management -...
Find Invalid Objects in SQL Server Databases
In the course of time, we can experience situations when some certain database objects have not been distributed on one or several databases...
Compare and Find Data Differences Between Two Tables in SQL Server With SSIS and dbForge Tools
Systems often work with distributed databases that contain distributed tables. Distribution is supported by various mechanisms, including replication. In this case, it is...
Is UNPIVOT the Best Way for Converting Columns into Rows?
To start, let's give definitions and highlight the difference between PIVOT and UNPIVOT operators in SQL Server.
The PIVOT and UNPIVOT relational operators are used...
Meet new Standard edition of SQL Tools
We are delighted to announce the release of the brand new Standard Edition of our SQL Server mega tool pack, dbForge SQL Tools.
Our principal...
Take full advantage of SQL Server 2019 with SQL Complete v6.5
The dbForge team is delighted to announce a fresh release of our advanced solution for SQL database development - SQL Complete. The new version...
New version of dbForge Source Control for SQL Server released
We are excited to announce that a new version of the SSMS add-in for SQL Server database change management, dbForge Source Control for SQL...
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...
