my recent trip

not much, just from sql2000, to sql2005.
add some powershell flavor, get some dotnet 3.5sp1.
make it a little sql2008.
hmmm, lets taste some vs2008express.

it is already like a donnut?
nope, so lets get a bowl of iis and reporting services.
why not get some project server instead?

while i already got xp and win2003server in my hand, my head full of its services..

wait, there some identity integration to serve... and i love while office get the 2007 version.
pyuh, slap my face, and i have sharepoint in my blood...

still, im a batch programmer

unsupported virtual CD-ROM Program for windows XP from Microsoft

copied from::
XP: Small, Free Way to Use and Mount Images (ISO files) Without Burning Them | Windows | Tech-Recipes

Microsoft has an unsupported virtual CD-ROM program. Why buy alcohol or Daemon Tools?

Alcohol and Daemon Tools are excellent software packages that allow users to mount ISO files as virtual CD-ROMs. Yes, there is a way to use that ISO without burning it to a disk.

Although I love these tools, Microsoft has a free, 60kb program that does the same thing! Of course, it is not supported… and it’s not as friendly as the software listed above; however, it works and it’s free.

Here’s the download link:
winxpvirtualcdcontrolpanel

Here’s the readme:

Readme for Virtual CD-ROM Control Panel v2.0.1.1

THIS TOOL IS UNSUPPORTED BY MICROSOFT PRODUCT SUPPORT SERVICES

System Requirements
===================
- Windows XP Home or Windows XP Professional

Installation instructions
=========================
1. Copy VCdRom.sys to your %systemroot%\system32\drivers folder.
2. Execute VCdControlTool.exe
3. Click “Driver control”
4. If the “Install Driver” button is available, click it. Navigate to the %systemroot%\system32\drivers folder, select VCdRom.sys, and click Open.
5. Click “Start”
6. Click OK
7. Click “Add Drive” to add a drive to the drive list. Ensure that the drive added is not a local drive. If it is, continue to click “Add Drive” until an unused drive letter is available.
8. Select an unused drive letter from the drive list and click “Mount”.
9. Navigate to the image file, select it, and click “OK”. UNC naming conventions should not be used, however mapped network drives should be OK.

You may now use the drive letter as if it were a local CD-ROM device. When you are finished you may unmount, stop, and remove the driver from memory using the driver control.

Anug said: lets give it a try....

Automatically email yourself file backups

Geek to Live: Automatically email yourself file backups

google on disk failure experience

StorageMojo » Google’s Disk Failure Experience

keanehan di SSiS2005

ada yang aneh di ssis 2005.
gw mo ambil ole db source langsung tembak ke view dbo.ax_d_engagement_all di database interface, server idjakameyapps03 (sql2000enterprise). ga berhasil.
accessmode=openRowset
rowset=dbo.ax_d_engagement_all

di cek di activity manager, cuma ada 2 koneksi [select * from dbo.ax_d_engagement_all] yang ga kelar2 jalannya.

lalu gw ganti ole db sourcenya menjadi
accessmode=SQL Command
SqlCommand=[select * from dbo.ax_d_engagement_all]
cuma butuh 19 detik dowank untuk komplitnya

duh, sungguh aneh...

check /3gb with wmic

If you are like me, got some 32bit server with 4 Gigs of Ram (max for standard edition of 32bit WinServer2003), You will love to put "/3GB" in your windows startup parameter. But, how to ensure that this switch already working?

I got solution in this page, look in comment #1.
Whether you use WinServer2003 or windowsXP, you can use the same method (I not use Vista yet, so I cannot checked it).

The Syntax is:
wmic /node:<insert_server_name> OS get MaxProcessMemorySize

or, for example, in my computer it will be
wmic /node:JK080251 OS get MaxProcessMemorySize

In my XP machine (2 Gigs of RAM) i got 2097024.
In my /3GB server (4 Gigs of RAM) I got 3145600.

seek for dependencies

in sql server 2000, looking for sql dependencies is not that easy.
at least in my humble opinion.

I try to compile from various sources, and this is the result:

/* version 0.90 */
declare @cariIni varchar(150);
set @cariIni = 'vw_d_engagement_all'

--//table 1//
select routine_name, routine_type from information_schema.routines
where routine_definition like '%'+ @cariIni +'%'

--//table 2//
select routine_definition from information_schema.routines
where routine_name like '%'+ @cariIni +'%'

--//table 3//
exec sp_depends @cariIni

--//table 4//
select distinct so.name, so.type
from syscomments sc inner join sysobjects so on sc.id = so.id
where charindex(@cariIni, text) > 0

--//table 5//
exec sp_MSdependencies @cariIni, null, 131527

--//table 6//
exec sp_MSdependencies @cariIni, null, 1053183

expect me to update this procedure in next following days..