Search This Blog

2010-06-27

Cool programs , utilities and programming environments for Windows, most of which free ( revised )


Cool programs , utilities and programming environments for Windows, most of which free ( revised )

Opera - simply the best browser on the planet
SysInternals Suite
Firefox
Safari -
Google Chrome
Active Perl
izarc - the best zipper
Process Explorer - shows resources usage per running process on Windows
Google Earth
Picasa - the best free picture viewer , organizer
Mozilla Thunderbird
Foxit Reader - much faster pdf reader
Textpad - the best text editor for Windows
smstoolpack - create CRUD for sql server
GreenShot
Open diff - tool for comparing sql server 2005 databases
Skype - the best client for Internet and Video Telephony
NSIS - the best open source Windows installer maker
And the time plugin
Gears -- edit online documents offline
Free youtube to ipod converter -- get mp4 files easily to your phone
Defragler - Disk Defragment utility
DvdDecrypter - the best DVD free ripper
ImgBurner - burn ISO images - freeware
ArsClip remembers your clibboard stuff - Hint , Ctrl + Shift + Z , 2
colorpic - Color to hex utility
Expresso - a GUI tool for building and verifying Regular Expressions
a flv file player
Python - for cool scripts and programming
STARUML - the best open source UML editor
Infrarecorder - free CD / DVD burner
Paint.Net - freeware image editor
putty
winscp
Multiline Search and Replace utility program
Google Gears - use Gmail offline
HijackThis
tortoise svn - a stable gui and command line to subversion for Windows
slik svn - the command line tools for svn for windows
Data Recovery - recover Shift + del removed programs
Windows Sysinternal utilities
Cmdow is a Win32 commandline utility for NT4/2000/XP/2003 that allows windows to be listed, moved, resized, renamed, hidden/unhidden, disabled/enabled, minimized, maximized, restored, activated/inactivated, closed, killed and more.
Grep , FGrep and Egrep for windows (remember the dll's also )
Less for Windows ( remember the dll's also )
7-zip

Lessons for wanna be Sofware companies ....

I just ended installing Ubuntu on my wife's EEPC ... What a pain ... The wanna be software company called Asus has tried to impose even bigger restrictions than Microsoft to the ability of its customers to modify the product they purchased from them ... My advice for those guys :
 - if your product has good OS + applications your customers will stick to it
 - the more restrictions you pose the less probably the customer will come back the next time ( I would not buy anymore EEPC ... it is not worth the pain ... I have lost some 40 hours trying to resolve some simple problems ... as installing flash , upgrading firefox or fixing buggy WLAN support ... 40 hours !!! that would quite a sum if I evaluate my time as our Customers do ... Yes I did learn something from that time ... the lesson learned is ( pay more and value your time instead of spearing some 200 euros and loose them later on in fighting with some nerdy issues ... )
 - less is more means , less hassle ( vain apps ) and more of a working OS and hardware ( yes I would like to be able to really connect to the WLAN once I have configured it properly and not remove the connection and re-add it once again ... )

Jee Thanks GoogleCl I realized ... That would be post number 500 !!!

1 a simple perl client for sql server using odbc

2 First Google Command Line post

3 parsing meta data in a dbName TableName ColName tab csv file

4 THE MIT's vision of the second industrial revolusion ...

5 Принципи и поуки ...

6 how-to generate table row counts in TeraData sql for each table in a db

7 Concatenate.bat how-to contatenate specific file types in win cmd

8 how-to get all tables info with sqlplus in Oracle

9 how-to run simple oracle script on windows

10 Cool programs utilities and programming environments for Windows most of which free ( revised )

11 why electric future bringing e-cars and e-flying vehicles is closer than you think?

12 How-to add autoincrement in Teradata

13 Google CL out now

14 Cool programs utilities and programming environments for Windows most of which free ( revised )

15 Vim Cheat Sheet

16 the leading spaces after the beginning of the line in the history command ...

17 How-to motivate peoples at work

18 how-to parse csv file with perl

19 how-to use bteq with windows cmd

20 PERL SPLIT FUNCTION EXAMPLE

21 GetNiceTime 4FIN311_20100615_165230

22 TeraData scripts 20100615_165230

23 Solaris Cheat Sheet

24 how-to create a 5 column wiki table from copy pasted excel table in textpad

25 how-to copy tables form one database to another in Teradata RDBMS

26 how NIF works

27 Brainwashing for increasing productivity

28 30 minutes to reconfigure all the e-mail account settings on both Gmail and our company

29 höw-to configure N900 for Gmail google mobile IMAP settings and configuration

30 принципи

31 The Bing Bang Never Happened

32 The power of hyphen in Solaris

33 when will the use of fossil fuels end ?!

34 Моите принципи

35 Моите принципи

36 Select count (TaskName) from MyTodo list

37 how-to get all local groups and their users on Windows

38 moite principi

39 how-to get a nice time in windows 7 cmd

40 how-to list all local groups and users in vbs on windows server 2003

41 how-to make backups of my files in the current directory on Windows

42 how-to get a nice time in windows cmd.exe

43 how-to make backups of my files in the current directory on Windows

44 opera 10 on N900

45 how-to generate sql stored procedures with bcp and stored them into separate files

46 How-to open tab in background in chrome from Google Reader

47 Just downloaded the newest Crome and guess what ...

48 List of test table for each datatype in sql server 2008

49 Principle proven - one page can have simultaniosly many forms and many listings all configurable via db

50 Principle proved - one page can have 0 or many listings

51 how-to store foreign keys metadata in sql server 2008

52 The dynamic page layout principle is proven

53 Should we start taxating fossi fuels more ?!

54 how-to debug a DataSet in C# in html form

55 what do you I want from debugging

56 A picture is worth 1000 words

57 .Net Page Life Cycle explained

58 how-to copy paste formatting in Excel 2007

59 how-to export my putty settings into a reg file

60 how-to run a command on a remote host with putty

61 how-to kick out users from rdp session

62 2.CreateTheDb.sql

63 2.CreateTheDb.sql

64 1.KillConnectionsAndDropTheDb.sql

65 0.BackUpAllMyDatabases

66 N/A

67 Why CodePlex sucks ?!

68 how-to start / stop the javahost process on Unix for OBIEE

69 how-to start stop Oracle BI Scheduler on Solaris

70 how-to start OBIEE - Oracle BI Server

71 The first afordable electric car

72 why focus fusion will be the killer in energy business

73 How-to check that a temporary table exists and drop it if yes in mssql server

74 how-to copy the meta data of views into xml files per view on mssqlserver

75 how-to use bcp to run queries and save them into files

76 how-to get the meta data of a list of views in sql server ( mssql)

77 ksh keyboard shortcuts

78 ksh keyboard shortcuts

79 MIT with their new virus

80 N/A

81 Dense Plasma Focus Video at Google Tech Talks

82 Testing enclosures

83 N/A

84 how-to debug effectively in mssql server 2008

85 How-to wrap long files in css to all browsers

86 how-to run all the sql files under the current dir recursively in mssql server

87 A good template for mssql server stored procedure

88 how-to kill all the connections to an sql server in tsql via a stored procedure

89 WinCLF + horizontal tab in TSQL

90 Energy from Thorium

91 how-to split file into file chunks based on the number of lines per file

92 Today's lessons

93 A nice link for ASCII set tables

94 Function to get the C# type based on the tsql type

95 how-to generate classes based on tables in ms sql 2008 ( see previous posts )

96 how-to generate C# classes with stored procedure in sql server 2008

97 SSMS + WIN7 SHORTCUTS

98 how-to track table DDL changes on sql server 2008

99 how-to find out whether or not a column is the primary key in a table on sql server 2008

100 IPhone SUCKS !!!

101 how-to obtain DNS server address automatically via the command line

102 how-to execute all the sql files in the current directory via cmd and sqlcmd and output the errors in a log file

103 how-to populate the fk pk relations table

104 how-to create a table for storing FK and PK relations

105 how-to create a meta table for storing foreign keys info ...

106 how-to recreate a table with existing foreign keys

107 how-to get the size of all ms sql databases

108 how-to get the size of all ms sql databases

109 How-to generate Insert statement procedures on sql server

110 how-to remove / drop the foreign keys in sql server 2005 2008 and than recreate them again

111 proud to be bulgarian

112 how-to apply permissions for all the files in the current folder in Windows 7

113 Cool programs for Windows most of which free ( revised )

114 how-to add quick links in Gmail

115 how-to add extended properties to a list of stored procedures

116 Version stamping on tables ' extended properties

117 how-to to handle list of tables based on their extended properties on sql server

118 How-to deploy and roll back unlimited amount of sql scripts on sql server

119 How-to save object permissions for a database during development

120 how-to get the list of a columns in tsql

121 .Net to C# type converter

122 Converter class derived from previous post ...

123 C# types vs. .Net types --> code generation with textpad

124 Db versioning with DbScripter.exe

125 Why there is only one Silicon Valey

126 how-to use counter in a single selecte statement - a row_number usage in tsql

127 Start - Run - Utils ( revised )

128 The meta columns view

129 Generic way of creation history tables in tsql with triggers on update insert delete

130 GENERIC WAY OF ADDING FK's with on update cascade and on delete cascade

131 Drop and recreate FK's

132 How-to add foreign key references

133 Why use proper naming conventions while generating code ?

134 Insert procedure generator

135 Insert procedure generator

136 how-to find nullable stored procedure parameters in sql server 2005 2008

137 Utility Regex function for Sql Server 2005 2008

138 less shortcuts

139 Nix Cheat Sheet

140 Set a nice prompt for *nix version

141 Putty shortcuts

142 Linux *nix Cheat sheet

143 Sql 2008 stored procedure for creating history tables out of passed existing table

144 The software is the biggest obstacle for human's prosperity

145 Rolf Eisenring's Quantum Battery

146 For each procedure in sqlserver 2005 2008 do something ..

147 Foreach table in sqlserver 2005 2008 do something

148 what I have been doing lately on SqlServer 2005 2008

149 How-to generate update statements on SqlServer 2005 2008

150 How-to generate insert statements for Sql Server 2005 2008

151 Generic Getter and Setter in C#

152 Online dictionaries - revised

153 Online dictionaries - revised

154 Use online translation - example google translate

155 emc2 got more funding

156 how-to generate list of column names of a table in sql server 2005 2008

157 How-to generate insert statements from a table name

158 List columns from any table and generate code in tsql

159 How-to create a table and its according history table in tsql

160 how-to list all column names of a table

161 How-to list all foreign keys in sql server 2008

162 SubSonic 2.2 generate classes

163 SubSonic 3 biggest gotcha

164 SubSonic 3 Links

165 T4 templates links

166 JQuery + asp.net = nice show / hide or toggle on client side

167 how-to debug an asp.net page programatically

168 Global Fortune 500 out

169 how-to create centered page layout with css and html

170 How-to create two columns page layout with css

171 How-to generate html color table with SubSonic and Color table from sql

172 how-to create html color table ( Part 2)

173 how-to create an html color table in sql server 2008

174 how-to drop all contraints on a table in tsql

175 Effective debugging in T-SQL

176 Coding libraries tools and programs ( most of which free )

177 My new old friend

178 Help set based handling of sql types for sql server 2008( check previos post )

179 Help table for sql types

180 how-to fix Opera's msvcr71.dll problem

181 N/A

182 Generic dynamic enums in C# gets COPY PASTE MODE

183 firefox addons

184 Restore db from file on sql server 2005 / 2008

185 backup sql server 2005 / 2008 databases

186 Effective debugging in asp.net

187 how-to populate a table's column with values from the same table's another column using set based approach

188 how-to generate class with simple static public fields out of sql server 2008 database with C#

189 Cool programs for Windows most of which free ( revised )

190 globalization table in sql server 2008 - insert statement

191 globalization table in sql server 2008

192 how-to change column collation in a table on sql server 2008

193 how-to find the table name with the primary key by a given foreign key in SqlServer 2005 / 2008

194 Tsql data types

195 The grep for stored procedures on Sql Server

196 Good naming conventions for stored procs

197 Delete all my generated stored procedures

198 exec sp_HelpText procUtils_SqlCheatSheet

199 reinstall windows reminder ( revised )

200 The best mobile browsing combination

201 what I have been doing lately on sql server 2005 / 2008?

202 How-to delete unwanted Windows Services

203 Debugging procedure with table for sql server 2005

204 how-to change table columns collation with alter table in sql server 2008

205 Opera 10 Beta out now !!!

206 Interviews with Thomas Ligon on Polywell 8

207 Why Bing is not going to succeed ?

208 Cool programs for Windows most of which free ( revised )

209 List of windown

210 Understanding “Set based� and “Procedural� approaches in SQL

211 how-to reconfigure sql server 2005 / 2008

212 cmd cheat sheet ( revised )

213 Start - Run - utils (revised)

214 Windows command line tools ( revised )

215 Development libraries ( most of which open source)

216 Development libraries ( most of which open source)

217 How-to start a new web project for subsonic - beginner tutorial

218 Subsonic - how-to generate select where queries

219 How-to get the current date and the next date in any cultures with C# ?

220 Start - Run - utils

221 A new article on the CodeProject about the XGrid

222 Cool programs for Windows most of which free ( revised )

223 XGrid revised

224 list of the new fusion related technollogies

225 db trigger for tracking of db changes on sql server 2005 2008 (revised)

226 svn cheat sheet ( revised )

227 important windows folders ( revised )

228 class HowTo - revised

229 ack - better than grep ?!

230 how-to set the log Level of log4net dynamically - console example with configuration

231 nice English phrases

232 Time to learn LINQ ?!

233 Best Windows shortcuts ( revised )

234 Cool programs and tools most of which free ( revised )

235 NUnit and log4net Simple Example Console Application Tutorial

236 todo: upgrage eeepc with

237 An example Console Application in C# ready for debugging and testing of a simple class or library

238 svn cheat sheet (revised)

239 Meet the Object Pool !!!

240 .Net regex cheat sheet

241 If you care about Global Warming and fast cars watch this !!!

242 The new videos for VSTM ... Funny ; )

243 SVN WIN Cheat Sheet

244 db trigger to force versioning in ddl statements on sql server 2005 / 2008

245 Threading Best Practices

246 Log4Net example console program

247 log4net example console app configuration file

248 Opera - again the best browser for blogging !

249 Question : How to utilize your time to the maximum

250 Which phonomenom has been denied for 20 years and reanounced now ?

251 check for required custom class attributes in C# assembly using reflection

252 A simple example Console program for quick testing

253 A great code formatter for Blogger ... Covers the most of the languages used here ...

254 N/A

255 Get name value from extended properties for tables and stored procedures

256 IT Programming Links

257 Only for advanced students !!! Create a ddl trigger for each database

258 the small functions helping self aware database

259 the table structures supporting the self aware database

260 A trigger forcing the sql server 2005 2008 to meta know itself

261 Get name value from extended properties for tables and stored procedures

262 an example of easy to create and use multilingual dictionary page

263 Get back up no matter how-many times you fail ...

264 exec sp_HelpText procUtils_SqlCheatSheet

265 List of emerging / disriuptieve technologies

266 Cold fusion - not anymore bluff

267 USE VERSION AND TIMESTAMP IN NSIS

268 Really missing the WinLogo button on your keyboard ...

269 http sniffers

270 Google did it this time right

271 Perl script to run sql scripts for sql server 2005 2008 files

272 Perl script to run sql scripts for sql server 2005 2008 files

273 how-to backup current directory ( tested on windows server 2003 )

274 cool sites

275 Cool programs for Windows - most of which free ( revised )

276 how-to create new site with iisweb via the command line on IIS 6.0

277 Restart IIS via the command line batch file

278 Corporate lessons translated to Bulgarian ... ;)

279 reinstall windows reminder

280 Find and replace all the debugging calls from the soft project

281 N/A

282 Regex cheat sheet

283 A massive list of cheat sheets ...

284 multiline recursive search and replace perl script for windows

285 recursive find and replace via the command line on Windows with Perl

286 find patterns recursively on Windows with Perl

287 Find and replace text from *.files in Perl

288 how-to execute recursively commands for each directory in perl

289 how-to start and stop IIS site via the command line

290 how-to start and stop sql server 2005 via the command line

291 how-to manage IIS via the command line

292 stored procedur to kill active connections to sql server 2005 2008

293 generate my links for mysql documentation

294 The best cure for Windows Vista ...

295 McDonald paves the ways for the electrified future ...

296 control panel commands

297 catalog of hacks for css

298 C# cheat sheet -- a feak HowTo class that holds copy paste code snippets tips and tricks and cool stuff

299 make sure that ArsClip starts with Windows - I mean really ...

300 C# tips and tricks

301 Cool programs most of which free ( revised )

302 How-to find control recursively in asp.net by id and / or type

303 how-to debug in sql server 2005

304 yet another sql server 2005 meta data query

305 List all db objects in last modified date

306 a template for an example procedure

307 what the ... I have been doing lately on sql server ...

308 procUtils_SqlCheatSheet

309 Cool programs most of which free

310 Getting starting with Drupal

311 Köyhän koodarin GUI testaus työkalu

312 regex for validating e-mails in C#

313 checking if sp parameter can be null

314 regex to get the column names from sql server create table statement with textpas

315 TGIF

316 Generate a parameter list for all SQL Server stored procedures and functions

317 Enumerate trough resource file's values

318 How-to start developing custom applications for Hyperion Essbase

319 How-to open links in background using Firefox 3

320 Grant exec on all stored procedures - a good example of temp table

321 Cool programs most of which free ( revised )

322 firefox add-ons ( revised )

323 Nice slogans

324 Is fusion possible and if yes when is it going to arrive

325 Important folders and files by default in Windows

326 why is USA addicted to oil ...

327 how-to backup all db objects changes in a change log table on sql server 2005

328 from sp_gen get sql server all meta data

329 Cool programs and tools - most of which free (as beer)

330 Knowledge sharing can solve all humanity problems and wikipedia is the best platform making it possible ... so SUPPORT IT !!!

331 Drop all formatter extended props from the stored procedures of sql server 2005

332 print all user defined stored procedure in sql server using cursor

333 Stored procedure for backing up all databases

334 how-to backup all my sql server databases via command line

335 how-to back up all my sql server 2005 databases via sql script

336 advanced trimming functions in PL /TSQL

337 run stored procedure on sql server 2005 start-up

338 sql server 2005 security who does what ?

339 How-to create custom formatting for each result set returned by a stored procedure in the whole sql server 2005 database

340 how-to create installer for asp.net site

341 How-to generate insert statements from a table without including the Primary Key's

342 how-to print all user defined procedures in sql server 2005 - simple use of cursor

343 Six Ways To Embed Click To Communicate in your Application

344 MVC introduction at Tech-Ed Barcelona

345 View open connections in sql server 2005

346 backup all user defined

347 backup all system databases in

348 sql server 2005 cheat sheet as a

349 My cpc.exe cheat sheet

350 Microsoft likes open source so do I

351 how-to enable xp_cmdshell on sql server 2005

352 Again doing some proceses and threads stuff -- this time in C#

353 How-to implement sleep in sql server 2005

354 How-to list all the users and roles in all databases in a SQL Server 2005 instance

355 how-to backup the current directory by adding a timestamp to it in windows

356 Generic database access layer

357 Google Reader + Opera = most efficient news browsing

358 Fire in the neighbourhood

359 google reader shortcuts

360 How delegates work in .Net ( C# example )

361 101 tips for searching google

362 How-to connect to Essbase cube via asp.net and C# - A generic web based report runner

363 How-to copy paste faste code in Visual Studio

364 how-to add programatically TemplateField to run commands on GridView

365 How-to generate extended properties for sql server 2005 with textpad

366 Best shortcuts for Visual Studio 2005 2008

367 how-to generate setters and getters in C# with TextPad

368 how-to create a drop down list with all the countries in the world and their iso codes

369 how-to generate line numbers with textpad

370 how-to get the basedir of an web application in C# asp.net

371 How-to export to text file all user written stored procedures in a sql server 2005 database

372 what is the working hierarchy for web.config files

373 how-to get all the columns of a specific datatype in a database

374 how-to convert string to smalldatetime how to convert string to datetime in sql server 2005

375 how-to get meta data from a table in sql server 2005

376 how-to get meta data from a table in sql server 2005

377 how-to list system objects from sql server 2005

378 how-to write Singleton class in C# asp.net

379 how-to hide a column in gridview

380 How-to debug web pages efficienty with C#

381 HOW-TO Close all the windows from the taskbar on Windows Xp or Vista

382 how-to implement memory efficient asp.net C# application

383 how-to get the file name requested without the extension in asp.net and C#

384 Is Fusion feasible (soon) ?

385 how-to howto convert pdf files to html files with freeware

386 C# asp.net coding usefull tips

387 The main configuration files in Linux and their meaning

388 Template for aspx page with dynamic controls

389 How to generate programatically simple gridview from dataset

390 how -to add extended properties to sql server 2005 programatically

391 Turn objects into byte arrays using effective compression in C#

392 Dynamic controls in asp.net

393 Allmost there

394 how to find recursively controls in C# asp.net

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

396 How to create dynamically controls in C#

397 how to read byte stream from database in C#

398 Encryption Decryption in

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

400 how to compress and decompress DataSet

401 debugging datasets in C#

402 clever debugging in css

403 tabless form using css

404 SQL SERVER 2005 CHEAT SHEET

405 Effective debugging in ASP.NET

406 Convert easily to DOS Unix MAC

407 how to save text documents in UTF-8 with Word

408 creative session logging on Solaris

409 Bash shortcuts from PUTTY

410 alternative of net use command on the cmd prompt on Windows

411 test C# publishing

412 How to restart Ubuntu network connection manager

413 Still wandering why my country joined EU

414 3 frames + javascript redirect =

415 what was the point of the previous one

416 parse automatically firefox history file

417 Installing code2html on Ubuntu

418 mysql höpölöpö

419 simple setup of php based web interface to a mysql database

420 ReadDir.pl

421 Ubuntu stuff

422 vim cheat sheet (update)

423 Revolutionary news

424 Opera fixed the gmail loading

425 multiple redirect in frames with javascript

426 sun solaris cheat sheet

427 perl regex cheat sheet

428 imeem mp3 streeming test

429 Recursive find and replace

430 ENCODE DECODE TO UTF-8 OR WHATEVER

431 Check out meem

432 links regex

433 Firefox add-ons

434 how to download fast podcast with opera and textpad

435 Apache cheat sheet

436 perl oneliners

437 Apache cheat sheet

438 How to delete temporary Windows files

439 Windows environmental variables

440 removeEnters

441 Linux cheat sheet

442 setting up Drupal development environment on Windows XP

443 edit locally run on the server

444 Opera + gmail + fastest search of e-mails

445 gMail + google docs and spreadsheet for the ultimate simplicity

446 Nokia acquired Twango

447 Dual boot Ubuntu and Windows Vista

448 Linux bash cheat sheet

449 VIM VIMTUTOR BEST SHORTCUTS

450 vim cheat sheet

451 How to extract images from pdf files or how to convert pdf to html

452 how to embed personal web albums

453 Power Point Shortcuts

454 WIKI CHEAT SHEET

455 TextPad 5 new tips and tricks

456 The new Textpad 5.0.3 - so how to backup textpad settings ?

457 How to resize my partititions for free

458 cool fusion videos

459 How to activate the Windows panel in Opera 9.20 with single shortcut

460 Transfering you speed dial preferences on different Opera workstations

461 Upgrade to Opera 9.20

462 SOME INTERESTING TECHNOLOGY RELATED LINKS

463 How to close a lot of hanging windows in Windows XP

464 Setting Word for permanent full screen

465 15.10. Automatic generation of perl executables with perl2exe - revised !!!

466 How to call your favorite program from the command line

467 Skype overheating and reboot problem

468 PCAnywhere tips & tricks

469 Windows tips and tricks - add some often used entries into the Run dialor

470 How to change enable disable NetBios over TCP

471 REGISTRY TWEAKS

472 make the fastest google search ever possible

473 How to download stuff from Internet efficiently

474 Efficient usage of Word

475 Get set Windows Time remotely

476 Let the wiser talk - Roth Consulting Perl scripts repository and links

477 About dictionaries

478 exec on Windows

479 Word shortcuts

480 Windows best shortcuts revised

481 SUPER COOL utility for ... . windows to be listed moved resized renamed hidde

482 How to run commands on Windows XP each n minutes on each n day and other for plays

483 start all specfific type of files in Textpad in one command

484 Simple back-up of my blog

485 Using gmail as a virtual drive

486 Textpad quick reference by John Bokma. For the latest version:

487 writing NSIS scripts with TextPad

488 AWESOME ! CONFIGURE TEXTPAD FOR GOOGLE SEARCH

489 EXPORT AND IMPORT TEXTPAD SETTINGS AND SYNTAX FILES

490 Use Google Desktop as command line utility

491 List of useful command line utilities

492 How to create a perl perl2exe nullsoft installer based project with one simple batch file

493 HOW TO TRAP RUN TIME ERRORS IN PERL

494 GENERATE COMMANDS FROM INI FILE PER WORKSTATION

495 Perl documentation generator for Windows XP

496 how to capture a command output or errors

497 Code2HTML by SETH

498 Quantity vs. Quality in (academic) writing

499 Some thoughts for writing thesis ...


This list was generated by :
google blogger list > MyBloggerPosts.csv
cmd /c start /max TextPad MyBloggerPosts.csv

by using GoogleCl

and the simple regex in TextPad:
find:^(.*)\t(.*)$
Replace:\i \1

2010-06-25

a simple perl client for sql server using odbc


#!C:/Perl/bin/perl.exe
use DBD::ODBC ; 
 
 
my $dsn = join "", ( 
"dbi:ODBC:",
"Driver={SQL Server};",
"Server=hostName\\POC_QA;",
"UID=ysg;",
"PWD=pass;",
"Database=CAS_DEV",
);
 
my $user = 'userName';
my $passwd = 'Password';
 
my $db_options = {
PrintError => 1,
RaiseError => 1, 
AutoCommit => 0, #Use transactions 
};
 
my $dbh = 
DBI->connect($dsn, $user, $passwd, $db_options) or exit_msg("Can't connect: $DBI::errstr");
 
open ( FH , ">DbName.txt" ) or die " cannot open DbName.txt " ; 
 
$sth = $dbh->prepare("
 
--select TABLE_NAME from INFORMATION_SCHEMA.TABLES ; 
SELECT TABLE_CATALOG , TABLE_NAME , COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS ;  ")
 
;
$sth->execute;
 
$sth->execute;
while (@row=$sth->fetchrow_array)
{
print "\t",join "\t",@row,"\n";
print FH "",join "\t",@row,"\n";
}
 

First Google Command Line post

Jee the future of blogging ...

2010-06-23

parsing meta data in a dbName TableName ColName tab csv file



 
. 
START ===== D:\ETL\ParseDb.cmd
perl ParseDb.pl DbName.txt
pause 
END ================== D:\ETL\ParseDb.cmd
 
. 
START ===== D:\ETL\ParseDb.pl
use strict ; 

package Class ; 


my $DbInputFile = $ARGV[0] ; 
my ( $DbName , $FileExtension ) = split ( '\.' , $DbInputFile ) ; 

my $DbOutputFile = "$DbInputFile\.out\.xml" ; 

sub main () 
{
    open ( FH_DbOutputFile , ">$DbOutputFile " ) or die " Cannot open $DbOutputFile " ; 
    print FH_DbOutputFile "<DbName>$DbName \n"; 
    my @Tables = {} ; 
    
     # READ ALL ROWS TO LIST
    open (FH_DbInputFile,$DbInputFile);
    my @DbInputFile = <FH_DbInputFile>;
    close (FH_DbInputFile);
    
    foreach my $line ( @DbInputFile ) 
    {
        #debug print "\$line is $line \n " ; 
        my ($DbName , $TableName , $ColName) = split ( '\\t' , $line ) ; 
        print "\$DbName , $DbName , \$TableName , $TableName , \$ColName , $ColName \n" ; 
        print  FH_DbOutputFile "<TableName>$TableName</TableName><ColumnName>$ColName</ColumnName>\n" ; 
    } #eof foreach my $line ( @DbInputFile ) 
    
    #call sub 1 
    #call su
    
    print FH_DbOutputFile  "</DbName>\n" ; 
    close FH_DbOutputFile ; 
} #eof sub main 

sub func1() 
{

}



sub new {
my $self = {};
$self->{'buz'} = 42;
bless $self;
} #eof new const


# action !!!
main(); 


package SomeOtherPackage ; 

 
END ================== D:\ETL\ParseDb.pl
 
. 
START ===== D:\ETL\DbName.txt.out.xml
<DbName>DbName 
<TableName>TableName1</TableName><ColumnName>ColName1
</ColumnName>
<TableName>TableName2</TableName><ColumnName>ColName2
</ColumnName>
<TableName>TableName3</TableName><ColumnName>ColName3
</ColumnName>
<TableName>TableName4</TableName><ColumnName>ColName4
</ColumnName>
<TableName>TableName5</TableName><ColumnName>ColName5
</ColumnName>
<TableName>TableName6</TableName><ColumnName>ColName6
</ColumnName>
<TableName>TableName7</TableName><ColumnName>ColName7
</ColumnName>
<TableName>TableName8</TableName><ColumnName>ColName8
</ColumnName>
<TableName>TableName9</TableName><ColumnName>ColName9
</ColumnName>
<TableName>TableName10</TableName><ColumnName>ColName10</ColumnName>
</DbName>
 
END ================== D:\ETL\DbName.txt.out.xml
 
. 
START ===== D:\ETL\all.txt
 
. 
START ===== D:\ETL\ParseDb.cmd
perl ParseDb.pl DbName.txt
pause 
END ================== D:\ETL\ParseDb.cmd
 
. 
START ===== D:\ETL\ParseDb.pl
use strict ; 

package Class ; 


my $DbInputFile = $ARGV[0] ; 
my ( $DbName , $FileExtension ) = split ( '\.' , $DbInputFile ) ; 

my $DbOutputFile = "$DbInputFile\.out\.xml" ; 

sub main () 
{
    open ( FH_DbOutputFile , ">$DbOutputFile " ) or die " Cannot open $DbOutputFile " ; 
    print FH_DbOutputFile "<DbName>$DbName \n"; 
    my @Tables = {} ; 
    
     # READ ALL ROWS TO LIST
    open (FH_DbInputFile,$DbInputFile);
    my @DbInputFile = <FH_DbInputFile>;
    close (FH_DbInputFile);
    
    foreach my $line ( @DbInputFile ) 
    {
        #debug print "\$line is $line \n " ; 
        my ($DbName , $TableName , $ColName) = split ( '\\t' , $line ) ; 
        print "\$DbName , $DbName , \$TableName , $TableName , \$ColName , $ColName \n" ; 
        print  FH_DbOutputFile "<TableName>$TableName</TableName><ColumnName>$ColName</ColumnName>\n" ; 
    } #eof foreach my $line ( @DbInputFile ) 
    
    #call sub 1 
    #call su
    
    print FH_DbOutputFile  "</DbName>\n" ; 
    close FH_DbOutputFile ; 
} #eof sub main 

sub func1() 
{

}



sub new {
my $self = {};
$self->{'buz'} = 42;
bless $self;
} #eof new const


# action !!!
main(); 


package SomeOtherPackage ; 

 
END ================== D:\ETL\ParseDb.pl
 
. 
START ===== D:\ETL\DbName.txt.out.xml
<DbName>DbName 
<TableName>TableName1</TableName><ColumnName>ColName1
</ColumnName>
<TableName>TableName2</TableName><ColumnName>ColName2
</ColumnName>
<TableName>TableName3</TableName><ColumnName>ColName3
</ColumnName>
<TableName>TableName4</TableName><ColumnName>ColName4
</ColumnName>
<TableName>TableName5</TableName><ColumnName>ColName5
</ColumnName>
<TableName>TableName6</TableName><ColumnName>ColName6
</ColumnName>
<TableName>TableName7</TableName><ColumnName>ColName7
</ColumnName>
<TableName>TableName8</TableName><ColumnName>ColName8
</ColumnName>
<TableName>TableName9</TableName><ColumnName>ColName9
</ColumnName>
<TableName>TableName10</TableName><ColumnName>ColName10</ColumnName>
</DbName>
 
END ================== D:\ETL\DbName.txt.out.xml
 
. 
START ===== D:\ETL\all.txt
 
. 
START ===== D:\ETL\ParseDb.cmd
perl ParseDb.pl DbName.txt
pause 
END ================== D:\ETL\ParseDb.cmd
 
. 
START ===== D:\ETL\ParseDb.pl
use strict ; 

package Class ; 


my $DbInputFile = $ARGV[0] ; 
my ( $DbName , $FileExtension ) = split ( '\.' , $DbInputFile ) ; 

my $DbOutputFile = "$DbInputFi 
END ================== D:\ETL\all.txt
 
. 
START ===== D:\ETL\DbName.txt
DbName1    TableName1    ColName1
DbName2    TableName2    ColName2
DbName3    TableName3    ColName3
DbName4    TableName4    ColName4
DbName5    TableName5    ColName5
DbName6    TableName6    ColName6
DbName7    TableName7    ColName7
DbName8    TableName8    ColName8
DbName9    TableName9    ColName9
DbName10    TableName10    ColName10 
END ================== D:\ETL\DbName.txt
 

THE MIT's vision of the second industrial revolusion ...

how-close are the e-cars and th

Принципи и поуки ...

Важност Принцип
1 Едно е да си баеш на себе си и на другите, второ да знаеш какво искаш , трето наистина да го искаш , четвърто е да знаеш как да го направиш , пето да можеш да го направиш , шесто е наистина да го направиш , седмо да не съжаляваш че си го направил
2 Не си въобгъзявай. Правиж не само себе си , но и останалите на гъз.
3 Не лъжи – така или иначе истината излиза наяве своевременно.
4 Бъди горд. По-добре замълчи и не им обръщай внимание. Бъди душевно и физически изправен, но не и надменен.
5 Мисли тук и сега и действай според реалността, но знай че успешното бъдеще иска стратегическо планиране.
6 Не кради. Ако крадеш , значи не го заслужаваш.
7 Ако не обичаш и пазиш себе си, няма да имаш сили да обичаш и пазиш хората които обичаш около себе си.
8 Не е важно да спечелиш всяка една битка. Важното е да си победител във войната на живота
9 Когато бързаш без да мислиш и си стесиран, малките камъчета правят големи поражения
10 Виртуалният свят оправлява физическия, но той е нищо като му дръпнат шалтера
11 Не бъди по-краставичар от краставичаря. Ако няма какво да кажеш си мълчи като индианец. Като мълчиш не ги гледай във очите.
12 Черната овца никой не я обича както и да мечи или да се опитва да смени козината
13 Сдраво тяло, здрав дух. Можеш да разбереш колко е безценно здравето чак като го изгубиш.
14 Когато има междуособици във тима, не говори за личности а за обстоятелства и проблеми
15 Не се критикувай пред останалите, още по-малко не повдигай темата за твоите грешки …
16 Голмайсторите от чужбина ги търпят само докато правят голове, когато престанат ги ритат първи извън терена
17 В живота побеждават тези които могат и да губят
18 Една злоупотреба с алкохол може да ти струва от 15 дена до цял живот работа или дори живота. За наркотиците дори не си струва да се говори
19 Когато много ти се иска да кажеш нещо и да прекъснеш остананалите изчакай
20 Когато делегираш на някого нещо гледай да не започне да си прави каквото иска … а каквото трябва.
21 Ако казваш на другите :“ Не прави каквото аз правя а прави каквото аз казвам“ си въобгъзяваш и правиш не само другите а и себе си на гъз …
22 Защо пък трябва да се харесваш на останалите след като болшинството от тях така или иначе не те харесва
23 Дойде ли момент когато списъкът ти от задачи стане много голям, може да започеш да си задаваш въпроси
24 Когато лайната ти стигнат до устата , горе главата !!!
25 Ако си сигурен че като кажеш нещо на слушащите те няма да те разберат или ефекта ще бъде 0 въобще има ли смисъл да си отваряш устата
26 От викане файда няма. Колкото повече викаш толкова повече няма да стане !!!

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