Implementing Stretch Database
Learn how you can enable the Stretch Database feature in SQL Server 2016.
2020-07-03 (first published: 2019-01-15)
4,618 reads
Learn how you can enable the Stretch Database feature in SQL Server 2016.
2020-07-03 (first published: 2019-01-15)
4,618 reads
2020-05-18
3,137 reads
This article will help us to understand how to monitor Azure SQL Database and set up Azure metric alerts. Even though the database in Azure SQL Database is fully managed by Microsoft, we are still responsible for proper database access and performance. Azure does make it easy for us and it can alert on critical […]
2020-05-04
6,486 reads
This article will explain and help to create and deploy ARM templates using the Azure portal. When Azure was first created, Azure resources were managed using the Azure service management (ASM), which is also known as “Classic”. Now this has been replaced and is called the Azure resource manager (ARM) API. ARM is the deployment […]
2019-06-03
1,865 reads
This article provides pricing guidance for SQL Server virtual machines in Azure.
2018-12-03
2,975 reads
Data Migration Assistant (DMA) to Check for SQL Server Compatibility Issues and Perform assessment when Migrating to Azure SQL Database or to SQL Server on an Azure Virtual machine.
2018-11-26
1,488 reads
Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server Level Audit Group.
2018-10-18
4,205 reads
Determining the number of DTUs which will help in deciding the service tier for Azure SQL.
2018-09-20
849 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
I've got something I'm not aware of performing backups of my dbs at random...
Dear all, I was just wondering: Can you change the default behaviour as illustrated...
Hello folks, I would be very grateful if someone could assist me with this...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers