Search This Blog

2008-03-28

Dynamic controls in asp.net

SOURCES:
http://www.singingeels.com/Articles/Dynamically_Created_Controls_in_ASPNET.aspx

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page
{

private TextBox [ ] m_dynamicTextBoxes; //this is class variable
public string msg = "";


protected override void OnInit ( EventArgs e )
{ //HUOMI THIS FIRST
base.OnInit ( e );

c_button.Click += new EventHandler ( ButtonClick ); //add the event handelr for all textboxes !!!
m_dynamicTextBoxes = new TextBox [ 5 ]; //populate the array of TextBoxes

for (int i = 0; i < 5; i++)
{
TextBox textBox = new TextBox ( );
textBox.ID = "c_textBox" + i.ToString ( );
c_placeholder.Controls.Add ( textBox );
m_dynamicTextBoxes [ i ] = textBox;
} //eof for





} //eof OnInit

protected void ButtonClick ( object sender, EventArgs e )
{
GUIBuilder.GenerateEmptyForm ( ref msg , ref sender , ref e , ref m_dynamicTextBoxes, ref c_label );
} //eof ButtonClick





protected void Page_Load(object sender, EventArgs e)
{

} //eof Page_Load
} //eof class Page



using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;


///
/// Take the logic of building out from the web page class
///

public class GUIBuilder
{
public GUIBuilder()
{
//
// TODO: Add constructor logic here
//
} //eof cons


public static void GenerateEmptyForm ( ref string msg , ref object sender , EventArgs e ,
ref TextBox [ ] m_dynamicTextBoxes , ref Label c_label )
{
foreach (TextBox textBox in m_dynamicTextBoxes)
{
c_label.Text += "the text was " + textBox.Text + " -- ";
}

} //eof GenerateEmpty Form




} //eof GUIBuilder

2008-03-25

Allmost there


SELECT
-- OBJECT_name(c.object_id) TableName
c.name AS [COLUMN_NAME]
-- ,SCHEMA_NAME(t.schema_id) AS SchemaName
, t.name AS [DATA_TYPE]
-- ,t.is_user_defined
-- ,t.is_assembly_type
,c.max_length
-- ,c.precision
-- ,c.scale
,c.is_nullable AS [OBLIGATORY]
-- ,value as [DESCRIPTION]
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id=t.user_type_id
-- left join sys.extended_properties AS ep on ep.major_id = c.object_id AND ep.minor_id = c.column_id

ORDER BY DATA_TYPE

SELECT DISTINCT t.name from sys.types as t

select value from sys.extended_properties

2008-03-20

how to find recursively controls in C# asp.net

private Control FindControlRecursive ( Control root, string id )
{
try
{
if (root.ID == id)
{
return root;
} //eof if

foreach (Control c in root.Controls)
{
Control t = FindControlRecursive ( c, id );
if (t != null)
{
return t;
} //eof if
} //eof foreach
} //eof try
catch (Exception e)
{
Debugger.WriteIf ( "The following Exception occured : \n" + e.Message );
this.Master.Error_label.ForeColor = System.Drawing.Color.Red;
this.Master.Error_label.Text = e.Message;
return success;
} //eof catch

return null;
} //eof FindControlRecursive

how to Get table name , Column name , data type , Description from a table in sql server 2005

-- Courtesy of Heikki Kauranen


SELECT c.name AS [Column Name], value AS
[Description], sc.data_type
FROM sys.extended_properties AS ep
INNER JOIN sys.tables AS t ON ep.major_id = t.object_id
INNER JOIN sys.columns AS c ON ep.major_id = c.object_id AND ep.minor_id
= c.column_id
INNER JOIN INFORMATION_SCHEMA.COLUMNS sc ON t.name = sc.table_name and
c.name = sc.column_name
WHERE class = 1 and t.name = 'Project_tb'

2008-03-19

How to create dynamically controls in C#

Create a class dedicated for the purpose - the code will take a lot of space ; ) - in this example I ll use GUIGenerator.cs
put it in some namespace - herewith Utils
put all the methods so that you will pass the parameters by reference to them - all the parameters - gui controls , datasets , etc.
so the classs will look like this:



using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

