MySql: Add a Column at a Specific Position

I'm playing with MySql for the 1st time in my life recently. Rather quickly I'm getting used to it mostly due to my experience with MSSQL as DBA. While changing table structure [ ... ]

posted @ 05/28/2008 7:17 PM (by Anatoly Lubarsky)

MSSQL 2008: Spatial Data Types - Geography and Geometry

In addition to new DATETIME data types introduced in MSSQL 2008 there are geography and geometry data types introduced - useful for storing and manipulating geodetic data. Geometry data type is used to store flat map data like points, lines, and shapes [ ... ]

posted @ 05/15/2008 2:28 AM (by Anatoly Lubarsky)

MSSQL 2008: What is DATETIME2

MSSQL 2008 introduces several new DATETIME datatypes for T-SQL: TIME, DATE, DATETIME2, DATETIMEOFFSET. It is obvious that TIME and DATE provide the ability to store separately DATE and TIME parts of DATETIME. It was not possible to do in previous versions of MSSQL, however [ ... ]

posted @ 05/13/2008 7:13 PM (by Anatoly Lubarsky)

T-SQL: LIKE Operator and Wildcard Characters

An interesting issue I came into recently. Suppose you have a search procedure - which consists of some SELECT query which gets a query phrase as a parameter and searches through a table coulumn using LIKE [ ... ]

posted @ 05/08/2008 2:37 AM (by Anatoly Lubarsky)

MSSQL: Search and Replace in a TEXT(NTEXT) column

Sometimes we need to search and replace a text value in the entire table. The column in question is of TEXT or NTEXT datatype. T-SQL REPLACE function does not work with TEXT/NTEXT datatype. Instead we have to use several other functions [ ... ]

posted @ 05/03/2008 8:16 PM (by Anatoly Lubarsky)

Facebook's Standard Security Settings Sufficient ? (Not)

BBC came out with an article today Identity 'at risk' on Facebook which discusses potential stealing of user data by 3rd parties applications of Facebook Development Platform: When you add an application [ ... ]

posted @ 05/02/2008 4:43 AM (by Anatoly Lubarsky)

ASP.NET tip: Autonumber Rows in ASP.NET Repeater control

How to print the current row number in an ASP.NET Repeater control ? The easiest way to autonumber rows in Repeater is to use markup or ItemDataBound event [ ... ]

posted @ 04/26/2008 2:37 AM (by Anatoly Lubarsky)

Bathroom Stall Vandalism - 2000 Users on BEBO

Bathroom Stall Vandalism on BEBO has passed 2000 users. Originally a Facebook application - it was scaled up in january 2008 t osupport Bebo platform [ ... ]

posted @ 04/22/2008 7:47 PM (by Anatoly Lubarsky)

Reducing Memory Footprint of any Process with EmptyWorkingSet

Ever wondered why does .NET winform application takes so much memory on startup ? It is obvious that most of this memory is not in use. The reason is that JIT compiler and the whole winforms engine is loaded into the process [ ... ]

posted @ 04/20/2008 9:07 PM (by Anatoly Lubarsky)

C# Win32 API: Flash Window (FlashWindowEx)

he following method will flash the title bar or taskbar button or tray icon. Need to wrap a method imported from user32: FlashWindowEx [ ... ]

posted @ 04/19/2008 9:11 PM (by Anatoly Lubarsky)