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.

Idera: Tools for SQL Server Management :: SQLsmarts Newsletter

www.idera.com :: subscribe

 

 

 

 

Click here to forward-to-a-friend! Send a colleague the SQLsmarts e-newsletter to keep them up-to-date with current tips and information for managing SQL Server data.


24
Incredibly useful tools for
SQL Server people

arrow ..Click here to download

Downloads



Read what Beta Particpants are saying...

"I love how the wizards for the different functions can be run so easily! You don't have to hunt and try to find the different management tools in SQL as these are here in one location. The SQL Search is awesome. I wished that I had this a year ago!"

"I am really impressed by the power and simplicity of the interface and the tools. This product ... will save us time and effort from having to always manually run scripts. KUDOS to the development team! I think it's great to see a company dedicated to managing SQL server in large
(100+ SQL servers) Enterprises!"

"This was easy to install and easy to get started with. It did a good job of discovering servers and providing configuration information. I really like the tool that searches for text across databases and lets you zoom in to the stored procedure that contains it."

 

Free Downloads

 

Tools for SQL Server:

SQL diagnostic manager
Monitor, analyze & diagnose SQL Server performance
Download a product trial now!

SQL compliance manager:
Audit key events and user activity, ensure database compliance
Download a product trial now!

SQL defrag manager:
Automate SQL Server defragmentation and analysis
Download a product trial now!

SQLsafe:
High performance SQL Server backup & recovery
Download a product trial now!
___________________________

 


Freeware Tools for SQL Server:


SQLsafe Freeware Edition:
High Performance SQL Server
Backup & Recovery Tool
Download it now!

SQLcheck:
SQL Server Performance Dashboard
& Screensaver
Download it now!

SQLpermissions:
SQL Server Logons & Permissions Transfer Tool
Download it now!
___________________________

 


Whitepapers:


“Top 10 Steps to Secure Your SQL Servers”
Download your copy now!

“Essential Guide to
SQL Server 2005
Backup & Recovery”
Download your copy now!

“The Seven Steps to Successful SQL Server Auditing”
Download your copy now!



Regional Events :

Microsoft 2008 Launch
San Diego, CA**

May 14, 2008
www.heroeshappenhere.com

Microsoft 2008 Launch
Rochester, NY**
May 15, 2008
www.heroeshappenhere.com

Microsoft 2008 Launch
Richmond, VA**
May 20, 2008
www.heroeshappenhere.com

Microsoft 2008 Launch
Baltimore, MD**
May 23, 2008
www.heroeshappenhere.com

** If the MS Launch event in your
city is “sold out” and you’d like a free pass from Idera, please email sales@idera.com

Tradeshows:

Microsoft TechEd, IT Professionals Orlando, FL
June 10 – 13, 2008
www.microsoft.com/teched2008

SSWUG Virtual Tradeshow
June 24 – 26, 2008
www.sswug.org

 

 

 

In this issue:

  arrow NEW! SQL admin toolset FREE PUBLIC BETA
Help us launch our new exciting product & enter to win a Wii!
  arrow NEW! SQLsecure version 2.0 announced
Get Compliant, Get Secure with Idera
  arrow

NEW! SQLsafe 4.7 is now available
Faster, more high-powered than ever before



Top Story: SQL diagnostic manager v5.0 is available!

Announcing:
SQL admin toolset FREE PUBLIC BETA

" Excellent product. I really like how many different tools are located in one place. Very cool stuff. I am recommending this to my supervisor." -- Actual Toolset Beta Participant

Help us launch our new product and you could win a Wii™!

Are you a DBA or developer tired of spending countless hours on routine administrative and troubleshooting tasks, like figuring out why a user can't connect, or moving databases, or producing reports for your boss to show that the backups really did run, or finding rogue SQL Servers, or checking configurations or…. yeah, we know, the list is endless!  If the answer is yes then, you need our SQL admin toolset. The Idera Admin toolset is packed with 24 powerful tools that will make troubleshooting, administration and reporting such a breeze you'll be wondering what to do with all the spare time you have on your hands—really!

