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

Every year, the Tour de France is won or lost in the mountains. In this stage of our tour of SQL Server 2005, we look at the critical administrative features that make or break the new database.

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

In November, Microsoft released version 18.4 for the SQL Server Management Studio (SSMS), introducing some key features such as support for materialized view scripts in SQL Data Warehouse.