ssms
SSMS 20.x: What’s New
Although there is nothing groundbreaking about the latest SQL Server Management Studio 20.x, we'd still love to tell you more about the newly added enhancements that it offers.
SSMS 20 + dbForge SQL Tools = Your Winning Combination!
Just in case you've missed it, Microsoft recently rolled out the latest version of SQL Server Management Studio (a.k.a. SSMS), 20.x, as a General Availability release. Traditionally, you can install and run it alongside the earlier versions of SSMS.
Empower Yourself With the Latest SSMS 19.2 and dbForge SQL Tools!
On November 13, 2023, Microsoft's new SQL Server Management Studio (SSMS) 19.2 saw the light of day. It's the IDE you will definitely need if you are dealing with the most modern versions of SQL Server.
How to Change Grid Font Size in SSMS
SSMS users sometimes need to zoom grid results to improve visibility. This article will guide you through the process of zooming in on grid results with ease.
How to Export Data from Azure SQL Database
If you are a user of Azure SQL Database, you don't have all that many ways of exporting your data. Here, we'll show you all of them and save the best for last.
Streamline Your SSMS Workflow: Tab Color Customization With Native Features and SQL Complete
This article delves into the benefits of tab color customization, exploring how the combination of native SSMS and SQL Complete features empowers you with seamless navigation and a visually appealing workspace.
How to Access Snowflake Data Warehouse Easily from Power BI or Tableau using ODBC Driver for Snowflake
This article explains how to connect to Snowflake using ODBC Driver for Snowflake and make a trace log on Windows, macOS, and Linux operating...
11 Reasons Why You Need dbForge SQL Complete
Okay, so you deal with SQL code in SSMS every day? Then you most probably would not mind doubling your output without investing too...
Exportieren und Importieren von SQL Server-Datenbankdaten in ein SQL-Skript
Wir stehen recht häufig vor der Aufgabe, Datenbankverzeichnisdaten zu migrieren. Die Datenbank für einen Personalvermittlungsdienst, die wir in der vorangegangenen Artikelserie erstellt haben, bildet...
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...
Here Comes a New Update of SQL Complete 6.11 with Support for SSMS 19
We've got a new update of dbForge SQL Complete, your favorite add-in for SSMS and Visual Studio that helps you write clean SQL...
dbForge Search vs Redgate SQL Search vs ApexSQL Search: A Comparison of SSMS Add-ins
The three times that the word "search" is repeated in the title of this article might seem an overkill, but what can we do?...
How to Compare Two Formatting Styles in dbForge SQL Complete
One of the primary features of dbForge SQL Complete—a top-tier add-in for SSMS and Visual Studio—is code formatting, which helps beautify SQL code and...
How to Switch From SSMS to dbForge Studio Effortlessly
If you are reading this, chances are that you are an active user of Microsoft SSMS. And following the title that has brought you...
Here Comes the Latest Update of SQL Complete!
It's time to unveil the latest update of dbForge SQL Complete, your favorite code completion add-in for SSMS and Visual Studio. We have enhanced...
Get the Latest Maintenance Update of SQL Complete 6.9
We have just released a maintenance update of dbForge SQL Complete, an add-in for SSMS and Visual Studio that can accelerate your daily SQL...
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...
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.
Our team...
SSMS Tools Pack vs dbForge SQL Complete: A Clash of SSMS Add-ins
Undoubtedly, SSMS is a proven database management and administration tool that does its job well. Yet we all tend to expand our capabilities as...
dbForge Source Control versus Visual Studio Version Control: What’s Different?
Having a database under source control brings huge benefits. Therefore, we decided to review and compare two popular version control tools, dbForge Source Control...
General Review of Microsoft SQL Server Management Studio (SSMS)
SQL Server Management Studio or SSMS is, perhaps, the most famous product for managing Microsoft SQL Servers and any SQL infrastructure. Many experts consider...
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...
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,...
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 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,...
Azure Data Studio vs SSMS: Who’s the Winner?
For 15 years, SSMS has held the title of the top SQL Server database tool. That's no easy feat, especially in the software world,...
Manage Your Sensitive Data With SQL Data Discovery and Classification in SSMS
The 17.5 version of SQL Server Management Studio (SSMS) brought with it a new built-in security tool. Since then, the Data Discovery and Classification...
SQL Unit Testing Stored Procedure with dbForge Unit Test for SQL Server
Unit testing is an essential component of the database DevOps process. Its primary goal is to test the constituent parts of the database objects...
How to Export and Import SQL Server Database Data to a SQL Script
Data migration is a common challenge in the field of database development, management, and administration. This guide will illustrate the process of exporting database data to a .sql file and subsequently importing it into the target database.
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 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...
Store and Share Static Data in Updated Source Control!
We are pleased to announce the release of the new version of our MS SSMS add-in for easy tracking and deployment of changes, dbForge...
SQL Query History in SQL Complete
dbForge SQL Complete includes the whole range of options that provide possibilities for powerful optimization and great performance increase. SQL history is an important...
Keep going to improve productivity with dbForge SQL Complete
The Devart team brings together the interests of its clients and best usability practices in a new version of SQL Complete 6.0. Read on...
Creating Linked Server in SSMS using ODBC
SQL Server Management Studio is an ideal environment for managing infrastructure of SQL Server database and SQL Server itself. With SSMS, you can easily...
Possibility to connect to Azure Multi-Factor Authentication completed!
The new release of SQL Complete 5.9 brings simplicity to your SQL coding and provides an additional security approach to safeguard access to your data....
Tidy SQL with SQL Complete
In this article, we will talk about how to keep SQL code clean and highly readable. We will also discuss how to stop suffering...
SQL Server 2016 RC0
The news about Microsoft's intention to "chum" SQL Server with Linux keeps floating around. But I haven't heard a single word about SQL Server...
How to Build a Database from Source Control
There is no doubt that database developers can and should benefit from using source control systems. Regardless of the type of source control system, developers...
SQL Server Index Fragmentation In-depth
In this article, we will drill down into the SQL Server index fragmentation issue and how to tackle it. We will figure out why index fragmentation is a problem and how it affects overall performance and discuss how to detect and avoid it.
Adventures of CLR Types in .Net Framework
Summary: This article describes the issue occurred with execution of the a polygon instance of the geography type and the possible solution for it.
Once...
New version of add-in that can replace native Intellisense for SSMS is available!
When working on the new version of SQL Complete, we were focused on the idea of providing the most needed functionality to our users....
Improving Performance for Parsing UNION Clause in SQL Complete
Devart's prompt SQL tool can help SQL Server developers and DBAs to write SQL smoothly, with code-completion. SQL Complete works with current and older databases, thanks to backwards compatibility.
SQL Complete: Parsing performance improved!
SQL Complete allows developers to use IntelliSense when they write SQL queries in SQL Server Management Studio. The tool will tell you the exact formatting you should use for your SQL commands while you are writing them and will therefore help you write fast, perfectly formatted SQL statements.
