In today’s tip I looked at how you can allow users on your system to see the SQL Agent jobs on the database server. However, just because you are able to assign these permissions, doesn’t mean ...

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

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

SQL is not my thing, I know how to install it, run a query, and thats about it. I am doing a consulting job right now for a friend of mine setting up a small ecommerce .com infrastructure. Most of ...

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