Azure SQL Database – Error Logs?
Ok, so Azure SQL doesn’t really have its own error log based somewhere on a machine within \MSSQLLog directory but the closest thing you will get is a system...
2020-04-07
1,665 reads
Arun Sirpal
Azure SQL DB – An instance-specific error occurred while establishing a connection to SQL Server.
The full message when connecting to your Azure SQL Database is: Reason: An instance-specific error occurred while establishing a connection to SQL Server. The public data endpoint on this...
2020-03-16
383 reads
SQL Server Agent for Azure SQL DB?
I always wanted a way to schedule commands within Azure SQL Database. Personally, for me, the go to standard is the functionality of SQL Server Agent. Obviously, this is...
2020-03-02
27 reads
Azure Database for PostgreSQL
Having worked with Azure SQL Database and its many flavours for couple of years now I am confident in building deploying, whether manual or templates. Being in Azure you...
2020-02-18
21 reads
Azure SQL Database and Error Handling
For some reason I have friends / colleagues telling me that when scaling (up and down for this example) that no downtime occurs. Well, not only does Microsoft documentation...
2020-02-11
260 reads
Azure Advisor – for Azure Data Platform
Wouldn’t it be nice if we could access one main dashboard / report that pulls in information from many tools such as security centre, SQL advisor and cost management...
2020-02-03
14 reads
Creating a Logical SQL Server: Level 2 of the Stairway to Azure SQL Database
In this second level of the Stairway to Azure SQL Database, we cover the basics of building a logical server using the portal and PowerShell.
2020-01-29 (first published: 2018-07-18)
4,113 reads
Amazon Web Services (AWS) vs Azure Features List
After much reading through the internet looking for Amazon’s equivalent of Microsoft’s Azure functions (Lambda), I found this outstanding link that ” helps you understand how Microsoft Azure services...
2020-01-13
225 reads
Common Things Admins Miss in Azure SQL DB
This is by no means a complete list but more of a personal list of features I have seen not setup or just missed out when looking at Azure...
2020-01-08
45 reads
Azure Site Recovery jobs fail on servers hosting SQL Server instances with AUTO_CLOSE DBs
This post is to help you if you are suffering from the following issue: A VSS writer has rejected an event with error. The writer experienced a non-transient error. If...
2020-01-06
38 reads
Blogs
Monday Monitor Tips: Lots of Postgres Options
By Steve Jones
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...
Advice I Like: Experience and Aptitude
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
Plan Time for Self-Development
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
Forums
Remote query is taking 99% cost of local sp execution
So we have local sp in which remote table is udpated.this remote query part...
Remote query is taking 99% cost of local sp execution
So we have local sp in which remote table is udpated.this remote query part...
Replicas in Azure Managed instance
Hi, in my environment planning to create Replicas concept for Azure Managed Instance....
Question of the Day
Data API Builder APIs
What formats of API endpoints can the Data API Builder present to clients when exposing the database?
See possible answers