Microsoft

AX Performance – Analyzing key SQL Server configuration and database settings

In the previous post in this series, I provided some T-SQL scripts that can check key settings and highlight possible issues you need to address. This post aims to provide some feedback and ...
GitHub

install-sql-server-with-powershell-desired-state-configuration.md

Have you ever gone through the SQL Server installation interface just by selecting the same buttons, entering the same information, and not giving it a second thought? The installation finished, but ...
Microsoft

Microsoft® SQL Server® 2014 Feature Pack

Microsoft SQL Server 2014 Feature Pack は、Microsoft SQL Server の機能を拡張する個々のインストール パッケージをまとめたものです。以下の最新バージョンが含まれています。 注: システム要件は Feature Pack に含まれるインストール パッケージによって異なります。
Ars Technica

Migrating Clustered SQL to stand-alone instance on a VM

1. Change registry key SqlCluster in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\Setup\ from 1 to 0 2. Disable TCP/IP in Server Network Protocols and enabled Named Pipes from ...
GitHub

SQL Exporter for Prometheus

In fact, any DBMS for which a Go driver is available may be monitored after rebuilding the binary with the DBMS driver included. Per the Prometheus philosophy, scrapes are synchronous (metrics are ...