▼
Friday, 20 September 2013

Quick HTML Template

›
This is the template that I can copy-paste whenever I need some simple HTML page. You are free to use it for yourself. <!DOCTYPE ht...
Wednesday, 18 September 2013

Query to show Performance Counters that SQL Server exposes to Windows OS

›
T-SQL query that can quickly show some valuable performance counters from SQL Server. The values in this system view are actual, they get r...
Friday, 14 December 2012

SQL Server, query performance and Execution Plan panel

›
Noticed one interesting thing with sql management studio. Was trying to pinpoint some performance issues with a query which had WHILE...
1 comment:
Monday, 30 July 2012

Resize the partition on Windows Server for free and non-destructive

›
Problem: after cloning smaller hard drive (HDD, 80 Gb) to a larger solid-state drive (SSD, 128 Gb), the partitions on the SSD became exact...
1 comment:
Sunday, 29 July 2012

Updating firmware on OCZ Vertex 4 SSD

›
After several unsuccessfull attempts to update the firmware on my new SSD - OCZ Vertex 4 - I think I found a way that works.
Monday, 25 June 2012

Enabling CAT.Net to work with Visual Studio 2010

›
Microsoft recommends using their CAT.Net Security Code Analysis tool as part of the SDL (Software Development Process). Unfortunately, lat...
Thursday, 21 June 2012

Alternative to sp_changedbowner which is being deprecated

›
SQL Server Books online suggest that will is being deprecated starting from 2008 (not even 2008 R2) and will be removed from future releas...
Wednesday, 13 June 2012

wix, managed code custom action may fail when temp folder is compressed

›
msi installer was created by WiX 3.5. VM with Windows Server 2003 SP1 32 bit, Windows Installer 4.5, .Net 3.5 SP1. It had a c# custom act...