You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are ...

There's a catch: They have to bring their workloads to the Azure cloud. But for some users, this could be a feasible option. Extended support for SQL Server 2008 and 2008 R2 is set to end in July ...

3] Setting up rules for the users to access the FTP Folder. In this step, we will configure the FTP Server to allow the newly created user accounts to access it.

Add Images to SQL Server . Adding images to and removing them from a SQL Server database is straightforward using simple drag-and-drop procedures.

Hoping to pull from the hive mind on this one. I'm wondering if there is a way for someone to be able to do maintenance work on a sql server without actually being able to look at the data. What ...

Today we are extending our look at user accounts by creating database users and then adding them to specific roles for to provide the proper level of access to a database. First thing is first: we ...