Fix broken WMI provider in SQL Server
Being unable to open SQL Server Configuration Manager if often caused by a corrupt or removed WMI provider for SQL Server. This post explains how to resolve this.
Tag SQL Server
Read MoreFix broken WMI provider in SQL Server
Update SQL Server Management Studio (SSMS) automatically
The fire-and-forget method to update SQL Server Management Studio (SSMS) automatically by uninstalling any installed version and downloading & installing the newest available version from Microsoft.
Monitor SQL Server and databases in depth using Zabbix
Monitor Microsoft SQL Server, databases and performance with Zabbix, PowerShell, Performance Counters and WMI. Keep SQL Server and databases in top shape and performance up! In this post I show you how you can use Zabbix to monitor those important aspects for database administrators (DBA).
Install SQL Server cumulative updates silently
Learn how to install SQL Server cumulative updates (CU) silently using PowerShell opposed to the cumbersome task of running the GUI installer.
How to install Microsoft’s SQL Server Driver for PHP
This post walks you through the steps necessary to install the SQL Server driver and SQLSRV extension for PHP 7+, on Windows Server IIS of course.
Connect to MS SQL Server with PHP 5.3+
As of PHP 5.3.2 you have to use the SQLSRV API functions to connect to an Microsoft SQL Server database from PHP. For example, use sqlsrv_connect() to create a connection resource and open a connection. Learn how to connect to a Microsoft SQL Server database using PHP 5.3+ and SQLSRV.