namespace Utils {
//comm -- /
//comm -- / Summary description for Utils.GUIBuilder
//comm -- /

public class GUIGenerator
{
public void GenerateSomething (ref Panel panel_obj , ref DataSet ds )
{
//iterate over a dataset with param values :
foreach (DataTable dt in ds.Tables) //comm -- we have only one table
{
Utils.Debugger.WriteIf ( "The name of the table is " + dt.TableName );
foreach (DataRow dr in dt.Rows)
{
//comm -- this is complete mess - hint enable css colors debugging to see the boxes
//comm -- debug Debug.WriteLine ( "dr[0] is " + dr [ 0 ] );
//comm -- debug Debug.WriteLine ( "dr[1] is " + dr [ 1 ] );
//comm -- take the NameOf the control
string nameOfControl = System.Convert.ToString(dr [ 0 ]);
//comm -- take the Name of the Type as string
string typeOfControl = System.Convert.ToString ( dr [ 1 ] );
Panel glb_panel = new Panel ( );

glb_panel.ID = nameOfControl + "_glb";
glb_panel.ToolTip = "fill in here the " + nameOfControl;

HtmlInputCheckBox cb = new HtmlInputCheckBox ( );
cb.ID = nameOfControl + "_cb";
cb.Checked = (bool)dr [ 2 ];
glb_panel.Controls.Add ( cb );

Label lb = new Label ( );
lb.Text = nameOfControl;
glb_panel.Controls.Add ( lb );

glb_panel.CssClass = "glb";
glb_panel.Wrap = true;
glb_panel.Visible = true;
if ((string)dr [ 3 ] != null)
{
filledValue = (string)dr [ 3 ]; //comm -- the fourth columns contains the values of the controls
}
else
{
filledValue = "";
}
//string filledValue = "fakeValue";
this.GenerateFilledControl ( ref nameOfControl, ref typeOfControl, ref glb_panel , ref filledValue);


panel_obj.ContentTemplateContainer.Controls.Add ( glb_panel );

/*
DropDownList drop = new DropDownList ( );
drop.Items.Add ( "OR" );
drop.Items.Add ( "AND" );
drop.Items.Add ( "LIKE" );
drop.ID = dt.ToString ( ) + "row" + rowNum; //comm -- mark this row number
drop.CssClass = "connector_class";
panel_obj.ContentTemplateContainer.Controls.Add ( drop );
*/


} //eof foreach2
} //eof foreach1

} //eof method

} //eof class GUIGenerator

how to read byte stream from database in C#

while (dbDr_obj.HasRows == true)
{
dbDr_obj.Read ( );
someString = dbDr_obj.GetString ( 0 );

byte[] buffer = new byte[8192];
long read= 0;
long index = 0;

do
{
read = dbDr_obj.GetBytes ( 1, index, buffer, 0, buffer.Length );
m.Write(buffer, 0, (int)read);
index += read;
} //eof while
while (read > 0) ;


if (dbDr_obj.IsClosed == false)
{
dbDr_obj.Close ( ); //comm -- remember to close the DbReader obj otherwise
} //eof if (dbDr_obj.IsClosed == false)
break;
} //eof while

Encryption , Decryption in

/*
* Author : Nidheesh T.Mani
* Version : 1.0
*/

using System;
using System.Security.Cryptography;
namespace Utils
{
///
/// This class provide static methods for encryption and decryption.
///

public class DataEncryption
{
///
/// Method which does the encryption using Rijndeal algorithm
///

/// Data to be encrypted
/// The string to used for making the key.The same string
/// should be used for making the decrpt key
/// Encrypted Data
public static string EncryptString ( string InputText, string Password )
{
RijndaelManaged RijndaelCipher = new RijndaelManaged ( );

byte [ ] PlainText = System.Text.Encoding.Unicode.GetBytes ( InputText );
byte [ ] Salt = System.Text.Encoding.ASCII.GetBytes ( Password.Length.ToString ( ) );

//This class uses an extension of the PBKDF1 algorithm defined in the PKCS#5 v2.0
//standard to derive bytes suitable for use as key material from a password.
//The standard is documented in IETF RRC 2898.

PasswordDeriveBytes SecretKey = new PasswordDeriveBytes ( Password, Salt );
//Creates a symmetric encryptor object.
ICryptoTransform Encryptor = RijndaelCipher.CreateEncryptor ( SecretKey.GetBytes ( 32 ), SecretKey.GetBytes ( 16 ) );
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream ( );
//Defines a stream that links data streams to cryptographic transformations
CryptoStream cryptoStream = new CryptoStream ( memoryStream, Encryptor, CryptoStreamMode.Write );
cryptoStream.Write ( PlainText, 0, PlainText.Length );
//Writes the final state and clears the buffer
cryptoStream.FlushFinalBlock ( );
byte [ ] CipherBytes = memoryStream.ToArray ( );
memoryStream.Close ( );
cryptoStream.Close ( );
string EncryptedData = Convert.ToBase64String ( CipherBytes );
return EncryptedData;

} //eof private static string EncryptString ( string InputText, string Password )

///
/// Method which does the encryption using Rijndeal algorithm.This is for decrypting the data
/// which has orginally being encrypted using the above method
///

/// The encrypted data which has to be decrypted
/// The string which has been used for encrypting.The same string
/// should be used for making the decrypt key
/// Decrypted Data
public static string DecryptString ( string InputText, string Password )
{

RijndaelManaged RijndaelCipher = new RijndaelManaged ( );
byte [ ] EncryptedData = Convert.FromBase64String ( InputText );
byte [ ] Salt = System.Text.Encoding.ASCII.GetBytes ( Password.Length.ToString ( ) );
//Making of the key for decryption
PasswordDeriveBytes SecretKey = new PasswordDeriveBytes ( Password, Salt );
//Creates a symmetric Rijndael decryptor object.
ICryptoTransform Decryptor = RijndaelCipher.CreateDecryptor ( SecretKey.GetBytes ( 32 ), SecretKey.GetBytes ( 16 ) );
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream ( EncryptedData );
//Defines the cryptographics stream for decryption.THe stream contains decrpted data
CryptoStream cryptoStream = new CryptoStream ( memoryStream, Decryptor, CryptoStreamMode.Read );
byte [ ] PlainText = new byte [ EncryptedData.Length ];
int DecryptedCount = cryptoStream.Read ( PlainText, 0, PlainText.Length );
memoryStream.Close ( );
cryptoStream.Close ( );
//Converting to string
string DecryptedData = System.Text.Encoding.Unicode.GetString ( PlainText, 0, DecryptedCount );
return DecryptedData;

} //eof private static string DecryptString (string InputText , string Password )

} //eof class

} //eof namespace Utils

2008-03-18

Generate member accessors , properties for C# asp.net with textpad

// Generate member accessors , properties for C# asp.net with textpad
/// find:^(.*)$
/// replace:private string s\1 ; \n public string \1 { \n \t\t get { return s\1 ; } \n \t\t set { s\1 = value ; } \n } //comm -- eof \1 property \n\n

how to compress and decompress DataSet

SOURCES:
http://www.eggheadcafe.com/articles/20041128.asp
URL
URL
URL

using System;
using System.Collections.Generic;
using System.Text;

namespace CompressDecompressDataSet
{
#region Using directives
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Runtime.Serialization.Formatters.Binary;
using System.IO;
using System.IO.Compression;

#endregion
//courtesy of Peter A. Bromberg, Ph.D.
namespace DSCompression
{
public class DataSetCodec
{

#region Main Function
static void Main(string[] args)
{
DataSetCodec dsc = new DataSetCodec();
DataSet ds = new DataSet();
ds.Tables.Add("Table");
ds.Tables["Table"].Columns.Add("include");
ds.Tables["Table"].Columns.Add("filledValues");

DataRow row = ds.Tables[0].NewRow();
row["include"] = true;
row["filledValues"] = "some value";
ds.Tables[0].Rows.Add(row);
Debugger.DebugDataSet("ok?", ref ds);


//now start compression
byte[] compressedDataSetInBytes = DataSetCodec.CompressDataSet(ref ds);
int lengthOfArray = compressedDataSetInBytes.Length ;

//NOW SHOW THE BYTES
foreach (byte b in compressedDataSetInBytes)
{
Debugger.WriteByte(b);
}


//now decompress
DataSetCodec.DecompressDataSet(ref compressedDataSetInBytes, out lengthOfArray );
Debugger.DebugDataSet("ok?", ref ds);


} //eof main
#endregion



// private ctor; all members are static
private DataSetCodec()
{
}

public static byte[] CompressDataSet(ref DataSet ds)
{
ds.RemotingFormat = SerializationFormat.Binary;
BinaryFormatter bf = new BinaryFormatter();
MemoryStream ms = new MemoryStream();
bf.Serialize(ms, ds);
byte[] inbyt = ms.ToArray();
System.IO.MemoryStream objStream = new MemoryStream();
System.IO.Compression.DeflateStream objZS =
new System.IO.Compression.DeflateStream(objStream,
System.IO.Compression.CompressionMode.Compress);
objZS.Write(inbyt, 0, inbyt.Length);
objZS.Flush();
objZS.Close();
return objStream.ToArray();
}


public static DataSet DecompressDataSet(ref byte[] bytDs, out int len)
{
System.Diagnostics.Debug.Write(bytDs.Length.ToString());
DataSet outDs = new DataSet();
MemoryStream inMs = new MemoryStream(bytDs);
inMs.Seek(0, 0);
DeflateStream zipStream = new DeflateStream(inMs, CompressionMode.Decompress, true);
byte[] outByt = ReadFullStream(zipStream);
zipStream.Flush();
zipStream.Close();
MemoryStream outMs = new MemoryStream(outByt);
outMs.Seek(0, 0);
outDs.RemotingFormat = SerializationFormat.Binary;
BinaryFormatter bf = new BinaryFormatter();
len = (int)outMs.Length;
outDs = (DataSet)bf.Deserialize(outMs, null);
return outDs;
}

public static byte[] ReadFullStream(Stream stream)
{
byte[] buffer = new byte[32768];
using (MemoryStream ms = new MemoryStream())
{
while (true)
{
int read = stream.Read(buffer, 0, buffer.Length);
if (read <= 0)
return ms.ToArray();
ms.Write(buffer, 0, read);
}

}
} //eof public static byte [] ReadFullStream
} //eof class
} //eof namespace DSCompression



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace CompressDecompressDataSet
{


public class Debugger
{
public Debugger ( )
{
//
// TODO: Add constructor logic here
//
}
///
/// This method outputs on values of the passed dataset objects for easier debugging
///

/// the string passed containng usual info
/// the dataset , which content one should debug
/// call it this way Utils.Debugger.DebugDataSet ( System.Reflection.MethodInfo.GetCurrentMethod().Name() , , ref ds );
public static void DebugDataSet ( string msg, ref System.Data.DataSet ds )
{
System.Diagnostics.Debug.WriteLine ( msg );
foreach (System.Data.DataTable dt in ds.Tables)
{
System.Diagnostics.Debug.WriteLine ( "================= Table " +
dt.TableName + " ========================= START" );
foreach (System.Data.DataColumn dc in dt.Columns)
{
System.Diagnostics.Debug.Write ( " | " );
System.Diagnostics.Debug.Write ( dc.ColumnName + " | " );
} //eof foreach (DataColumn dc in dt.Columns)
int rowNumber = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
System.Diagnostics.Debug.Write ( "\n row " + rowNumber + " --- " );
int colNumberInRow = 0;
foreach (System.Data.DataColumn dc in dt.Columns)
{
System.Diagnostics.Debug.Write ( " |" + colNumberInRow + "| " );
System.Diagnostics.Debug.Write ( dr [ dc ].ToString ( ) + " " );
colNumberInRow++;
} //eof foreach (DataColumn dc in dt.Columns)
rowNumber++;
} //eof foreach (DataRow dr in dt.Rows)
System.Diagnostics.Debug.Write ( " \n" );
System.Diagnostics.Debug.WriteLine ( "================= Table " +
dt.TableName + " ========================= END" );
} //eof foreach (DataTable dt in ds.Tables)

} //eof public static void DebugDataSet ( string msg , ref System.Data.DataSet ds )

public static void WriteLine ( string msg )
{
System.Diagnostics.Debug.WriteLine ( msg );
} //eof WriteLine


public static void Write ( string msg )
{
System.Diagnostics.Debug.Write ( msg );
} //eof Write

public static void WriteByte(byte b)
{
System.Diagnostics.Debug.Write(b.ToString());
} //eof WriteByte

} //eof class Debugger
} //eof namespace

2008-03-12

debugging datasets in C#

///
/// This method outputs on values of the passed dataset objects for easier debugging
///

/// the string passed containng usual info
/// the dataset , which content one should debug
/// call it this way Debugger.debugDataSet ( System.Reflection.MethodInfo.GetCurrentMethod().Name() , , ref ds );
public static void debugDataSet ( string msg , ref System.Data.DataSet ds )
{
System.Diagnostics.Debug.WriteLine ( msg );
foreach (System.Data.DataTable dt in ds.Tables)
{
System.Diagnostics.Debug.WriteLine ("================= Table " +
dt.TableName + " ========================= START");
foreach (System.Data.DataColumn dc in dt.Columns)
{
System.Diagnostics.Debug.Write(" | ");
System.Diagnostics.Debug.Write(dc.ColumnName + " | ");
} //eof foreach (DataColumn dc in dt.Columns)
int rowNumber = 0 ;
foreach (System.Data.DataRow dr in dt.Rows)
{
System.Diagnostics.Debug.Write ( "\n row " + rowNumber + " --- " );
int colNumberInRow = 0 ;
foreach (System.Data.DataColumn dc in dt.Columns)
{
System.Diagnostics.Debug.Write(" |" + colNumberInRow + "| ");
System.Diagnostics.Debug.Write(dr[dc].ToString() + " ");
colNumberInRow ++ ;
} //eof foreach (DataColumn dc in dt.Columns)
rowNumber ++ ;
} //eof foreach (DataRow dr in dt.Rows)
System.Diagnostics.Debug.Write ( " \n" );
System.Diagnostics.Debug.WriteLine ( "================= Table " +
dt.TableName + " ========================= END" );
} //eof foreach (DataTable dt in ds.Tables)

} //eof public static void debugDataSet ( string msg , ref System.Data.DataSet ds )

2008-03-07

clever debugging in css

/*debug start*/
border: 1px dashed #333;
background-color:aaaaaa;
/*end debug*/

tabless form using css




CSS Forms


This page is based entirerly on CSS. No tables whatsoever. It's fast, accessible, and probably the most elegant way to make table-less forms today. Check it out yourself...







Personal details















Personal details










SQL SERVER 2005 CHEAT SHEET

GO
SELECT f.name AS ForeignKey,
OBJECT_NAME(f.parent_object_id) AS TableName,
COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS ReferenceColumnName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
ON f.object_id = fc.constraint_object_id


-- SELECT * FROM INFORMATION_SCHEMA.TABLES


-- select all the columns from the SomeTable_tb table
-- SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'
SELECT COLUMN_NAME , DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'
-- SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'

-- SELECT * FROM sys.tables

-- used to gather statistics stored in memory but not persistent on disk such as thread information, memory usage, and connection details
-- SELECT * FROM sys.dm_exec_query_stats

-- EXEC sys.sp_columns 'SomeTable_tb'

-- SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_DEFAULT
-- FROM POC.INFORMATION_SCHEMA.COLUMNS
-- WHERE TABLE_NAME = N'SomeTable_tb';
-- SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'

Labels

perl (41) Cheat Sheet (25) how-to (24) windows (14) sql server 2008 (13) linux (12) oracle (12) sql (12) Unix (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) bash (6) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) excel (4) future (4) generic (4) git cheat sheet (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) logging (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) architecture (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) linux cheat sheet (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) IDEA (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture input output (1) archive (1) arguments (1) avatar (1) aws cheat sheet cli (1) aws cli (1) aws cli amazon cheat sheet (1) aws elb (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy paste (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) isg-pub issue-tracker architecture (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) openssl (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scala ScalaFmt (1) scp (1) scripts (1) scsi (1) search and replace (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smells (1) smtp (1) software development (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) system design (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux .tmux.conf configuration (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vbox virtual box cheat sheet (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List