x2line — We Build Applications :: Blogs

x2line — Blogs

Front Page Recent

Fosimo Fosimo.TR
Get Fosimo on CNET Download.com! Get Fosimo.TR from CNET Download.com!

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)

Thoughts on Bebo Audience

Since one of my applications - Bathroom Stall Vandalism works both on bebo and on facebook as well - it is always useful to compare performance on both platforms. BTW, Bathroom Stall Vandalism is all about people virtually write and vandalize their rest rooms (LOL) [ ... ]

posted @ 04/10/2008 2:17 AM (by Anatoly Lubarsky)



 

Syndication

OPML (bloggers)
RSS (recent posts)
 

Bloggers

Anatoly Lubarsky
(858, 06/12/2010 11:09 PM)
 
ML
(11, 03/03/2007 2:19 AM)
 
x2line test
(10, 03/29/2006 5:49 AM)
 
x2line developer
(6, 04/21/2007 5:13 PM)
 
Freestyle Battle Group
(3, 07/17/2008 8:22 PM)
 
AL
(1, 03/27/2005 2:50 AM)