Database Solutions

Understand the Capabilities of Data Migration Assistant for Upgrading Your SQL Server Edition

In this article we understand the Data Migration Assistant in SQL Server and how it helps when upgrading a SQL Server instance to Azure. The Data Migration Assistant in SQL Server helps detect compatibility issues between the data platform in use, the more recent edition of SQL Server, and Azure databases, that you might be willing to update to. On the basis of this detection, it suggests the user a modern data platform to which they should update for better functionality of the database....

Read more »

6 Key Best Practices to Keep in Mind for SQL Server Profiler

In this article we learn about SQL Profiler, and what are the best practices to be undertaken when using it for tracing. If you have been using SQL Server Trace feature for long, you might also be used to making use of the SQL Profiler feature. This feature is the GUI for the SQL Trace, using the Profiler in SQL, it becomes easier to create, manage, and analyze the results of SQL Trace. However, there are certain key practices that you need to keep in mind when making use of the SQL...

Read more »

Salient Aspects of Bulk Logged Recovery Model in SQL Server

In this article we explain you all about the Bulk Logged Recovery Model Available in SQL Server. Read to know how, when and why to use it. The processes of backing up data and restoring backed up data in SQL Server happens in the Recovery models provided by the application. Recovery models in SQL Server are provided by default, and have been given for the very important purpose of controlling the maintenance of the transaction log. It is the recovery model that manages how the transactions...

Read more »