Author: volt
-
No Man’s Sky: Explorers of an Unknown Universe
There was something special about the summer of 2016, when No Man’s Sky launched amid enormous expectations and equally enormous controversy. This post isn’t a review — it’s the account of an experience, much like the galaxy it describes: personal, unique, unrepeatable. What Is No Man’s Sky? It’s a space exploration game in which you…
-
AlwaysOn : Manually add a new replica node using a custom backup path with custom credentials
SQL Server Management Studio’s AlwaysOn Availability Groups wizard covers most common scenarios well — but it has a significant limitation: it cannot impersonate a custom user to access a remote backup path with non-default credentials. When your backup share requires a specific domain account or a custom username/password combination, you need to perform the initial…
-
MovieMania! v.1.0
Movie Mania! v.1.0 was the first version of the project, originally developed for Windows Vista/7/8. This version is no longer supported or available for download. For the full history of the project and details on subsequent versions — up to v.3.x on Windows Store and Android — visit the Movie Mania! dedicated page. What Was…
-
Recover a database with a DAMAGED and/or LOST log file
A corrupted or missing transaction log file is one of the most stressful situations a DBA can face. The first instinct is to restore from the last full backup — but depending on the circumstances, SQL Server offers faster recovery paths that minimize both downtime and data loss. This article walks through the two main…
-
Monitoring Wait Events of a single Session or Query in SQL Server
When troubleshooting a slow query or a specific application session, the instance-level wait statistics in sys.dm_os_wait_stats are too coarse: they aggregate wait events from all processes since the last restart. Resetting the view with DBCC SQLPERF is also problematic on busy instances where hundreds of other sessions generate noise. SQL Server 2008’s Extended Events framework…
-
How to script logins with the original password HASH and original SID
When migrating SQL Server instances, one of the most error-prone steps is transferring SQL logins to the destination. Simply scripting a login with CREATE LOGIN … WITH PASSWORD won’t preserve the original password hash or the original SID — and mismatched SIDs between instance logins and database users will break application connectivity even if the…
-
How to improve mysql performance using CACHING
Before diving into a deep performance investigation — wait stats, execution plans, I/O benchmarks — it’s worth checking whether a simple configuration oversight is behind the problem. One of the most common and highest-impact quick wins in MySQL is query cache sizing. A cache that’s disabled, too small, or incorrectly sized can account for a…
-
Massive SQL Server Database Moving Using Detach – Attach: The Complete Procedure
Moving SQL Server databases to a new volume — whether to rebalance I/O across storage, migrate to faster disks, or reclaim space — requires a methodical approach to avoid downtime surprises. The detach/attach method is the fastest option when you can afford a brief offline window: no backup involved, no network transfer overhead. This metascript…
-
Anayze SQL default trace to investigate instance events
SQL Server runs a lightweight background trace called the default trace that records a wide range of server-level events: database auto-growth events, object creation and deletion, login failures, server configuration changes, and more. It’s often the first place to look when investigating an incident that didn’t make it into the error log. This article shows…
-
Queries to see rapidly what your MySql is doing NOW
When troubleshooting a slow or unresponsive MySQL instance, the first step is always the same: find out what is happening right now. These quick diagnostic queries use MySQL’s built-in SHOW STATUS and SHOW PROCESSLIST commands to surface the most useful information in seconds — no external tools required. 1. Active Processes and Running Queries SHOW…