2006 Year End Wrap-Up:
SQL Server Tools from Idera

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

It’s been a banner year for Idera! In 2006, Idera has continued to bring the most innovative tools for SQL Server management to the market – with the ultimate goals of making the lives of SQL Server database administrators easier, reducing time wasted on tedious administrative tasks, and helping to keep SQL Servers running without fail, in compliance, and performing at optimum levels.

• Four completely new tools for SQL Server management that are unlike any others on the market. These include:
  • SQL change manager
  • SQLscaler
  • SQL mobile manager
  • SQLsecure
• Major updates to our product line – including full SQL Server 2005 compatibility
• Added 800 new customers
• Distributed over 30,000 licenses worldwide

Below is a summary of the key enhancements and new products we’ve introduced over the past year. Why not take a moment to make sure that you’ve got the most recent version or download a free 14 day evaluation copy of our new solutions?

NEW! SQL change manager
Enterprise Change & Schema Management

Current version 1.1

• Track, monitor, and manage database schema changes across the enterprise
• Compare schemas to verify success of schema change roll-out
• Roll-back schema changes easily
• Detect unauthorized schema changes
• Recover from schema corruption
• Keep a trail of change activity for auditing and compliance

Try it now >>

NEW! SQLscaler
Load-testing, Migration & Consolidation Planning

Current version 1.1

• Load & Scalability testing
• Server consolidation planning
• Migration planning
• Workload capture/replay
• Database inflation using the characteristics of your real-world data
• Test automation and scheduling
• Reporting and analysis of test results

Try it now >>

NEW! SQL mobile manager
Remote Monitoring & Administration

Current version 2.4.12

• Manage SQL Servers from a Windows Mobile device
• See real-time performance metrics
• Create custom alerts
• Take action to quickly fix issues

Try it now >>

NEW! SQLsecure
Security Analysis & Auditing

Current version 1.1

• Ensure SQL Server data and security model integrity
• Satisfy audit and compliance requirements
• Perform entitlement reporting

Try it now >>

SQL diagnostic manager
Real-time Performance Monitoring, Diagnostics & Alerting

Current version 4.5

• Operating System metrics collection and alerting
• Listing of the most frequently run queries
• Maintenance Mode to turn off data collection and alerts during maintenance windows

Chosen best SQL Server Performance Monitoring Solution in the 2006 SQL Server Magazine Editor’s Choice Awards – Platinum Award

Try it now >>

SQLsafe
High Performance Backup & Recovery

Current version 3.2

• Support for backing up databases on Itanium 2 and x64
• Customizable grooming of backup archives
• Maintenance plan conversion wizard
• Improved performance when writing to a network share

Try it now >>

SQL compliance manager
Auditing & Continuous Compliance

Current version 2.1

• Audit event filters to omit unwanted SQL events in the audit trail
• Policy-based Alerting
• Expanded Reporting
• Auditing of User-Defined events
• Enhanced Tamper Resistance
• Command-line automation

Try it now >>

"We had a critical, urgent need to audit admin level accounts in our SQL environment to be compliant with SOX requirements. SQL compliance manager tremendously exceeded our expectations providing ease of setup, very granular configuration options, excellent real-time activity monitoring and a great variety of reporting options. The email alerts also make us aware of login activity no matter where we are. This provides a comfort level to upper management that was not possible prior to our implementation of SQL compliance manager."

Jon McLendon Sr.
Senior Database Administrator
Colonial Properties Trust
Birmingham, Alabama

2007 Live Webcast Series: SQL Server 2005
SQL Server Upgrade Advisor
Thursday, January 18, 2006
11:30 AM – 1 PM Central | 12:30 PM – 2 PM Eastern | 9:30 AM – 11 AM Pacific

Are you confused about how the new security permission model works in SQL Server 2005? Are you planning your migration and need to make sure that the security around your data is correct? This Web seminar – hosted by Idera, Solid Quality Learning & SQL Server Magazine – will show you how you can ensure that only authorized users have access to your SQL Servers and that your security model is solid.

Register Now

Presenter: Scalability Experts
Hosted by: Idera

With all of the new features and benefits included with SQL Server 2005, your organization will want to take advantage of these as soon as possible. There is more than one path that may be taken when stepping up to SQL Server 2005. Through June 2007, Idera & Scalability Experts will be hosting a new lunch webcast series that will cover various topics related to SQL Server 2005 so that you can determine the best way to plan, implement and maintain an upgrade.

Our first in the series will be on Thursday January 18, 2007 and will cover SQL Server Upgrade Advisor. This is a new free tool in SQL Server 2005 which will analyze your SQL Server environment and report to you the issues that need to be addressed. Grab lunch (or brunch if you're on the West coast) and join us for a discussion of SQL Server Upgrade Advisor, how to use it, and to discuss possible upgrade paths. You’ll also learn more about how Idera's tools for SQL Server can help to streamline your migration to SQL Server 2005.

Register Now

Space is limited for the live version of this webcast, so register today! *

* This webcast will also be archived on www.idera.com 24 hours after the event so that you may view it on demand if you are not able to make the live webcast.

Announcing SQL defrag manager:
Automated SQL Server Defragmentation

See it live in January!

SQL defrag manager is a new product from Idera that automates defragmentation processes on production SQL Servers – helping organizations drastically improve server performance and optimize disk I/O while also reducing administrative effort and downtime. SQL defrag manager automatically picks the best time to analyze fragmentation and the best approach to defragment based on user-defined criteria and analyses of historical data stored in a central repository. SQL defrag manager shows all fragmentation activity in real-time, quickly exposing fragmentation hot spots. DBAs can then quickly view reports and metrics from the enterprise-level down to individual indexes to check the success of fragmentation efforts. SQL defrag manager is simple to install, configure and use across all SQL Servers, from one server to an enterprise-scale implementation.

SQL defrag manager will be released in March 2007, but you can see it live starting in January! Click below to sign up for a live demonstration of SQL defrag manager, or better yet, participate in our beta testing!

Register for a live demonstration of SQL defrag manager
Register for the SQL defrag manager beta program

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
 

Visit Idera at these upcoming events:

• Minnesota SQL Server User Group
  Jan 16, 2007
  REGISTER HERE
   
  
• Northern Virginia SQL Server User Group Meeting
  Jan 22, 2007
  REGISTER HERE
   
  
• GTC Southwest –
  Austin, TX
  Jan 31 – Feb 1, 2007
  REGISTER HERE

Buy the Book Online