x2line blogs

x2line - Blogs

Front Page Recent

Get Fosimo on CNET Download.com!

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)

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)

Calculate Euler Number with Recursion

I recently went through several posts I had made on one of the development forums back then in 2005. I've found one of them interesting and want to repost it here. The question went like this: How can I calculate euler number with recursion [ ... ]

posted @ 03/11/2008 4:01 AM (by Anatoly Lubarsky)


Community Archives: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75

 

Syndication

OPML (bloggers)
RSS (recent posts)
 

Bloggers

Anatoly Lubarsky
(731, 09/14/2019 9:21 PM)
 
x2line developer
(5, 04/21/2007 5:13 PM)
 
x2line test
(2, 03/29/2006 5:49 AM)
 
AL
(1, 03/27/2005 2:50 AM)