|
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. |
|
|
|
|
|
|
|
|
|
|
 |
|
SQL Server Resources from Idera |
| |
NEW Whitepaper:
“SQL Server Defragmentation Explained ”
Download your copy now!
This technical white paper will help you understand SQL Server fragmentation and the performance benefits you can gain on your SQL Servers by continuously monitoring and managing index fragmentation.
|
|
|
Tradeshow:
GTC West
Austin, Texas
January 30 – 31, 2007
www.gtc.com
|
|
|
|
|
|
| |
|
|
|
Year End Wrap-Up
- Our gift to you: SQL job manager free until December 31, 2007
- Just announced: SQL mobile manager now available for BlackBerry devices
- New whitepaper: “SQL Server Defragmentation Explained ”
- 2007 Year End Wrap-Up: SQL Server Tools from Idera
New SQL job manager will streamline the process of scheduling and managing jobs across all SQL Servers in your environment—saving you hours of time, administrative overhead, and headaches! In a nutshell, SQL job manager makes it easy to view all jobs in your environment, as well as move, adjust and track the status of jobs. You’ll be able to reduce job failure rates while also ensuring the performance and availability of SQL Servers.
- View & manage all SQL Server jobs from a central point of control
- Easily find & fix job contention, simply drag & drop to rearrange or reschedule jobs
- Drag & drop jobs across servers to level workloads
- Quickly identify failed or runaway jobs with an ’at a glance’ view of job history
- Requires no agents
Just announced: SQL mobile manager for BlackBerry mobile devices!
Monitor & manage SQL Servers anytime, anywhere!
Recently awarded the “Best of Connections 2007” at DevConnections in Las Vegas, SQL mobile manager allows DBAs to monitor, administer and manage multiple SQL Servers from a Windows Mobile Device—and now from a BlackBerry Mobile Device!
- Receive immediate alerts of SQL Server issues
- Be the first to know of long running jobs, failed jobs, blocking processes, stopped services, and more
- Monitor SQL Servers: track users, processes, batches, transactions, CPU/memory utilization, network traffic, disk I/O, and more—in real-time or over-time
- Start or stop a job, agent, or service or reboot a server
- Track SQL Server agent and job status
- View database and operating system event logs
- Check SQL Server hardware and software configurations
- Execute T-SQL commands and batches
- ... And more!
|
|
| |
|
New Whitepaper: “SQL Server Defragmentation Explained”
As the data in Microsoft SQL Server tables changes, their indexes change. Over time, these indexes become fragmented. This fragmentation will adversely affect performance. This technical white paper provides information to help you understand the detailed mechanics behind fragmentation. It will also help you understand the methods and approaches for performing defragmentation so you can improve your SQL Server’s performance.
2007 Year End Wrap-Up: SQL Server Tools from Idera
In 2007, Idera has continued to bring the most innovative tools for SQL Server management to the market. We’re always striving to make your life easier by helping you reduce the time you have to spend on tedious administrative tasks, helping you keep SQL Servers running smoothly, and hopefully making YOU a SQL Server Superhero!
Below is a summary of the key enhancements and new products we’ve introduced over the 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?
SQL diagnostic manager
Monitor, diagnose and analyze performance
Current Version: 5.0 SP2
Key features added in 2007:
- New three-tier architecture providing higher performance, scalability and flexibility
- New more powerful and intuitive management console interface
- Rapid and flexible notification, alerting & reporting
SQLsafe
High Performance Backup & Recovery
Current Version: 4.6 SP2
Key features added in 2007:
- Object Level Recovery
- Support for Microsoft Vista
- Full Support for 64-bit Environments
SQL compliance manager
Capture, track, and audit key events and user activity
Current Version: 3.0
Key features added in 2007:
- Enterprise, Server and Database Activity “Scorecards”
- Set alerts based on thresholds
- Create auditing templates 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
- Trusted User auditing adds to an already deep rule set and further enhances ERP support.
SQLsecure
Analyze user rights and permissions
Current Version: 1.2
Key features added in 2007:
- SQL Server Security Scorecard: analyzes five critical security risks
- Enhanced permissions analysis: See exactly how and where user rights were granted
- Windows Account Analysis: View all logins on the target server, as well as any Windows Accounts or Groups
- Enhanced Reporting: 10+ pre-defined reports support compliance and standards reporting requirements, such as ISO and COBIT
- Enhanced Collection Wizard: Customize the security data that is collected on each SQL Server
SQL defrag manager
Automate & optimize SQL Server defragmentation
Current version 1.2
Product released in January 2007:
- Automatically analyzes index fragmentation levels
- Identifies fragmentation “hot spots”
- Takes action to defragment indexes automatically, or at user discretion
- Provides central management and detailed reporting
SQLscaler
Test database scalability & performance
Current version 2.5
Key features added in 2007:
- DTS to SSIS Migration Testing
- Analysis services testing
- Reporting services testing
- Customized profiler trace testing
- Simulation of multiple workload types at the same time
- Pre-test checks
- Support for 64-bit systems
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! |
|
