SQL Server Tools
Introduction to SQL Server Temporary Tables
We all need to refer to temporary tables quite often. They are necessary to deal with interim aggregations or outputting intermediate results. However, it...
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...
Implementing a Scheduled Automatic SQL Server Backup Process
Now that we have reviewed the backup basics in the first article of our series dedicated to SQL Server backup, let’s proceed to the...
Audit and Rollback Transactions Live with dbForge Transaction Log for SQL Server
Today we'd love to unveil a big update of dbForge Transaction Log for SQL Server. This tool was designed to provide detailed information on...
How to Set Up Extended Events in SQL Server
Extended Events is a helpful and convenient solution designed to monitor your system performance. First introduced in SQL Server 2008, it has become the...
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,...
Shared vs Dedicated Development Models: Key Differences
Developing databases in a secure and efficient way is very important for each database developer in the team. To maintain and keep an...
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,...
Devart Joins the Winners of 2020 ComponentSource Bestselling Awards
The response and appreciation of our users make our company proud of the database solutions we create. This time Devart gladly joins the ranks...
