Backup Your On Premise SQL Server Directly to an AWS S3 Bucket
I’ve been having a little play around with AWS recently and was looking at S3 (AWS’ cloud storage) when I...
2018-06-18
713 reads
I’ve been having a little play around with AWS recently and was looking at S3 (AWS’ cloud storage) when I...
2018-06-18
713 reads
Sometimes emails from SQL Server go missing, especially when you share an inbox with colleagues. On most occasions it doesn’t...
2018-06-14 (first published: 2018-06-05)
2,313 reads
Now this is something that I’ve seen asked a few times and it’s always a question that gets a fair...
2018-05-24
1,657 reads
Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling...
2018-05-14 (first published: 2018-05-02)
2,384 reads
This month’s T-SQL Tuesday is brought to you by Jens Bestergaard – the subject is Essential SQL Server tools, the original...
2018-04-10
1,092 reads
We all go to great lengths to make sure that our databases are secure (or at least I really hope...
2018-04-09 (first published: 2018-04-04)
2,456 reads
Here’s a quickie that I’ve just stumbled across.
I’ve just tried to initiate a manual failover of an availability group and...
2018-03-29
503 reads
Have you ever had an issue where TempDB was filling up on your secondary replicas? Do those secondaries happen to...
2018-03-28 (first published: 2018-03-21)
3,598 reads
So for this month’s TSQL Tuesday, Adam Mechanic has asked us to take a look into the future and think...
2018-03-13
430 reads
The other day I got thinking about what would happen if all databases on a single instance grew out, every...
2018-03-12
256 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers