High Performance and Reliable SQL Server Cloud Backups with CloudBerry As a SQL Server DBA we need to have backups onsite and offsite to protect our organization. We need a SQL Server offsite backup solution that will support all of the features in the environment, encrypt the backups, guarantee our backups are restorable and have a high performance restore process. Do you have any suggestions? Should we be considering options for SQL Server cloud backups?
Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions I'm in a dilemma. In a database I currently support, the application makes use of db_datareader and db_datawriter to give permissions to the tables. In a different database, it's even worse as the application uses db_owner. We're adding new tables to both databases and we don't want the application to have access to these tables. How can I deal with the use of these three roles? I do not have time to re-architect the security and redo the permiss
So you are thinking about putting your SQL Server databases in the
cloud. Your company is considering Amazon's cloud or have already signed up with Amazon.
Now they want you to move your SQL
Server instances to AWS Relational Database Service (RDS). As a seasoned
professional, you know it better than anyone: you want to know what benefits it
offers, what challenges you will face and above all, what measures there are to