To view this email as a web page, go here.
To ensure future delivery of emails, please add news@idera.com to your safe sender list or address book.

goggles
     Issue 24  |   July 2007

Focus on SQL Server Security & Compliance

Welcome to SQLsmarts, Idera’s monthly newsletter for SQL Server Professionals! We welcome your questions, comments or suggestions.
Email us at SQLsmartseditor@Idera.com.

 New Free Tool from Idera: SQLpermissions

Do you need to transfer SQL Server logins & permissions to a new server?

Try new SQLpermissions – it’s free!

Configuring logins and permissions on one server to match another can be a time-consuming, tedious, and error-prone job.  Save time and ensure that permissions are transferred correctly with SQLpermissions—a new free tool from Idera that will help you expedite the process of copying or moving logins and permissions settings across SQL Servers!

Download SQLpermissions now button

SQLpermissions will help you:

  • Generate T-SQL scripts to move logins and permissions from one server to another
  • Move either a single log-in or group of logins
  • Generate permissions on a single database or across all databases
  • Get a simple view of all logins and permissions


To learn more
read Microsoft’s Knowledge Base article: 
“How to transfer logins and passwords between instances of SQL Server”
Read it now! Click here >>

 Get Compliant, Get secure!

Did you know that Idera provides advanced tools to help you ensure compliance and manage security on your SQL servers?

SQL compliance manager tells you who did what, when and how by providing powerful, low-impact auditing, alerting and compliance reporting on activity across multiple SQL servers. 

SQL compliance manager provides:

  • Powerful auditing of virtually all SQL Server user activity
  • Flexible collection filters to gather only the data you need
  • Customizable alerts to notify you of suspect user activity
  • Self-auditing features guarantee an immutable source of audit data
  • Comprehensive reporting to satisfy audit requirements
Find out more button
Try SQL compliance manager for 14 days
button

SQLsecure analyzes users’ permissions across SQL Server, Active Directory and Windows so that you know exactly who can access what on your SQL servers. 

SQLsecure helps you:

  • View user and group effective access rights
  • View inherited rights on server or database objects
  • Highlight concerns such as suspect Windows accounts
  • Track changes to your SQL Server security model
  • Satisfy audit requirements with entitlement reports
Find out more button
Try SQLsecure for 14 days
button
 New Whitepaper

“Top 10 Steps to Secure Your SQL Servers”
Author: Idera

Download your copy now! button

In most organizations today, business critical and confidential data increasingly resides in Microsoft SQL Server databases.  As a result, SQL Server database security and compliance have become critical issues that must be effectively addressed to ensure an organization’s overall security.  This whitepaper gives an overview of 10 key areas you need to focus on in order to ensure that your SQL Server databases are secure – before you find your company in the headlines.

 Events

WEBCAST:
SQL Server 2005 Table Partitioning

Thursday July 24, 2007 (Rescheduled from July 19)
11:30 AM Central – 1:00 PM Central
Hosted by: Scalability Experts & Idera

Register now button

True Table Partitioning is now part of SQL Server 2005 and allows better control of data placement on disks as well as enabling new data management scenarios. Join Idera & Scalability Experts to discuss how you can effectively utilize table partitioning in SQL Server 2005 and how it now easier to manage large tables.

ON DEMAND WEBCASTS:
Learn more about SQL Server Security & Compliance

Understanding SQL Server Permissions
Register here now! >>

Understanding SQL Server Security
Register here now! >>

Best Practices in SQL Server Security & Compliance
Register here now! >>

 Feedback

We want to hear from you!

Do you have an interesting story about how Idera product(s) have helped you? Want to share a product tip, trick or hint? Have product suggestions or questions?

Your feedback helps us ensure that our newsletter is helpful! You may even find your input published here in future newsletters.

Please send your comments and suggestions to SQLsmartseditor@idera.com
 

 

 
Get Compliant, Get Secure
with these special offers from Idera:

 

 

 

screenshot
CLICK TO ENLARGE
SQL compliance manager
will provide you with a comprehensive security change history. For example, you can track all changes to security permissions across your SQL Server enterprise -- including who changed, what, when, and where.

 
 
screenshot
CLICK TO ENLARGE
SQLsecure
will provide you with a comprehensive security change history. For example, you can track all changes to security permissions across your SQL Server enterprise -- including who changed, what, when, and where.
 

This email was sent by: %%Member_Busname%%
%%Member_Addr%% %%Member_City%%, %%Member_State%%, %%Member_PostalCode%%, %%Member_Country%%

    Update Profile    Unsubscribe