Reference | boltblog

Finding the most expensive recent SQL queries on SQL Server

Unknownbolt | 2017-11-02

Mostly a note to self, original source here. SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END – qs.statement_start_offset)/2)+1), qs.execution_count, qs.total_logical_reads, qs.last_logical_reads, qs.total_logical_writes, qs.last_logical_writes, qs.total_worker_time, qs.last_worker_time, qs.total_elapsed_time/1000000 total_elapsed_time_in_S, qs.last_elapsed_time/1000000 last_elapsed_time_in_S, qs.last_execution_time, qp.query_plan FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp ORDER BY qs.total_logical_reads DESC — logical reads […]

Creating a local Certificate Authority using OpenSSL

Unknownbolt | 2017-10-30

I was recently tasked with creating a local CA for a project, where we needed to verify custom client certificates, have the ability to revoke them at will, and we wanted to add additional custom fields to the certificates. Cool. The first stop after searching a bit was this excellent howto by Jamie Nguyen. There’s […]

How to set the default location for new computers in Active Directory

Unknownbolt | 2017-09-17

Just a short note to self here, as the process is fully documented at Microsoft’s website (local archive here). The command to use is: C:\windows\system32> redircmp ou=mycomputers,DC=contoso,dc=com Of course you have to customize the location to fit your domain.

Figuring out which session is blocking a query on Microsoft SQL Server (query suspended)

Unknownbolt | 2017-08-28

I was recently debugging a case where a customer’s installation was hanging due to a database lock. The issue turned out to be that the database was not set to a default transaction level of READ COMMITTED SNAPSHOT, which the product expects. Regardless, while troubleshooting the issue, I stumbled upon a very useful SQL query […]

Yamaha Sting owner’s manual

Unknownbolt | 2017-06-05

Found myself needing this. If you need it too, here it is.

Reset dpkg (apt) package configuration to default, restore deleted config files

Unknownbolt | 2017-03-06

From a .deb file: dpkg -i –force-confmiss <package>.deb Or with apt-get: apt-get install –reinstall -o Dpkg::Options::=”–force-confmiss” <package>

Installing Windows XP on the Dell Vostro 1700

Unknownbolt | 2017-03-05

This is basically the same procedure as installing Windows XP on the Fujitsu Siemens Esprimo u9200, in that it needs custom SATA drivers to find the harddisk during install, as well as a bunch of other ones. For this install, I decided to actually create a driver disk, and use a real floppy drive. I […]

Windows Volume License Keys (VLK)

Unknownbolt | 2017-03-03

I keep having to look these up, especially the “Upgrade Key” at the bottom. So I stored them here. Windows Server 2022 Operating system edition KMS Client Setup Key Windows Server 2022 Datacenter WX4NM-KYWYW-QJJR4-XV3QB-6VM33 Windows Server 2022 Standard VDYBN-27WPP-V4HQT-9VMD4-VMK7H Windows Server 2019 Operating system edition KMS Client Setup Key Windows Server 2019 Datacenter WMDGN-G9PQG-XVVXX-R3X43-63DFG Windows […]

Some fonts shown as squares in Kali Linux

Unknownbolt | 2016-05-16

Just rebuild the font cache: # fc-cache -f You’re welcome 🙂

My tweaks to Kali Linux (note to self)

Unknownbolt | 2016-05-14

Here are some of the things I did to make Kali Linux 2016.1 suit my taste, mostly intended as a note to myself, but posted here in case it helps anyone else. General checklist Install aptitude and update everything Add settings icon to left panel Enable mouse tap to click in “Settings => Mouse & […]