yes-tool-blog

[yes-tool-blog]

SQL Inventory Manager

View your SQL Server inventory - know what you have where & who owns it

Auto-discover any new servers installed, to better manage server sprawl

Set tags to better organize servers and databases across the enterprise

Perform health checks to monitor server operation and capacity

Quickly deploy and access from anywhere via web-based and agentless UI

Discover all SQL Servers Across the Enterprise

Scan the network to find all your SQL Servers and databases including databases on AlwaysOn Availability Groups. Scan by domain, IP address ranges, and/or import your own server lists from excel or CSV files. Flexibly schedule discoveries to locate newly added servers daily, by specific days of the week &/or at particular times of day. Create an inventory report for all managed, unmanaged, and decommissioned instances within the SQL Server environment. In addition users can discover BI services (SSRS, SSIS, SSAS) running in their environment.

Get Complete Visibility

See all those servers lurking that you may not have known existed including SQL Express instances. Users can manually add or set auto-registration to add discovered instances to SQL Inventory Manager for monitoring and get recommendations to bring the instances up to maintenance. Capture the SQL licensing details for each instance in a consolidated report.

Monitor and Manage Inventory

Go beyond Microsoft’s Assessment Planning (MAP) toolkit for SQL Server inventory tracking. Automatic discovery and a Global Dashboard provide high-level visibility of all server inventory. Learn what you have, which servers are improperly configured and what actions might need to be taken for instances competing for memory and resources. Also compare your current SQL Server builds with the latest build from Microsoft to determine if you have the latest patches or versions.

Establish Tags to Group and Analyze Inventory

Create tags at the server, instance and database levels to organize by owner, location, function or other categories to suit different needs. You can even mark servers as “unmanaged” to revisit for follow-up later. A tag cloud displays on the Dashboard that groups the tags created to quickly visualize the size of those groups comparatively by prominence or importance.

Run Health Checks and Receive Availability Alerts

Perform regular health checks on monitored servers to gauge adherence to configuration best practices. Receive email alerts for key server indicators such as when servers are down, whether a database has ever been backed up or early warning when you are about to run out of space. Generate a customizable health check report to consolidate all active health check findings. Plus view the findings in a simple list with recommendations for improvement from SQL Server experts.

Deploy Quickly and Scale Out as Needed

Agentless, low impact design offers download, install and use in under 5 minutes with no other modules or installation necessary on monitored servers. A stand-alone web application with no need for IIS provides a simple sign on to login and use remotely from anywhere. Plus it is designed to scale up as you grow, capable of monitoring and managing thousands of databases running on DEV, PROD, QA, TEST or SQL Express instances.

[yes-tool-blog]

PowerShell Scripts for SQL Server – Free Download

132 sample PowerShell scripts to manage SQL Server objects

Scripts to initialize SQL Server’s PowerShell module

Scripts for Database Engine, and for Analysis, Integration and Reporting Services

Support for SQL Server 2016 and 2017, and Windows Server 2016

30 New scripts for Center for Internet Security (CIS) benchmarks

Database Engine

Start and stop services

Connect to an instance, and get connection information

Manage databases, and script out databases

Set adaptive query processing

Manage policies and error logs

Manage firewall rules, logins, assemblies, backups, and agent jobs

Get extended event information

Center for Internet Security (CIS) Benchmarks NEW

Surface area reduction

Authentication and authorization

Password policies

Auditing and logging

Application development

Start and stop SQL Server browser service

In-memory Databases

Get overall memory utilization

Get size on disk

Get detailed utilization by table

Get checkpoint size

Query Store

Enable and disable Query Store

Get information about query plans in Query Store

Get activity status

Set maximum data retention size

Set automatic tuning of queries via Query Store

General Utilities

Get list of registered instances

Ping instances and get their status

Set aliases for instances

Get advanced properties by service

Add service account to local security privilege

Get and set power plans

Analysis Services

Connect to an instance, and get connection information

Get a list of databases

Backup databases, manage backup retention, and restore databases

Integration Services

Start and stop services

Connect to an instance, and get connection information

Manage packages and catalogs

Publish projects

Reporting Services

Start and stop services

Connect to an instance, and get connection information

Backup and restore encryption keys

Get configuration information

Get event log information

[yes-tool-blog]

Achieve 24/7 SQL Monitoring SQL Diagnostic Manager

General

Microsoft Windows: XP SP2+, Vista SP2+, Server 2008 SP2, 7, Server 2008 R2, Server 2012, 8, 8.1, Server 2012 R2, 10, Server 2016; 32-bit and 64-bit

Client browser: Microsoft Internet Explorer 7.0+

Console

Microsoft .NET Framework: 4.0+ (4.6.2 recommended)

Monitor resolution: 1280 x 1024 with small text

