In this mini-series, we are looking at the differences between Get-WmiObject and Get-CimInstance. Future PowerShell versions no longer support...
database-tools
The Benefits of Increased Attention to the End-User Experience
An old and well-worn adage often heard in the world of business is that “the customer is always right.” This is not to be taken...
Solving the Problem of Complexity in Database Migration
One of the tasks that database teams engage in regularly is data migration. As platforms and environments evolve and become more complex, so do the...
Safely Using WMI in PowerShell (Part 1)
WMI (Windows Management Instrumentation) is part of any Windows operating system and a common and widely used way of getting information about a...
How to monitor tempdb, alert, and integrate with SCOM with SQL Diagnostic Manager for SQL Server.
SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager for SQL Server helps database administrators to find and fix SQL Server performance...
How to Optimize Your Database Performance with Automated Tuning
Optimizing database performance is one of the key roles of a database administrator. It can end up taking up the majority of their time and in some...
Keeping Your SQL Servers Healthy and Secure
It’s one of the DBA’s primary responsibilities to maintain the health and security of their SQL Servers. A typical SQL Server...
Converting Word Documents from .doc to .docx (Part 2)
Converting old Word documents to the new .docx format can be a lot of work, and in part 1 you learned the basic steps to automate conversion....
Why is MySQL So Popular?
There are a lot of choices for an organization to consider when selecting a relational database management system (RDBMS). In some cases, the...
Converting Word Documents from .doc to .docx (Part 1)
Converting old Word documents to the new .docx format can be a lot of work. Thanks to PowerShell, you can automate the conversion: function...
Fine-tune Infrastructure Monitoring for Better Results
Knowing what is going on in an enterprise’s computing environment’s infrastructure is important for several reasons. The most obvious...
How to customize the dashboard, monitor query-level waits, and monitor backups with SQL Diagnostic Manager for SQL Server.
SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager for SQL Server helps database administrators to find and fix SQL Server performance...