SQL Column Search
Identify Potentially Sensitive Data in SQL Server Tables.
Data Igloo
Faronics Data Igloo is a FREE utility which enables users to seamlessly and efficiently retain user data on machines protected by Deep Freeze. DATABASE TOOLS
PERFORMANCE TOOLS
Easily monitor and view the performance of both physical server and VMware or Hyper-V virtual server environments to get a complete view of SQL Server databases. View performance metrics and alerts for virtual machines and their related hosts including CPU, memory, disk usage, network etc. to get a complete performance picture of the SQL server environment.
Identify and monitor inefficient and poor performing SQL queries, batches, statements and stored procedures causing blocks and deadlocks, such as long or most frequent queries or queries consuming unusually high CPU or I/O. Thresholds can be configured on each individual server allowing for greater flexibility, and the interface makes it very easy to see the most costly queries by looking at individual query executions or query signatures.
Expert recommendations from IDERA SQL Doctor are now integrated into SQL Diagnostic Manager. Enhance performance and speed up problem resolutions with built-in tuning advice and best practices developed by SQL Server MVPs. These updated recommendations are integrated into analysis workflows and provide specific guidance to address problem issues including automatic corrective scripts and links to related online content to supercharge your SQL Server performance.
Dig deep into problematic queries with new query plan diagnostic capabilities. View high level query performance information across applications, databases and users with enhanced drill down capabilities into individual queries to view detailed SQL text, execution plan XML, and graphical views of execution plans.
Avoid false alarms with adaptive alerting functionality and set alert thresholds based on built-in historical statistical analysis of your server performance data.
Understand trends and view forecasts of your SQL Server environment to better plan for future needs and get a handle on SQL Server sprawl with database growth reporting.
Access SQL Diagnostic Manager from anywhere. Use any mobile device, such as iPhone, Android, Blackberry or Tablet to view real-time and historical SQL Server performance data. Plus, view or kill sessions, start/stop jobs and run queries to resolve or diagnose issues remotely while on-the-go.
View a demo of SQL Diagnostic Manager mobile.
Log in from anywhere and quickly check the status of monitored server instances to identify and diagnose issues. View the current status of monitored instances, drill down into single instance details, view the top occurrences of performance issues, and see a rollup of all active alerts. Customize your display with eighteen new widgets, enhanced heat map view, and query wait state visualizations. Create any number of individually configured dashboards to address the needs of the entire organization.
The SQL Diagnostic Manager Management Pack provides easy integration with Microsoft’s System Center Operations Manager (SCOM). The Management Pack propagates the current status, health and events of all monitored instances up to Operations Manager, allowing the DBA and IT Operations staff to share data at a higher level across their enterprise. The management pack is easy to install and does not incur any additional monitoring overhead.
Continuously monitor with real-time analysis of SQL Server and OS health and performance metrics across hundreds of SQL Servers enterprise-wide, including clustered configurations.
Easily monitor and view the performance of both physical server and VMware or Hyper-V virtual server environments to get a complete view of SQL Server databases. View performance metrics and alerts for virtual machines and their related hosts including CPU, memory, disk usage, network etc. to get a complete performance picture of the SQL server environment.
Manage the topology of high availability (HA) groups. SQL Diagnostic Manager monitors the performance of AlwaysOn Availability Groups that are set up and will send alerts as needed to ensure SQL Server is running on the designated node in the event of failover to a secondary replica. It can also run on an Availability Group as well.
Quickly identify and resolve tempdb contention and performance related issues with the tempdb monitoring and corresponding diagnostic views. Monitor and display Tempdb space and performance related information including: Read more...
Add an unlimited amount of custom counters in the monitoring process. These include any perfmon counters or any SQL queries (which can enable advanced application specific monitoring) that can be added to the list of already existing industry specified counters that SQL Diagnostic Manager will monitor. This information is also stored in the repository so a custom report can be created and stored to capture this data.
View overall waits on servers and queries and easily monitor the resources the SQL server and the queries are waiting on. Drill down to look at the detailed information on the wait they are experiencing, including which database, application, user, session, etc. is having the highest waits.
Monitor and alert on job success, failure, cancelled or retry events. The Jobs view displays all jobs, their last known status, complete job history and allows users to start/stop jobs.
Easily monitor performance problems with your mirrored or replication environments. The system also provides alerts and real-time diagnostic views to help with troubleshooting in these environments.
Collect OS performance metrics using WMI or OLE automation.
SQL diagnostic manager does not install any components, DLLs, scripts, stored procedures or tables on the SQL Server instances being monitored.
Comply with regulatory standards by auditing the most sensitive data contained in your databases, right down to the column level. Determine where sensitive data resides and add this data and columns to the audit wizard.
Track access and changes to databases, alert on failed log-ins, and customize alerts to notify of activities that could cause harm to your SQL Server environment.
Templates for PCI, SOX, HIPAA, and FERPA help you meet compliance requirements, A simple wizard helps add these compliance regulations to your audited SQL server objects with preset auditing settings aligned to over 16 regulatory citations.
Choose from over 25 pre-defined compliance reports, developed in partnership with auditing experts, that address security auditing & compliance reporting requirements. The Microsoft Reporting Services reports are available in the Console or can be easily deployed to SQL Reporting Services and customized if needed.
Keeping an eye on SQL Servers shouldn’t bring down your SQL enterprise. Using SQL Compliance Manager maintains a watchful eye on SQL Servers without performance impact implications.
Newly designed web dashboard offers quick views of key audit trail activities on SQL Servers from any web browser. Identify key compliance issues quickly and provide an easy access point to non-DBAs without giving access to the entire management console. Three primary views now available including:
The web-based views are also designed to work within IDERA’s Dashboard
Easily apply the right auditing settings to your servers and databases for Payment Card Industry (PCI), Family Educational Rights and Privacy Act (FERPA), Sarbanes Oxley Act (SOX), and Health Insurance Portability and Accountability Act (HIPAA) regulations. Extensive research is no longer required as you can simply define the objects and apply the (out-of-the-box) customizable templates.
Audit any combination of columns and track who has issued “SELECT” statements against any table whether they are end-users or privileged users. Additionally, you can be alerted when any combination of columns are accessed.
Audit data changes on any table so you can compare before and after data values resulting from inserts, updates and deletions.
A lightweight agent captures data from the SQL Server trace stream in real-time. The data collected can be streamed to the repository in real-time or in scheduled batches.
Guarantees the integrity of audit data by providing an immutable repository – any attempts at changing or tampering with the audit data can be detected. In addition, powerful self-auditing features capture and alert on all changes to auditing policies and data collection parameters.
Understand who has access to what and identify each user’s effective rights across all SQL Server objects. Drill down by user or group to shed light on areas where security vulnerabilities may exist or have a chance of developing. Use the report catalog to track vulnerabilities, security changes, and user entitlement over time.
View a complete history of SQL Server security settings and designate a baseline to compare against future changes, providing a valuable audit trail for forensic analysis.
SQL secure provides an Idera defined Level 2 security check for balanced intrusion protection that leverages MSBPA and CIS guidelines, and more. The security report card identifies top security vulnerabilities on your servers. Each security check is categorized as High, Medium, or Low Risk. You can drill into each security check to get more detail.
Analyze membership to powerful server roles and groups such as administrators, systems administrators, and security administrators to ensure the level of access is warranted. From a group, see the list of group members and select a member for further analysis. From a user, see the group memberships and drill upwards to view inherited permissions.
We’ve taken the security standards most companies are held accountable to and developed customizable templates to extract the information needed to satisfy security auditor’s requirements. Choose from templates for PCI, HIPAA, and FERPA which leverage guidelines from STIG and CIS.
Analysis of users’ effective rights shows you how and where each right is granted, making it easy to pinpoint exactly what changes need to be made in order to close security holes.
View SQL Server role members and sub-roles assigned and their effective permissions.
Browse and analyze all files, directories and registry settings associated with SQL Server and determine ownership as well as explicit and inherited security rights.
Analyzes password health of SQL Server logins and reports on when passwords are weak or blank which would cause a susceptible to intrusion situation.
Identify services, ports, protocols and API's that may allow SQL Server to be attacked by a malicious user. Enables you to understand and standardize which services you really need started or activated in your environment in order to reduce risk.
SQL secure does not install any components, DLLs, scripts, stored procedures or tables on the SQL Server instances being monitored.
Patented Instant Restore technology brings your database online immediately—virtually eliminating application downtime. This can save you huge amounts of time when getting back online in a disaster or searching old backups for a piece of lost data. Once online, your database acts as a fully functional database, supporting all read and write operations. SQL Safe Backup streams data from the backup file “on demand” to support applications and user requests while completing the restore operation in the background.
Automate backups with policies and eliminate the need for scripts or unnecessary overhead of backup and recovery processes experienced when performing backups natively. SQL Safe Backup lets you create backup policies for individual servers and server groups and apply them throughout the SQL environment. Set up automated full, differential, and transaction log backups for optimal flexibility and speed.
SQL Safe Backup’s patent-pending IntelliCompress2™ technology continually samples system resource usage and automatically adjusts the compression level to ensure the best compression given the state of the environment.
SQL Safe Backup greatly reduces the possibility of a failure due to a network problem. If a temporary network outage occurs, SQL Safe Backup will simply pause and pick up where it left off once the network is back online.
SQL Safe Backup is built with scalability in mind. Server sprawl happens. With SQL Safe Backup, you can save space, plan for growth, and see all the metrics that matter to you when it comes to backups--all in one easy to use central console.
SQL Safe Backup also provides integration with enterprise storage management solutions such as EMC Data Domain and IBM Tivoli Storage Manager to adhere to corporate standards as needed.
SQL Safe Backup provides an easy to use web UI accessible from any web browser. The dashboard view displays backup and restore issues, backup policies created and more from one consolidated view. Users can toggle between navigation tabs to perform backup tasks as needed. SQL Safe Backup is also designed to work within Idera’s Dashboard providing an integrated common console to use across Idera products.
Provides state of the art technology that continually samples system resources and automatically adjusts the compression level to produce the smallest backup in the fastest possible time.
Patent-pending Instant Restore technology brings your database online immediately—virtually eliminating application downtime. This can save you huge amounts of time when getting back online in a disaster or searching old backups for a piece of lost data. Once online, your database acts as a fully functional database, supporting all read and write operations. SQL Safe Backup streams data from the backup file “on demand” to support applications and user requests while completing the restore operation in the background.
Offers innovative IntelliRestoreTM graphical point in time recovery. Using a sliding time scale, choose a point in time, and SQL Safe Backup will automatically assemble all the backup components necessary to restore the database to the specified point in time.
SQL Safe Backup goes beyond typical OLR, providing support for all backup file types and recovery of more objects, including those from log backups and foreign key restraints. Backup data files are more complete including transaction log data which is typically ignored when restoring from typical OLR solutions.
Eliminate backup and restore failures due to temporary network outages by automatically pausing and then resuming from the point where the backup left off once the network comes back online.
Bring recovered databases online faster by allowing SQL Safe Backup to create missing SQL Server logins and resolve any orphaned database users.
Quickly and easily write duplicate backup files to different locations during a single backup operation.
Configure SQL Safe Backup policies to take the backup from preferred Availability Group replica. SQL Safe Backup can then restore the database even if the backups were taken from different Availability Group members.
SQL Safe Backup does not require the installation of any additional databases, DLLs, scripts, stored procedures, or tables on the SQL Server instances.
As index fragmentation increases over time, performance degrades, response times slow, and I/O suffers. SQL defrag manager performs an automated analysis of key metrics related to fragmentation to quickly pinpoint those areas where fragmentation is severely hindering performance, then triggers corrective measures.
Manage the defragmentation process through scheduling of jobs at the most optimal time and based on the size of the index. Automate remediation and run the defragmentation utility immediately or during off-peak hours.
Check the utilization of key system indicators prior to executing the defragmentation. This ensures that the policy is able to run as scheduled and avoid any potential system problems or application bottlenecks.
Most solutions don’t pay attention to the fill factor of tables, this can be a big drawback. With SQL defrag manager, users can manage index fill-factor settings and reduce splitting and shifting of pages as well as defrag job frequency.
The global dashboard displays all the SQL servers in your environment from one console, each database is color coded to reflect how much impact fragmentation is having on it, its databases, tables and indexes. You can easily sort to bring the items most in need of your attention to the forefront and take corrective action.
Defrag processes can be triggered by fragmentation percentage or scan density, and prioritized based on fragmentation level, scan density, or index size. Additionally, defrag operations can be limited to the “top x” worst indexes, or by a “hard stop” time.
Defragmentation policies can be applied at the server, database or index level to apply the same defragmentation management policy to multiple objects all at once. Changing the policy changes the defragmentation approach across all objects simultaneously.
Specify how much free space SQL Server should leave on an index page via the fill factor settings to limit page splitting and shifting. This helps you to decrease the frequency of your index rebuilds and improve the performance and availability of your SQL server applications.
Ascertain the utilization of key system resources prior to executing the defragmentation utility. If the metric is at a customer defined threshold, the execution of the defrag operation will either be delayed, prevented or run as scheduled.
SQL defrag manager does not install any components, DLLs, scripts, stored procedures or tables on the SQL Server instances being monitored.
Technology is a great enabler. It transforms and it allows educational institutions and business to achieve some pretty remarkable things. ITTree is passionate about the potential of technology that’s why we believe there’s never been a better time to create the future. For ITTree, being a South African Solutions and Services Provider is about one thing: building great customer relationships by making it simple to use technology to grow their success.
This privacy policy has been compiled to better serve those who are concerned with how their 'Personally identifiable information' (PII) is being used online. PII, as used in US privacy law and information security, is information that can be used on its own or with other information to identify, contact, or locate a single person, or to identify an individual in context. Please read our privacy policy carefully to get a clear understanding of how we collect, use, protect or otherwise handle your Personally Identifiable Information in accordance with our website.
Our website is scanned on a regular basis for security holes and known vulnerabilities in order to make your visit to our site as safe as possible.
We use regular Malware Scanning.
Your personal information is contained behind secured networks and is only accessible by a limited number of persons who have special access rights to such systems, and are required to keep the information confidential. In addition, all sensitive/credit information you supply is encrypted via Secure Socket Layer (SSL) technology.
We implement a variety of security measures when a user places an order enters, submits, or accesses their information to maintain the safety of your personal information.
All transactions are processed through a gateway provider and are not stored or processed on our servers.
You can choose to have your computer warn you each time a cookie is being sent, or you can choose to turn off all cookies. You do this through your browser (like Internet Explorer) settings. Each browser is a little different, so look at your browser's Help menu to learn the correct way to modify your cookies.
If you disable cookies off, some features will be disabled It won't affect the users experience that make your site experience more efficient and some of our services will not function properly.
However, you can still place orders .
Google's advertising requirements can be summed up by Google's Advertising Principles. They are put in place to provide a positive experience for users. https://support.google.com/adwordspolicy/answer/1316548?hl=en
We have not enabled Google AdSense on our site but we may do so in the future.
When it comes to the collection of personal information from children under 13, the Children's Online Privacy Protection Act (COPPA) puts parents in control. The Federal Trade Commission, the nation's consumer protection agency, enforces the COPPA Rule, which spells out what operators of websites and online services must do to protect children's privacy and safety online.
We do not specifically market to children under 13
.The CAN-SPAM Act is a law that sets the rules for commercial email, establishes requirements for commercial messages, gives recipients the right to have emails stopped from being sent to them, and spells out tough penalties for violations.
We collect your email address in order to:
To be in accordance with CANSPAM we agree to the following:
If at any time you would like to unsubscribe from receiving future emails, you can email us at info@ittree.com and we will promptly remove you from ALL correspondence.
If there are any questions regarding this privacy policy you may contact us using the information below.
https://www.ittree.com
Faronics Customer Center
idera Support Portal