Services

Microsoft .NET Framework: 4.0+ (4.6.2 recommended)

Repository

Microsoft SQL Server: 2005 SP1+, 2008 or later, 2008 R2, 2012, 2014, 2016, 2017 (Windows and Linux); Standard and Enterprise Edition

Monitored SQL Server Instances

Microsoft SQL Server: 2000 SP4+, 2005 SP1+, 2008+, 2008 R2, 2012, 2014, 2016, 2017 (Windows and Linux); Standard and Enterprise Edition

Microsoft SQL Server Express: 2008, 2008 R2, 2012, 2014

Microsoft Azure SQL Database

AWS RDS SQL Server

SQL Diagnostic Manager does not install any components, DLLs, scripts, stored procedures, and tables on the monitored SQL Server instances.

Mobile Requirements

Service and web server: Microsoft Windows: Server 2003 SP2, Vista SP1+, Server 2008, 7, Server 2008 R2, Server 2012, 8, 8.1, Server 2012 R2, 10, Server 2016

Microsoft .NET Framework: 4.0+ (4.6.2 recommended)

Repository: Microsoft SQL Server: 2005 SP1+, 2008, 2008 R2, 2012 , 2014, 2016, 2017 (Windows and Linux)

Web server: Microsoft Internet Information Services: 7.2+

Mobile and Desktop Devices

Mobile device: Google Android v2.1+, Apple iOS v3.2+, BlackBerry RIM v6.0+, Microsoft Windows Phone 7+

Desktop web browsers: Microsoft Internet Explorer 9.x+, Google Chrome, Mozilla Firefox, Microsoft Edge

Cloud

SQL Diagnostic Manager runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports Microsoft SQL Server instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2). It supports cloud databases (that is, Microsoft Azure SQL Database and AWS RDS SQL Server).

[yes-tool-blog]

Achieve 24/7 SQL Monitoring SQL Diagnostic Manager

Monitor performance for physical, virtual, and cloud environments.

Monitor queries and query plans to see the causes of blocks and deadlocks.

Monitor application transactions with SQL Workload Analysis add-on.

View expert recommendations from SQL Doctor to optimize performance.

Alert predictively with settings to avoid false alerts.

View summary of top issues and alerts with the web console add-on.

Monitor Performance of Physical, Virtual, and Cloud Environments

Easily monitor and view the performance of physical servers, virtual servers (VMware and Hyper-V), and cloud 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.

Monitor Performance of Queries

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.

*NEW* Monitor Application Transactions with SQL Workload Analysis Add-on

Now available in the Pro version of SQL Diagnostic Manager Monitor query waits, sample SQL continuously, drill down into transaction analysis, view recommendation to improve queries, tune statement plans, and resolve locks and latches with the SQL Workload Analysis add-on. Isolate application problems and receive recommended remedies. Combine the operational monitoring from SQL Diagnostic Manager and transactional monitoring with SQL Workload Analysis to view instance properties and alerts, receive prescriptive recommendations for operational diagnosis, analyze workloads for transactional diagnosis, and arrive at a comprehensive root cause analysis.

View Expert Recommendations from SQL Doctor

View expert recommendations from IDERA’s SQL Doctor that are an integral part of SQL Diagnostic Manager at no additional cost. Enhance performance and speed up problem resolutions with built-in tuning advice and best practices developed by SQL Server MVPs. Analysis workflows embed this valuable information. It provides specific guidance to address problem issues including automatic corrective scripts and links to related online content to supercharge SQL Server performance.

Alert Predictively and Avoid False Alerts

Avoid false alarms with adaptive alerting functionality. Set alert thresholds based on built-in historical statistical analysis of server performance data. Present a percentage of likelihood that various events may occur later in the day based on past behavior trends via the embedded heuristic analysis of event trends and behaviors. Be better prepared to diagnose, drill down, and resolve an issue quickly and efficiently.

View Summary of Top Issues and Alerts with Web Console Add-on

Log in from anywhere and quickly check the status of monitored server instances to identify and diagnose issues with the web console add-on. 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.

[yes-tool-blog]

Continuous Monitoring

Today, the clear direction of government IT management is continuous monitoring or protective monitoring of infrastructure. SolarWinds IT solutions serve multiple purposes simultaneously and are able to generate a vast number of customized views from the same streams of data. For example, an IT operations team requires views into data that provide insight on performance, availability, and reliability. On the other hand, a cyber security team needs to look at the same data with a focus on security, compliance, and vulnerability.

SolarWinds has software that can Collect Once, Report Many, which gives IT, Information Assurance, and security departments the unique functionality they each need, from a single, cost-effective set of tools.

[yes-tool-blog]

Government Network Operations

