Featured Article(s)
Using Scripting to Help Manage your Databases
I was discussing my issue with this Windows Admin friend of mine, and he suggested that we use a script to get all the information that I needed. After speaking with him for only a few minutes, I was surprised at how much he claimed that he could do with a script that would connect to each server and gather information.
Do You Know What Your SQL Agent Is Doing? Really?
Probably not. That is, not unless you’ve used SQL Sentry Event Manager to give you a real-time, outlook-style look at your jobs and the work being done by SQL Server. The reason I say this is because it’s just not a simple thing to see what’s really going on with jobs, recurring jobs, overlapping executions, impact on your system and so-on. Heck, it’s near impossible to look at the jobs and say "which one is running longer than it should – what should I check on to get it better tuned?" Think this might be the case on your system? Get a free trial. Download it. Install it. Point it at your server. Within minutes you’ll know more about your jobs and the work going on than you thought possible. Get more information here. The trial is free and you’ll know instantly how it works on your system.
Webcasts Coming Up
We have some great webcasts coming along – make sure you save your spot.
Register: Unlocking SQL Server Infrastructure Consolidation
Consolidating SQL Server database servers represents an efficient path to infrastructure optimization, with significant benefits to IT. With the right approach, a consolidated framework cures low server utilization, assures availability and dramatically lowers the time and costs spent managing SQL Server environments. Join this webcast, presented by HP PolyServe Database Utility for SQL Server, and learn how a utility approach can enable you to: – Reduce by half the number of servers needed for SQL Server – Decrease storage requirements and software images for comprehensive cost reduction – Provide robust failover and DR services for every server, easily and cost effectively – Reduce the time required to manage servers, storage and O/S patches by as much as 75% – React to capacity changes in 30 seconds for real-time scalability Presented by HP PolyServe (www.polyserve.com)
> Register Now
> Webcast date 8/28/2007 12:00pm Noon Pacific
Register: SQL Server Optimization and Data Protection with Intelligent ISCSI SANs
More and more companies are deploying storage area networks or SANs as storage needs continue to proliferate. SANs deliver many unique capabilities that improve data protection, storage performance and scaling, and reduction in storage management time. Intelligent iSCSI SANs offer an affordable, enterprise-class choice in SAN technologies. We will review best practices in deploying SQL Server in an intelligent iSCSI SAN, and the resulting dramatic improvements in deploying, optimizing, backing up, and recovering SQL. Presented by EqualLogic (www.equallogic.com)
> Register Now
> Webcast date 8/29/2007 12:00pm Noon Pacific
Register: SQL Server 2005 Management Tools Overview
We’ll look into various management tools and capabilities for SQL Server 2005. Learn about everything from tracing to tuning and finding out how to better optimize and understand your systems. We’ll show what tools you have available and how they can be applied to managing your server. Sponsored by Quest (www.quest.com)
> Register Now
> Webcast date 9/5/2007 12:00pm Noon Pacific
Featured White Paper(s)
IT Director’s Reference Series: Practical Guide to Sarbanes-Oxley IT Internal Controls
Sarbanes-Oxley is the most comprehensive financial regulatory law in US history. It places responsibility for accurate and re… (read more)
Selecting the Right Change Management Solution
Frequent application updates, data migrations, service level requirements, and new compliance mandates mean your company need… (read more)
SQL Server 2005: Deployments and Tests in an iSCSI SAN
iSCSI SANs offer an alternative for building Storage Area Networks. Consolidating storage in a SAN offers storage management … (read more)