jkhealthworld.com


Thursday, February 11, 2010




Ownership chaining in SQL Server security feature or security risk



I have heard of something called ownership chaining within SQL Server, but I don't know what that is or how it works. I'd like to know if it's a security risk or a security feature and if it's a feature, how do I use it. If it's a risk, I'd like to know how to defend against it.

Using the SQL Server 2005 Surface Area Configuration Tool

SQL Server Surface Area Configuration Tool (SQLSAC) is a utility which was introduced by Microsoft in SQL Server 2005 to make it easier for SQL Server Database Administrators to manually turn on features which are by default turned off within the product. The SQL Server Surface Area Configuration tool can be used by DBA’s to disable or enable unused SQL Server Services, disable or enable network protocols for remote connections, and to enable or disable unused features of SQL Server 2005. However, it is advised to leave the default settings turned off unless you real need them in your environment. This way, you can keep your SQL Server safe from potential attacks.
Idera -SQL virtual database

Access data in SQL Server backup files without restoring. Idera’s SQL virtual database is a powerful, new one-of-a-kind solution that lets you attach SQL Server backup files and query them just like they were real databases!

SAP – Crystal Reports: END REPORTING OVERLOAD.

Reduce business user requests by giving them intuitive, interactive reports and dashboards. Try our system-friendly, budget-friendly reporting solution free for 60 days. Start Your FREE Trial.
  1. Develop SSIS like an expert in a fraction of the time from within Microsoft Visual Studio (BIDS)
BI xPress integrated with BI Development Studio (BIDS), is an enterprise ready tool that allows the ability to add auditing, monitoring, and notification to all of your SSIS packages. It also allows validates and deploy packages very easily. BI xPress employs best practices and can reduce the amount of manual labor required to create an SSIS package. This allows you to have a consistent framework across all SSIS packages