SQL 2005 MM-DDD-YY format

To format a date as MM-DDD-YY

Today:
REPLACE(right(UPPER(convert(varchar(20),getdate() ,06)), len(convert(varchar(20),getdate(),06))), ‘ ‘, ‘-‘)

to get Yesterday’s date:

PRINT REPLACE(right(UPPER(convert(varchar(20),getdate()-1 ,06)), len(convert(varchar(20),getdate()-1,06))), ‘ ‘, ‘-‘)

Extra date format for Microsoft SQL:
Continue reading SQL 2005 MM-DDD-YY format

Saudi Aramco selects Actenum DSO/Upstream software for scheduling Exploration drilling

Vancouver, BC, 22 June 2011 – Actenum Corporation today announced that Aramco Services Company’s subsidiary of Saudi Aramco, the world’s largest petroleum company?has acquired DSO/Upstream for use by Saudi Aramco’s Exploration Department.

DSO/Upstream will enable Saudi Aramco users to manage exploration drilling programs on a multi-year basis, balancing scheduled activities against available resources and departmental targets. Using DSO/Upstream’s multi-objective optimization facility, together with its integrated scenario generation and analysis features, schedulers will be able to track and control key metrics as drilling programs are created and updated over time.

[ad#ad-2]

Continue reading Saudi Aramco selects Actenum DSO/Upstream software for scheduling Exploration drilling

Protected: Avaa

There is no excerpt because this is a protected post.

Cisco 7940/7960 Protocol Application Invalid

The easiest way to fix this is to setup Windows DHCP or Linux DHCP and pass TFTP IP address from your DHCP Server.

I fixed my issue by setting up DHCP in Windows 2003, then as per Cisco recommendation, I added the option 150 to the DHCP, check this link: http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a008055c1fe.shtml

There is another step, in Windows 2003, . . . → Read More: Cisco 7940/7960 Protocol Application Invalid

Installing IIS – issue with staxmem.dll

If you are receiving error copying staxmem.dll then

Click Start, go to RUN, type cmd press enter
type the following command:

esentutl /p %windir%/security/database/secedit.sdb

then go to Control Panel, Add/Remove Program then Add/Remove Windows Components, first, uncheck Internet Information Services (IIS) —-Make sure to backup your Intepub folder just in case

click next to remove it. then . . . → Read More: Installing IIS – issue with staxmem.dll

Peshvar back in the days

. . . → Read More: Peshvar back in the days

Coverting a Cisco 7940 SIP to SCCP

I had worked on this for almost two days and finally managed to figure it out… lots of people are having issues converting Cisco 7940 from SIP to SCCP…

Make sure that you have the following files in your TFTP server:

– SIPdefault.cnf: change the first line, which is image_version: “P00307000200”, you might have something like “P003-08-8-00” which . . . → Read More: Coverting a Cisco 7940 SIP to SCCP

sox: Can’t open input file ‘/var/lib/asterisk/mohmp3/

in FreePBX sometimes you might get the following error message in you upload an MP3:

Error Processing: “sox: Can’t open input file ‘/var/lib/asterisk/mohmp3/

I convert the MP3 file to WAV and it worked ok… make sure that you convert it to 11,025 kHz, 16 Bit, Mono . . . → Read More: sox: Can’t open input file ‘/var/lib/asterisk/mohmp3/

Falazy

I got this from a friend of mine in Bahrain and I thought I should share this with my . . . → Read More: Falazy

How to install Windows Powershell on Windows 2008

Microsoft PowerShell comes as Features under windows 2008. To install Powershell go to Server Manager, Features, click on Add Features, scroll all the way down, select Windows PowerShell. it might take up to 20 minutes for Powershell to be . . . → Read More: How to install Windows Powershell on Windows 2008