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,656 reads
All About SQL
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
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
SQL Server Christmas Script
Nothing much to say but I hope you all have a nice break. Thanks for the support and reading my blog. Enjoy the script! (Might not format correctly here...
2019-12-19
50 reads
Blogs
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers