I’m not too experience with access permission of SQL Servers and I’m currently in need of some advice.
We have a team of about 2 or 3 employee’s which are going to be using SQL reporting services and accessing a selection of databases in our sql server. I would like to know what is the best method to give them permissions to use this tool against only the selected databases they’re going to be using. (If possible so that they won’t see the other databases either.)
There are databases in the sql server that are very critical for the company and we would like to do this as safe as possible.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.