In mission-critical government environments, downtime is not an option. SolarWinds network management and monitoring software alerts you to issues before they become a problem. Our automated network tools analyze traffic, discover and map devices, manage and back up configurations, and monitor performance, including VoIP and network quality—and much more.

Concerned about security? With our software you can track IP addresses, find and banish rogue devices, and manage firewall rules. And everything can be done from a single pane of glass. With over 300 built-in automated compliance reports and real-time alerts, it’s never been simpler to maintain your IT operations and deliver on your agency’s mission.

[yes-tool-blog]

IT Management and Monitoring Solutions for Government

SolarWinds eliminates complexity from every IT process imaginable: network operations, resource consolidation, legacy product migration, continuous monitoring, cyber security, even compliance, so you can do more with less. Our products are easy to buy, install, use, scale, and maintain, yet still provide the power to resolve any IT management problem.

Our government clients use SolarWinds IT solutions everywhere: the data center, the classroom, and in the field.

Defense

U.S. Army, U.S. Air Force, U.S. Navy, U.S. Marine Corp, IC, and DoD Agencies.

Civilian

U.S. Census Bureau, U.S. Department of Justice, Oak Ridge National Laboratory, Sandia National Laboratory, U.S. Department of Treasury, U.S. Department of Veterans Affairs, and more.

National/Central

National Health Service, European Parliament, Health and Social Care Information Centre, Republic of Turkey Ministry Of Health, NATO Support Agency, and more.

State, Local & Education

The State of Texas, The City of Indianapolis, Harrison College, University of California, Berkeley, and more.

[yes-tool-blog]

Salesforce consumer

Consumer Packaged Goods CRM solutions from Salesforce are ushering in and advancing a new industrial revolution — one being driven by a need to deliver product faster and get closer to the consumer.

As CPG companies figure out how they deliver exciting, innovative consumer products to their customers, the expectations of companies and consumers is at an all time high.

That’s why more and more CG companies are relying on Salesforce CRM optimized for consumer goods. It’s the new, connected age of consumer goods.

[yes-tool-blog]

Idera Er/Studio

Create effective data models to build a business-driven data architecture

Document and enhance existing databases to reduce redundancy

Implement naming standards to improve data consistency and quality

Effectively share and manage data models across the enterprise

Map data sources and trace origins to enhance data lineage

Design Effective Data Models

Data modeling helps organizations make better business decisions with accurately interpreted and rapidly changing data. Whether you are creating a new model from a conceptual diagram or reverse-engineering from an existing database, IDERA ER/Studio Data Architect is a powerful tool that helps you easily and effectively design and manage your logical and physical data models.

Build a Business-driven Data Architecture

Data architects need to ensure that everyone in the organization understands what the data is and can explain it in business terms. Data Architect provides an easy-to-use visual interface for data modeling professionals to document, understand, and publish information about data models and databases so they can be better harnessed to support business objectives.

Reduce Redundancy

Import and reverse-engineer content from multiple data sources into logical and physical data models, and integrate the elements into reusable constructs with an enterprise data dictionary. Leverage rich text editing along with relationship color inheritance to enhance model content and appearance.

Improve Data Consistency and Quality

Assign a naming standards template to your model, submodel, entities, and attributes. Those naming standards will be applied automatically between the logical and physical models, simplifying the data modeling process and ensuring consistency between models.

Share and Manage Enterprise Data Models

The multi-level design layers in ER/Studio Data Architect allow for the accurate visualization of data, which promotes communication between business and technical users. Manage model version control and share data assets in the repository. Create and track tasks and view changes to data models aligned to agile workflows.

Enhance Data Lineage

Universal mappings provide links between instances of the same concept across models and databases to enhance traceability even further, and data lineage shows the connections between databases, models, metadata, and data sources for traceability. Organizations can obtain a clear understanding of where their data originated, where it is used, and what the data actually means.

ER/Studio Data Architect is available in two editions: The standard ER/Studio Data Architect edition is the feature-rich tool with extensive data modeling capabilities across multiple relational and big data platforms, along with import bridges for other common modeling tools. The ER/Studio Data Architect Professional edition also includes the model repository for version control and agile change management.

Want to see which version of ER/Studio Data Architect is right for you or looking for next level of collaboration with business glossaries and metadata?

[yes-tool-blog]

Bold 360

Bold360 is an intelligent customer engagement solution that provides businesses with actionable customer insights to efficiently deliver richer and more personalized experiences in real time.

Bold360 provides the digital channels and tools needed to engage and support consumers as they seamlessly move across self-service and agent-assisted channels like chat, email, messaging and social, while presenting agents with the full context of those interactions through a single pane of glass. Bold360 improves contact center efficiencies and delivers better customer experiences that build loyalty, advocacy and grow share of wallet. For more information, visit www.bold360.com.