Alex Yumashev's blog archive

ASP.NET Repeater Alternative Item Markup Optimization

Another post for ASP.NET/SQL developers reading this blog. If you think these posts do not belong here, please leave a comment, and I'll consider moving my development articles to a separate blog.

How Gaming Affects Your Productivity and Why Is It Awesome Anyway

A friend of mine, who's also a geek and "digital entrepreneur", has described himself as a "PC-gaming junkie" and asked me to write a post on the "how gaming affects productivity in a negative way" topic.

How To Bend The Universe

I know a guy who's grandfather has bent the universe once

Jitbit Turns Five Years (Thanks Ken!)

I just realized, that this June is five years since I started Jitbit Software. Seems like it was yesterday. Actually, I started in 2002 as a tiny custom software development studio, but the "Jitbit" brand is only five.

Moving SQL table text/image to a new filegroup

This post has been updated, read the updated part 2.

CREATE UNIQUE CLUSTERED INDEX [name of clustered index]
ON [table name]([Column_name])
WITH (DROP_EXISTING = ON, ONLINE = ON)
ON FILEGROUP

When you move an SQL-table to a new filegroup like above via the clustered-index recreation procedure, only "elementary" datatypes are moved (like "int", "datetime", "varchar" etc). Text, image, varbinary(max) and similar columns (aka "BLOB-fields" aka "LOB_DATA") will stay at their current location. If you click the "storage" settings for the table under the "properties" context menu item, you'll see that the "text filegroup" is the same as before! More info

Fixing The Blogger.com JS-error "Access Denied"

If you host your blog at blogspot, you are experiencing a javascript error "access denied" for the last 48 hours. Lots of people are reporting this bug, but it's still not fixed. A temporary fix is:

Simulating "jobs" in MS SQL Express

Another post for ASP.NET developers reading this blog. If you think these posts do not belong here, please leave a comment, and I'll consider moving my development articles to a separate blog.

As you might know MS SQL Server Express Edition does not include the SQL Agent service and, therefore, offers no jobs. So if you want to schedule, for instance, your backups, you... can't.

ASP.NET Image Resizing - out of memory problem

Another post for ASP.NET developers reading this blog. If you think these posts do not belong here, please leave a comment, and I'll consider moving my development articles to a separate blog.

Any ASP.NET developer who tries to create "on-the-fly" image-thumbnails in his web-application, sooner or later faces this crappy annoying "out of memory" exception, that is thrown when you use Image.FromStream or Image.GetThumbnailImage. Sometimes it is thrown when working with big (>5Mb) images, sometimes it's thrown for all images.

Macro Recorder: another trigger example - wait for pixel

Another example of "triggering" events with our Macro Recorder software using its "IF" statement. Below is a macro-script that makes Macro Recorder wait until a pixel at the given coordinates becomes white. Since Macro Recorder does not have a "wait for pixel" command, we have to use the IF statement:

WYSIWYG BBCode editor (free)

If you follow us at the Jitbit's Twitter account, you might already know that a couple of days ago I was searching for a WYSIWYG BBCode editor. I never found any. So we decided to build our own. Free and open-sourced.

older newer