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.
Read the rest of this entry »Database Versioning with Examples
To properly manage the database development process, stay informed of the changes delivered by other developers, and avoid conflicts or missing data in the database, one needs database versioning. This allows you to reconstruct any version of the database, view the history of changes, and ensure smooth database delivery.
Read the rest of this entry »How to Rename a MySQL Database?
Eventually, it appears necessary to change the name of a database in MySQL. For that purpose, we used to apply a simple RENAME DATABASE command that existed in earlier versions of MySQL. However, it became no longer available in the newer versions as it posed risks. The reason was that the RENAME DATABASE query could result in the loss of essential database contents, which clearly was undesirable.
Read the rest of this entry »Devart Stays on Winning Paths with ComponentSource Awards 2021
Once again, ComponentSource announces its Bestsellers of the year. This well-known professional resource researches the popularity of different software products each year. The analysis grounds on actual sales.
Read the rest of this entry »dbForge Studio for SQL Server Has Been Awarded G2 High Performer Spring 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.
Read the rest of this entry »Implement Automatic Migration of SQL Server Databases for DevOps
Quite often, migrating a database proves to be a cumbersome task. You have to control both schema and data changes introduced into the database. If you intend to build a reliable automation pipeline, you need to fully understand the process and use the proper tools to enhance your productivity.
Read the rest of this entry »Version Control System – Version Control with Git
The article deals with the basics of versioning SQL Server databases and goes into the basics of working with the Git version control system.
Read the rest of this entry »Support for EF Core 6, JSON and YAML Serialization, and More Features in Entity Developer 6.11
Devart is glad to announce the release of Entity Developer 6.11 – a visual ORM designer for a wide variety of ORMs. The new version introduces support for Entity Framework Core 6, greatly improves serialization features in code generation templates adding support for more formats, and offers a number of usability improvements.
Read the rest of this entry »New in SecureBridge: RAD Studio 10.4.2 and TLS/SSL Server Component
We are glad to announce a new version of our security components for Delphi and C++ Builder with support for the latest versions of the IDEs and operating systems: RAD Studio 10.4.2, Lazarus 2.0.12, macOS 11 Big Sur, iOS 14, and Android 11.
Column-Level SQL Server Encryption Example Using SQL Complete
The article provides an overview of the column-level SQL Server encryption, including the definition of the Always Encrypted feature, the keys it uses, and their types, and describes how to enable Always Encrypted and set up COLUMN MASTER KEY and COLUMN ENCRYPTION KEY in dbForge SQL Complete.
Read the rest of this entry »