Database Recovery

4 Effective Methods to Protect Your SQL Server Data

With digitalization all over the world, it is very important that the data saved in database is secure. Irrespective of the size, it is a fact that every database has some sensitive data and that has to be protected. This article highlights all options to secure your SQL Server data 1. Start with proper access and review it The first important step is to ensure that you are providing only necessary access to users. If a user wants to read some data from database, provide them with Read...

Read more »

How to Avoid Running Your SQL Server Script on the Wrong Server

You might be a database administrator or a SQL Server developer; running queries through SQL Server Management studio is a routine task. Though you might connect to multiple servers at a time and work on multiple activities, there are chances that you might execute a script on a wrong server. Do not worry, this article will help you to avoid executing scripts on a wrong server Notice the alert Run this script on your server and the next time you hit the “New Query” button on the SQL...

Read more »

How to Create SQL Server Database Mail on Multiple Servers

SQL Server's Database mail can never be skipped as it is very important and has to be enabled to send notifications to end users. Setting database mail on a single server is not a tough task as it can be easily completed using the SQL Server management studio. However, it will be a hectic task if you are setting SQL Server Database mail on hundreds of server. Use this script to automate it. Create Table The very first step in this automation is to create a table to hold server names. Create...

Read more »