[Life] updated slowly…cuz I am preparing MCSA exam

Focusing on SSIS
http://msdn.microsoft.com/en-us/library/bb522537.aspx

[CMD] The process cannot access the file because it is being used by another precess

Situation:

I created a “batch” file for transfering data from Mainframe to PC and run a VBSCript to do something.

Today when I did this, it showed this up and I use “unLock” tool to check, there was none a process occupying this program

[SQL] note – FILESTREAM course practice

• Keep your version of SQL Server and Operation System on the same bits (32-bits or 64-bits)
• open SQL Server Configuration Manager
• Right click your instance of SQL server –> Propertites

[Life] – An essential technical sense is important for a person to operate a computer

Recently we upgraded/replaced the new terminal for our company

A lady who’ve been working for our company for several yrs

[SQL] Use LinkServer connect to IBM AS400

 

Install IBM iSeries Navigator, make sure “iSeries Access for Windows .NET provider” option is checked

If you don’t have the CD-Row, please go to here to order

[Life] Not an IT Article- About My gf's grandmother

This is not a record for my IT life, but it's a part of my life.

CMD - How to add UNC printer automatically

Situation:
One of my departments told me that they want to add one more printer which been shared on the LAN.
OS: I need to go their desk and install it each one by one? Yes, I can do that..  But do I have other way to achieve this goal?

[SQL] How To Check The Last Time of Backup

Tool:

MSSQL

[Active Directory(AD)] Use PowerShell and Command to export Active Directory

Traditional Commands

Commands: csvde, ldifde
AD Attributes: ADSIEDIT.msc tool

[SQL]SQL and Active Directory - How to use SQL to Query AD

Situation:

Why just don't use AD management Tool or PowerShell to query rather than using MSSQL!!!

This's definitely a tough problem to figure it out. but I am an IT guy, when you are experiencing issues and need to engage it without serious irritative reaction