Creating a Serverless Database in Azure
Learn how you can create a database in the serverless tier in Azure.
2020-06-29
9,520 reads
Azure SQL database
Provisioning Azure SQL Database with Failover groups using Terraform
Get a basic introduction to Terraform by deploying and removing SQL Servers and a failover group to Azure.
2020-06-18
5,338 reads
2020-06-08
500 reads
2020-05-22
Configuring Database Alerts for Azure SQL Database
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,477 reads
2020-03-31
518 reads
Going Serverless with Azure SQL Database
Microsoft has a new virtual core offering of Azure SQL database called serverless and this offering optimizes the price performance tradeoff and simplifies performance management for databases with intermittent and unpredictable usage.
2020-01-14
Overview of Azure SQL Database Networking
Learn about the range of connectivity options available for Azure SQL Database deployments.
2019-12-24
Overview of Azure SQL Database Networking
Learn about the range of connectivity options available for Azure SQL Database deployments.
2019-12-20
Querying Master Database DMVs in Azure SQL Database
Learn how you can query information in the logical server's master database from an Azure SQL Database.
2019-12-12
4,909 reads
Blogs
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Flying Halfway Around the World to Australia
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
Dealing with Change – Two Resources
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Forums
Pivot query
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Table with FK(s) to other columns within the table
Hello All, I have recently joined a project, where main, core tables with millions...
SQL 2017 throwing BugCheck on differential database restore
Long time listener, first time caller. I have a problem that my usual bag...
Question of the Day
Using Table Hints in a Query
How many table hints can I include in a query?
See possible answers