sql server

How to Install 15 dbForge SQL Tools in 15 Minutes Using Chocolatey

Getting prepared for work need not take long, no matter whether you deal with physical or digital tools. Undoubtedly, there are better things to spend time on than make your way through a dozen wizards, however simple and convenient they might be. And if you are a SQL database developer or administrator, we can give you a quick example and equip you with a set of 15 top-notch tools in next to no time with even less effort.

(more…)

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 is also essential to delete temporary tables after using them. 

In this article, we’ll examine the basics of temporary tables and define how they differ from table variables. Then, we’ll learn how to delete temporary tables correctly, and we’ll create a stored procedure for deleting temporary tables in a current session.

(more…)

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, macOS, and Linux. This product is a lightweight modern environment for SQL code development with numerous embedded features. Its goal is to simplify the users’ daily tasks and continually improve their professional experience.

(more…)

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 main principles of database restore available in Microsoft.

(more…)

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 implementation and automation of the SQL Server backup process.

(more…)

SQL Server Backup Types and Key Concepts

The importance of database backup and restore can be neither underestimated nor ignored. And since your data is subject to modification, the primary task is to ensure its safety and mitigate the risks of data loss.

(more…)

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 global default solution. SQL Server Extended Events apply to the DBMS state monitoring and help DB developers or DBAs to collect information, view it, and analyze it.

(more…)

How to Check SQL Server Query History

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

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.”

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