News

Small businesses can create and access an SQL database of their creation for as little as $4.99/month. This tutorial shows you how to use the Azure Portal to create a cloud-based SQL database with ...
You're now the owner of a shiny, new Azure SQL Database and, more importantly, the owner of an ARM template that allows you to create an additional database on a whim. About the Author Adam ...
There are different ways to create a SQL database in Azure. We can use the Azure portal, or we can use PowerShell. Both methods have their advantages, but if you're writing a script to automate a task ...
Elastic Jobs also requires you to create an Azure SQL Database to manage the jobs. One other option that I don't have the space to fully address here is Azure Functions.
In Azure SQL Database you can also set a HISTORY_RETENTION_PERIOD (and should be able to do it in SQL Server 2017) to control how far back in time your history will extend. Converting Existing Table ...
In an earlier column, I showed how to create a temporal table in SQL Server 2016 or Azure SQL Database. Once you've defined a temporal table, SQL Server automatically keeps a history of all the ...
To do it via PowerShell, you'll need your Azure SQL database server name. To get this, you can use the Get-AzureSqlDatabaseServer cmdlet. You can see here that I have a single server called ...