SQL admin toolset is currently in free PUBLIC BETA with 13 of the 24 tools ready for download -- and we need your feedback!  Download SQL admin toolset now for free, give us your feedback, and you’ll be given the exclusive opportunity to purchase the toolset for $195 when it’s released this summer ... That's $300 off the list price!

What’s more, we’re giving away a Wii-a-Day (business days) until May 16!
We’ll be choosing one lucky winner each day from the list of everyone that has downloaded the toolset. We've already given away five to the lucky winners to date! You could be next!



Keep SQL Server data secure & compliant with SQLsecure:
New version 2.0 announced

Identify & mitigate SQL Server security risks
Get true peace of mind with Idera SQLsecure. SQLsecure is a security analysis solution that helps you improve SQL Server security and ensure compliance with corporate audit requirements.  SQLsecure will evaluate the state of security across all SQL Servers from a central point of control and analyze user and group effective access rights. SQLsecure will also save you hours of time and help keep your SQL Servers secure by quickly identifying users with inappropriate access rights.

Idera SQLsecure is a security analysis solution that helps you improve SQL Server security and ensure compliance with corporate audit requirements. SQLsecure will evaluate the state of security across all SQL Servers from a central point of control and analyze user and group effective access rights. SQLsecure will also save you hours of time and help keep your SQL Servers secure by quickly identifying users with inappropriate access rights.
SQLsecure version 2.0 is more powerful than ever before, allowing you to proactively identify SQL Server security risks and vulnerabilities, and quickly find and fix SQL Server security weaknesses and policy violations.

New features in SQLsecure version 2.0:

Policy-based Security Analysis
Checks database security against more than 60 security standard checks and includes built-in policies templates from NSA, DISA, CIS, and others.

Alerts
Sends immediate alerts if security fails to meet the requirements of your security policies.

Database Roles Permission Explorer
Analyzes assigned and effective permissions by database role, now including sub-roles and role members analysis and assessment.

Operating System Security Analysis
Assesses the operating system, SQL Server files, directories, and registry settings to identify issues that could compromise SQL Server security.

Other Security & Compliance Tools from Idera

 SQL compliance manager
Capture, track, and audit key events and user activity

  • Enterprise, Server and Database Activity “Scorecards”
  • Set alerts based on thresholds
  • Create auditing templates, rules, event filters and alerts to address common auditing needs
  • Enhanced compliance reporting
  • New management console design, based on Microsoft Office 2007 “ribbon” motif
  • Create and save custom views of audit data, quickly filter and sort
  • Excluded from auditing activity to reduce unneeded audit data


Idera SQLsafe 4.7 is now available!

New features in SQLsafe:

Backup Mirroring

  • Quickly and easily write duplicate backup files to different locations during a single backup operation.

Policy Enhancements

  • Jobs created as a result of policy creation now use the SQLsafe command-line interface rather than the extended stored procedures.
  • Instance/database selection has been enhanced to allow for greater flexibility in the selection of which databases to include in the policy.
  • Policies now support striped and mirrored backup locations

Command-line Interface (CLI) Enhancements

  • Support for multiple databases and special wildcard keywords enable SQLsafe to backup more than a single database per single CLI command.
  • A new ‘Exclude’ parameter allows users to easily specify which databases to exclude from an operation.
  • Skip performing certain operations or ignore invalid parameter. For instance, SQLsafe will skip backing up databases that are ‘offline,’ will not perform T-Log backups of databases that are in simple mode, and will ignore the object level recovery flag if backing up system databases.

Tivoli Enhancements

  • SQLsafe now provides backup/restore capabilities for Tivoli Storage Manager 5.5.

SQLsmarts is Idera’s monthly newsletter for SQL Server Professionals.
We welcome your questions, comments or suggestions! Tell us more about how you’re using any of Idera’s products and we’ll send you a free Idera “SQL Server Superhero” t-shirt!  Email us: SQLsmartseditor@idera.com.

Thank you!

 


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