Script: Logins with Server Roles
Script to find out logins and the assigned Server Role
Month: September 2020
Scaling Azure SQL Database
When using the Azure SQL Database and you have utilization of your database based upon some trends, like users login more during business hours or the database is being used for reporting purposes for the majority of time and only for small duration of a day or week it’s being having hammered down when doing the loads. It’s better to utilize the DbAAS to the best and scale the database up/down to save cost, it can save you big money.
Just an update.
In the weekend I was just having a quick look on all the blogs I have written so far, and checking all of them gave me two thoughts. I have not given proper examples. Most of the blogs have the GUI interface and not the T-SQL/ PowerShell alternative. And so in coming days I will […]
Auditing Azure SQL Database
Auditing for Azure SQL Database can be enabled at SQL Server or Database level, using GUI or PowerShell.
Dynamic Data Masking in Azure SQL Database
Dynamic Data Masking is a very easy to use feature in SQL Server to hide the information from users without actually making any modification to the actual data. In Azure implementing Dynamic Data masking is even easier.
Restore an Azure SQL Database
An Azure SQL Database can be restored to the same server or to a different server in a different region (Geo-Restore, will cover this in next blog), using Portal or PowerShell for doing this.
Running the SQL Server Job on the desired node of Availability Group
Script to add the AG logic in SQL Server Jobs
Geo-Replication for Azure SQL Database
To provide business continuity Azure has the option to replicate your database to multiple regions by using Geo-Replication.
being a dba 