“Permissions management in SQL Server can be very complex, especially for an IT person who has a lot of responsibilities beyond SQL Server and is not a dedicated DBA,” said Bob Crosley, senior ...

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 ...

If the SQL server is set up to use Windows authentication, and you have the AD account names of all the users tied to their user id, then you can use the suser_sname () function inside a view to ...

SQL Server now comes bundled with a reporting tool, Reporting Services. RS has generated a lot of attention among developers since it first came on the market about a year ago.

Information in this article applies to Microsoft SQL Server 2012. The instructions for earlier versions of SQL Server, including versions 2008 and 2005, are similar.

“SQL secure eases the compliance burden by enabling a DBA to go back and link directly to the specific regulatory citation and automatically audit and record the required permissions and security ...