Category: Technology

  • JiMetrics now gathers SQL Server startup account

    During the last few days, I’ve refactored JiMetrics and added a new function: Used Pester to create more test cases for PowerShell functions I wrote; Enhanced the design and code so JiMetrics also gathers SQL Server instance’s startup account, which can be useful. If you don’t know what JiMetrics is, go to this page to […]

  • Speaking at SQLSaturday Chicago

    I will deliver a session for SQLSaturday this coming Saturday, April 26th. I will be discussing “Big Data”: cloud computing, distributed computing, column-store databases, in-memory OLTP databases, Hadoop, machine learning, and data analytics. Hope to see you there.

  • Removing duplicate rows in small batches based on date column

    Due to double scheduling, some duplicate rows were inserted into the Windows.TableStats table in JiMetrics. To confirm that the table has duplicates, here is the T-SQL script I used. Note that this same script should work in all other major RDBMS platforms like MySQL, Oracle, etc. Adjust table and column names to fit your needs. […]

  • WordPress post update services and Nginx upstream time out

    Starting around last Friday, I think, this site became irresponsive. Checking Tengine/Nginx error logs, here is a sample of what I saw: [code language=”text”] 2014/03/xx 08:43:40 [error] 3837#0: *6149 connect() to unix:/var/run/php-fastcgi/php-fastcgi.socket failed (11: Resource temporarily unavailable) while connecting to upstream, client:, server:, request: “POST /xmlrpc.php HTTP/1.0”, upstream: “fastcgi://unix:/var/run/php-fastcgi/php-fastcgi.socket:”, host: “” 2014/03/xx 08:45:13 […]

  • Collecting Windows BIOS and Host Serial Number

    After imporving JiMetrics yesterday so it tries to determine if the host is a VM or not, I made another improvement today: collecting host server BIOS related information and serial number. I don’t know about you, in the past when I needed to gather a Windows server’s BIOS or serial number for troubleshooting, I typically […]