SQLdm Help - Idera SQLdm installation and deployment. Product Documents. Introduction to SQL Server Indexing. Introduction to SQL Server Indexing There are several areas of SQL Server that need to be configured and tuned to optimize database performance, one of these areas is SQL Server indexing. Webcast: SQL Server Watch full webcast here SQL Diagnostic Manager 24x7 SQL performance monitoring, alerting and diagnostics Performance monitoring for physical and VMWare databases Query monitoring to see the causes of blocks and deadlocks History browsing to find and troubleshoot past issues Predictive alerting with settings to avoid false alerts Database growth forecasting to minimize server sprawl NEW - SCOM management pack for integration with System Center Download a FREE Trial.
Resource Central by Idera. SQL Server Maintenance Plans - What they are and how to use them. You may have noticed the Maintenance Plans option in SQL Server Management Studio or maybe you have already setup a maintenance plan. In this webcast we are going to cover how to use maintenance plans and the various features that are available. We will cover what maintenance tasks should be in place for your SQL Servers such as index maintenance, backups, integrity checks, clean-ups, etc... We will look at how to setup scheduling, notifications, reporting and more. We will also talk about some of the limitations of maintenance plans and when it is a better idea to use other options for maintaining your databases.
Webcast: SQL Server SQL Diagnostic Manager 24x7 performance monitoring, diagnostics and alerting Download a FREE Trial. Building a Rock Solid SQL Server Backup Solution. Building a Rock-Solid SQL Server Backup Solution Murphy's Law - it's inevitable. Whether it's a hurried user, a query in the wrong environment, or a hardware failure, your data will be lost or corrupted eventually. That's why having a backup methodology that meets your organization's needs is a must. Webcast: SQL Server Backup SQL Safe Backup Hands-free backup across your SQL Servers Save Time - backup faster than native SQL with dynamic compressionReduce Failures - no disruption during network outagesAutomate - full, differential, and transaction log backupsEnterprise Management - scalable, centralized console & repositorySave Space - intelligent compression across SQL versionsInstant Restore - immediate access to backup data without waiting for a lengthy restore Download a FREE Trial.
4 Techniquies to Manage SQL Server Sprawl. Too many servers and not enough time! SQL Server has so many features and options that managing just one server can be challenging. Add to that all of the instances of SQL Server in your environment and the addition of new SQL Server instances without notice makes your job as a DBA and/or network administrator that much more difficult. In this webcast, we'll look at different things that can be done to help manage SQL Server sprawl to keep server and license management under control. Some of the items we'll discuss include: - Server consolidation - Multi-instanced servers - Identifying instances/databases that are used most - Security issues with consolidation - Ways to find SQL Servers on your network SQL Elements Hands-free backup across your SQL Servers.
Surviving The First Week As The New DBA. Surviving The First Week As The New DBA Whether you are an experienced DBA or a brand new one, the first week on a new job is stressful - new computer, new environment, new people, new reasons for doing or not doing things, it all adds up. Having a roadmap for the first week is a great way to speed up the process of getting settled in and it will help you manage your stress. We’ll cover some tips and tricks as we go through the top 10 big things you need to get done so you can move on to the good stuff! Webcast: SQL Server SQL Diagnostic Manager 24x7 performance monitoring, diagnostics and alerting Performance monitoring for physical and VMWare databases Query monitoring to see the causes of blocks and deadlocks History browsing to find and troubleshoot past issues Predictive alerting with settings to avoid false alerts Database growth forecasting to minimize server sprawl NEW - SCOM management pack for integration with System Center Download a FREE Trial.
Secrets of SQL Server Webcast: You Inherited a Database, Now What? Webcast Abstract You Inherited a Database, Now What? You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything.
At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to. Speaker - Tim Radney Tim Radney is a production DBA and manager for a large financial holding company and a Partner at Linchpin People LLC, author, and trainer. Webcast Requirements To view archived webcasts you may need to install the GotoMeeting codec for Windows Media Player.
Also, make sure your firewall does not block WMV files.