[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

[Printer]Zebra Printer - Ribbon cut randomly

Situation:

When I reload new Labels and Ribbons on a printer, somehow the ribbons were cut randomly.
I have to reload it every time when it happened.

PowerShell Notes - continuing adding

Query Active Directory Domain Controller Info

•  Current AD server site belongs to

•  Current AD Site

[Modified] Double Click to Switch Wireless And LAN

Situation:
Since I'd created the program for my clients.(Link here) Recently they told me they couldn't swap successfully bewteen WAN and LAN.

[VB]Run-time error 339: VB6 apps run Failed on Windows 7 64bits system

Situation:

Lack of some components, pics are below

[Office]Excel - Two Windows are opeing One blank the other a file

Solution:

Win7:

• go to

         C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART

• delete

         *.xsb 

Visual Studio 2012 Professional x32 not stable on Windows 7 x64

Situation:

Visual Studio 2012 used to crush after opening some files such like C++, VBScript, etc...

Users of Visual Studio may lose the ability to open or create C++ or JavaScript files or projects or VBScript files after the .NET Framework 4.5 is updated. This fix corrects the flaw in Visual Studio.

When send a PDF that embeded in FireFox as an Email attachment , it became a .jsp file

Situation:
When send a PDF that embeded in FireFox or IE10 as an Email attachment , it became a .jsp file

Double Click to Switch Wireless And LAN

Design concept:

	LAN	WIRELESS		LAN	WIRELESS		LAN	WIRELESS
IF	ON	OFF	DO	OFF	ON	SO		ON
IF	OFF	ON	DO	ON	OFF	SO	ON
IF	OFF	OFF	DO	ON	OFF	SO	ON
IF	ON	ON	DO	OFF->ON	OFF	SO	ON