A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

You're a DBA, sysadmin, or developer who manages Microsoft SQL Servers. It's your fault if they're down or slow. These tools help you understand what's going on in ...

If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...

Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

When the DBCC CHECKDB (or other similar commands like DBCC CHECKTABLE) is executed, a message like the following one is written to the SQL Server error log: DBCC ...

Have you ever faced the daunting task of restoring an encrypted SQL database to another server? It's a complex process that requires careful planning and execution. To understand how to tackle this ...

MySQL is amongst the most popular database platforms for storing critical data for businesses and individuals. While it is known for its reliability, MySQL is not infallible especially as the ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

In this release of Azure Data Studio, we have exciting news to share across several of our core features and extensions. The first is the announcement of the general availability of Table Designer and ...

This blog post is part of the SQL Server 2022 blog series. Buffer Pool Parallel Scan is a new feature in SQL Server 2022 that improves the scalability of several common scenarios in SQL Server and as ...

Assumption: The database must have been exported from the source environment and it is on the asset library (Database backup section). Step 4: Extract the downloaded SqlPackage to a folder (In this ...