sql complete

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…)

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 much as we can, tailoring this tool to our specific needs. That’s how we get a wide range of SSMS add-ins and extensions at our service.

(more…)

It’s Harvest Time: dbForge Reaps G2 High Performer Fall 2021 Awards

September has been around for mere two weeks, yet we have already added 2 new shiny badges to the wall of dbForge awards.

Why not add a couple more, then?

Our flagship database solutions for SQL Server—SQL Complete and dbForge Studio—have both reaped the G2 High Performer Fall 2021 badge.

(more…)

Write a Review of SQL Complete on Capterra!

It should come as no surprise that user reviews on independent reviewing platforms are extremely important to us. It is your review that can make all the difference to a person looking for a reliable database tool to help them cope with daily tasks most effectively. And it is your review that can become the final incentive for them to try it.

(more…)

Devart Products Become the Winners of DBTA’s 2021 Readers’ Choice Awards

We are delighted to announce that Devart has been ranked #1 by the readers of the Database Trends and Applications magazine — the leading media specializing in information management, big data, and data science.

(more…)

How to Use SQL Server DBCC SHOW_STATISTICS

Database statistics are a powerful weapon. They store a vast array of information about the database data that helps identify slow-running queries and allows you to devise an algorithm to optimize query execution. The query optimizer embedded in your SQL Server database uses statistical data to tune execution plans according to the way your data characteristics change. That is why it is vital to keep the statistics up to date and to understand them well. Therefore, in this article, we are going to look at how to collect statistical information and how to interpret it correctly.

(more…)

How to Create Customizable CRUD Operations with SQL Complete

Working with SQL databases and tables usually implies performing daily data-related tasks using the CRUD operations in order to re-use, manipulate, and access data later. For example, you can create a new table, modify, populate the table with data, retrieve and store data for future use, or delete if needed.

(more…)

SQL Complete v6.7 Released!

The Devart team is glad to present the latest version SQL Complete v6.7 – an advanced solution for database development and management packed with a rich set of autocompletion capabilities.

(more…)

How to Check SQL Server Query History

Evgeniy Gribkov

Evgeniy is an MS SQL Server database analyst, developer, and administrator. He is involved in the development and testing of the SQL Server database management tools. Evgeniy also writes SQL Server-related articles.
Evgeniy Gribkov

The data stored in the history of queries are among the most valuable for any DBA. Tracking back the SQL Server query history is a must in many cases. For instance, there might be a need to investigate a particular work case, check the backup history, or recover a specific query if your SQL Server suffers a crash.

(more…)

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, where things can change faster than you say “blueberry pie.” But then a contender emerged, developed and released by the same Microsoft folks in 2018. It was Azure Data Studio – obviously less mature, weaker in terms of database administration, yet very promising and eager to win its audience. And today, we’re going to put them face to face and find out who’s better.

(more…)