[SQL]How to calculate "Julian day"

select julian_day(current_date)-julian_day('2011-12-31')

from any files

-or the first date of year and then + 1                                   

select julian_day(current_date)-julian_day('2012-01-01') + 1

from any files

If files have over 1 row to be appealed, added DISTINCT before Julian_day

select DISTINCT julian_day(current_date)-julian_day('2011-12-31')

from any files

-or the first date of year and then + 1                                   

select DISTINCT julian_day(current_date)-julian_day('2012-01-01') + 1

from any files

----------------------------------------------------------------------------------------------

Because Julian Day is representing a number of days from January 1, 4713 B.C.

[Server] Windows Server 2012 Evaluation Edition Converted to Legal Edition

Situation:

We used the trail edition to develop and test new product. Recently we have a valid and legal serial number. But when I tried to enter and activate it. It said "not valid" and not activated.
It's weird to me. So I dig Google and find a way to active it.

[SQL]MSACCESS.EXE error - MSVCR90.dll

We have an application built on Access app and needs to connect to SQL Server
One day we upgrade the PC to Windows 7 64bits and Microsoft Office 2010 32bits
The error is encountered
Error msg:

Faulting application name: MSACCESS.EXE, version: 14.0.4750.1000, time stamp: 0x4b8bade7

Faulting module name: MSVCR90.dll, version: 9.0.30729.6161, time stamp: 0x4dace5b9

Exception code: 0xc0000417

Fault offset: 0x0006ccd5

Faulting process id: 0x9a4

Faulting application start time: 0x01cf16d8d2a77b43

Faulting application path: C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE

Faulting module path: C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCR90.dll

Report Id: 2140374c-82cc-11e3-9516-c81f662d3db5

[Life]Honesty is the Key for the career and the lifetime

Recently we hired a new guy that has been experienced several IT skills in terms of his resumes
He said he know lots skills include AIX, AS400, Server, Unix, Linux, SQL, Exchange
Finally he came to work, then I talked with him and found he knows a little bit of them.
Why can I found out? Because I’ve known most of these skills for a while.

[Hyper-V]Mapping a USB device on VMs

Situation:
Recently I need to use a USB wireless adapter into my VM, so I can test my internal/external environment on my applications
But the problem is how I can add a USB adapter into one of my VMs?

[SQL] Microsoft Access Error “3146 ODBC-Call Failed”, While trying connect to SQL

Situation:
Error Message:
The Specified DSN contains an architecture mismatch between the Driver and Application

[Active Directory]How to determine which DC was supposed to being 5 FSMO

I was excited the company that gonna upgrade server to Windows Server 2012
According the last article : “[Active Directory]How to migrate FSMO to other Domain Controllers (DC) “ (Link is here)
We will have a question following that “How to determine which DC was supposed to installing each of 5 FSMO”?

[Active Directory]How to migrate FSMO to other Domain Controllers (DC)

Situation:
Last week, I had a very good discussion with a company in TN, and they wanted to have a migration of DC to another Server. Something we need to take care of it before doing it, especially it’s a main GC role even it's not a FSMO.
First, you really need to know what the main 5 FSMO roles mean that on DCs before you do anything on DC,?

Original PNG blueprint is here

[SQL]Search Password Policy Enforced setting for all visible SQL Instance in Local LAN

Situation:
Basically if you want to know what’s the Login policy for you DB instance, we used to use this T-SQL command

select * from sys.sql_logins

They will tell you some relevant info.

But if you want to know multi instances around your Local Network environment, how to do that?

Login each SQL server and type this command?? Yes, it is a way to reach this. But are there any other ways that I can do this?

Yes, “PowerShell”

[SSD]Migrate System from Tranditional Hard Disk to SSD

Situation:
My PC's OS is Windows Server 2012 and has a Hyper-V that included 3 SQL server inside, recently I bought a SSD driver, and prepare migrate it to SSD


Tools:

• Symantec Ghost 15
• Old Hard Disk
• New SSD
• Dell PC