Cannot open .SQL file in Visual Studio 2010
· ☕ 1 min read
Environment hangs, completely at times, or just for several seconds. If it resumes after hanging, you are able to close the tab where this .SQL file would show up. In any case, you cannot see or edit anything in there, seeing this Visual Studio 2010 branded blue background all over the contents area.

.NET - AddRange for HashSet
· ☕ 1 min read
You do not need to implement your own HashSet for that, just use the native UnionWith extension method.

VB.NET - DropDownOpening Event For ComboBox
· ☕ 1 min read
Here is a proper way to do it - inherit a class from native ComboBox and override OnDropDown to raise a custom DropDownOpening event first. If you anticipate loading to take considerable time, you can wrap your reload code into a construct like this

Memory Upgrade For AOD257 Laptop - 4GB?
· ☕ 2 min read
I recently bought one of those 10-inch AOD257 series laptop for my father.Two issues with it - Windows 7 Starter and just 1GB of memory. First, upgraded to Win7 Enterprise. After that been thinking to upgrade memory for a while, and decided to try fitting a 4GB stick.

Memory performance of Acer's budget desktop
· ☕ 1 min read
Did not have a chance to do a full performance test on this machine (VX4618G-Ei7260W). Memory, however, works quite well for a $700 PC, benchmarked with Aida64.

MS SQL Server 2008 R2 error log growing rapidly
· ☕ 1 min read
MS SQL server 2008 R2 was spamming the error log with the following two messages (got around 50GB of them in 4 days). An exception occurred while enqueueing a message in the target queue. Error 15517, State 1. Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.

MS SQL drop column with default constraint
· ☕ 1 min read
The following MS SQL script will generate MS SQL statements to drop a list of columns with default constraint for a certain table. Need to change table_name and list of columns, as applicable. Statements will be generated only if required.