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

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

This article provides an overview of Hyperscale elastic pools in Azure SQL Database. An Azure SQL Database [elastic pool](elastic-pool-overview.md) enables software-as-a-service (SaaS) developers to ...

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

This script detects when there are sleeping sessions with open transactions older than 10 minutes by default. Such sessions can cause blocking and can prevent the transaction log from clearing, ...

Number of log files Azure Database Migration Service doesn’t support databases with multiple log files. If you have multiple log files, shrink and reorganize them into a single transaction log file.

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

3. Excel files must be store in various sql tables with various schema and columns. So I did it like this by ssis : It’s our ingredients for cooking : Sql Server 2012 or above. SSDT 2012 or above.

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9! Download SSMS 17.9 and review the Release Notes to get started. SSMS 17.9 provides support for almost all feature ...