Microsoft’s PowerShell is a task-based command-line shell and scripting language. It is an automation platform and scripting language that...
posts
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
May #SQLChat – Designing Data Warehouses
IDERA’s #SQLChat is back! Join IDERA (@Idera_Software) and host Leslie Andrews (@landrews5807) on Wednesday May 29 at 11AM CT for...
How to be a better accidental database administrator
Data is more important than ever to business success. As data demands continue to skyrocket, many database administrators are given responsibilities...
Do not leave your most valuable backups to chance
Backing up SQL Server databases is one of the most critical tasks that database administrators perform in their SQL Server environments every day....
DevOps and the DBA
Modern application development teams are aligned to deliver software using agile methodologies and a DevOps approach. Agile and DevOps are not the...
Enjoy May Day without “mayday” – protect your SQL Server data
May 1st is traditionally celebrated as “May Day” to welcome the return of spring. In Central Texas, we often get a lot of rain in the...
Selected strengths of SQL Diagnostic Manager
In many organizations today, Microsoft SQL Server supports applications that are critical to organizations where downtime and poor performance has...
Transaction Tracking res ipsa loquitur
"Res ipsa loquitor" means it speaks for itself. End-user transaction monitoring is Precise's specialty. This screen shows...
Real User Management, transaction tracking
"Res ipsa loquitor" means it speaks for itself. End-user transaction monitoring is Precise's specialty. This screen shows a list of the...
Why should you learn about DevOps?
DevOps integrates software development and IT operations into a single continuous process that delivers significant benefits to common business...
The Impact of Cloud on DBA
The DBA is the information technology professional responsible for ensuring the ongoing operational functionality and efficiency of an...
Database Backup & Restore – Free Resources
World Backup Day This year, World Backup Day was on Sunday, March 31, 2019. Per my blog post from two years ago “Guidelines for Backup and Recovery...
How to better understand SQL indexing to improve SQL Server performance
Indexes in SQL Server databases can have the most significant positive impact on the performance of SQL Server instances, or they can be the worst...
How to tune SQL Server in the cloud
As organizations migrate their databases to the cloud, database administrators need to consistently manage databases on-premise and in the cloud...
Organizational changes and the need to inventory SQL Server environments
In recent headlines, we have heard or seen the news on company mergers in different sectors of the economy. “Cigna and Express Script”...
How to backup and restore SQL Server in the cloud
As organizations migrate their data to the cloud, database administrators need to consistently manage data on-premise and in the cloud with existing...
Monitoring Windows Services with SQL Diagnostic Manager
As we all probably already know, SQL Diagnostic Manager is a powerful performance monitoring and diagnostics solution that proactively alerts...
Precise for Oracle Performance
Precise AdminPoint is available as a browser agnostic interface. Open Precise in Chrome!, Firefox!. Precise Applications will be...
SQL Diagnostic Manager 10.4 Preview
SQL Diagnostic Manager 10.4 will be available soon and it currently available for our beta customers at...
Methods for Handling Big Data for Healthcare
Healthcare organizations need methods to overcome challenges to achieve the data-driven financial and clinical objectives. Such approaches include...
What has happened with GDPR in the last 9 months?
Largest Fine To Date Google recently made the news with a $57M (50M Euro) fine imposed by the French Regulatory building, CNIL. The case against...
How to Manage Complex Database Environments
Every year, data becomes increasingly critical to the organization. And data becomes even more complicated to manage and keep secure. The growth in...
Properties of Big Data for Healthcare
Healthcare organizations must consider the essential properties of the analytics for big data that when commencing significant projects for...
Handling the Complexities of Analytics for Big Data for Healthcare
Analytics for big data rapidly has become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions...
Monitor the performance of SQL Server in the hybrid cloud
As organizations migrate their databases to the cloud, database administrators need to consistently manage databases on-premise and in the cloud...
Resolutions for your Data Management Strategy
As 2019 has just begun, it’s a good time to assess what you accomplished last year and what goals to set for the new year. It's also a great...
Using SQL Secure to monitor SQL Instances and Databases running on Azure
As companies migrate more and more applications and data to the cloud using services like Azure and Amazon, it is important to ensure that the SQL...
How to troubleshoot locking problems in SQL Server with Dynamic Management Views
Database professionals are often called upon to investigate performance problems related to locking, but most investigations into locking rarely go...
Precise for Sybase monitoring & performance
Precise for Sybase builds a history of activity showing resource consumers. SQL statements are correlated to stored producers, logins, and...
What to do when the SQL Server service does not start
The executable process that is the SQL Server Database Engine is called the Database Engine service. The Database Engine service is an executable...