I have been lucky enough to work in an organization where I have got the opportunity to work extensively on Azure. Microsoft has always encouraged people in sharing their knowledge with others, none can survive on it’s own. SQL Server community is the most helpful one of all, I have always been the subscriber of […]
Recently I have been quite busy with multiple different things, being Covid positive is one of that, along with spending time with my two kids and family. I’ll share more information about the things that is keeping me busy some day later. The important thing that I learned in last 3-4 months is I had […]
To have the SQL Server Always-On Availability Groups like feature for your Azure SQL Database you can create a Failover Group. It provides the option to have automatic failover for your Azure SQL databases group without the need of changing the application connection string.
The Azure Private Endpoint helps in securing the connections coming to your Azure SQL Database when used we can deny the public network access for the Azure SQL Server and just make it available from a specific VNet using DNS or the Private IP.
SQL Data Sync is a powerful feature, to know about, for providing easy sync between the mix of Azure SQL and On-premise databases.
Script to find out logins and the assigned Server Role
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.
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 for Azure SQL Database can be enabled at SQL Server or Database level, using GUI or PowerShell.
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.
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.