MS SQL Hyper-V Replication

If you are running MS SQL on Hyper-V, I highly recommend that you enable hyper-V replication. Hyper-v replication is recommended for DR (disaster recovery), however, you can use it if you have two servers within the same network/data-center.

When enabling replication, you must have a valid SSL certificate if you do NOT have an active directory. So . . . → Read More: MS SQL Hyper-V Replication

Audiocodes IP Address

In some cases, you might not be able to access Audiocodes after resetting the unit. This could happen if you are running a DHCP server that response to bootp request.

Audiocodes, whether you have assigned an IP or it is set to DHCP, will send a bootP request…

I have seen this happens when pfsense is used as . . . → Read More: Audiocodes IP Address

SMS to Kuwait – SMS to Saudi Arabia

I came across a great web site for sending SMS to Kuwait and other gulf countries such as Saudi Arabia, United Arab Emirates, Qatar and Bahrain.

They provide direct routes and offer 100% delivery. here is the . . . → Read More: SMS to Kuwait – SMS to Saudi Arabia

Audiocodes Mediant 1000 might lose its network connection if using PoE switch

If you connect Mediant 1000 M1k to a PoE enabled port on a switch, you might lose network connectivity to Audiocodes every 20 seconds. To resolve this issue, simply disable PoE feature on the switch and that should fix the problem.

I had the same issue with Audiocodes when I had it connected to Juniper EX 3300 . . . → Read More: Audiocodes Mediant 1000 might lose its network connection if using PoE switch

Ping NetBIOS name from Debian

In order to ping a Windows hostname/NetBios from Debian you must install the following package:

:~# apt-get install winbind

Please note that you must also have samba installed and enabled the following line under /etc/samba/smb.conf:

wins support = yes
name resolve order = lmhosts host . . . → Read More: Ping NetBIOS name from Debian

MS SQL how to replace line feed or carriage return with space

SQL 2000, SQL 2005 and SQL 2008

You can replace carriage return and line feed in a field by running the following query:

update tbl1 set field1 = replace(field1,0x0a,’ ‘)

And
update tbl1 set field1 = . . . → Read More: MS SQL how to replace line feed or carriage return with space

net-snmp /usr/bin/ld: cannot find -lperl

You might get the following error message when installing net-SNMP:

/usr/bin/ld: cannot find -lperl

This means that you are missing the libperl-dev which can be installed by using apt-get or yum:

sudo apt-get . . . → Read More: net-snmp /usr/bin/ld: cannot find -lperl

ECHO in Telecom

Echo cannot origin from an VoIP network. But delay times due to codecs and buffering quickly makes even the slightest echo recieved very annoying. Echo is generated by digital <-> anolog conversions either in the PSTN or “at the other end” (overlaps of ear & mouth)”.

If you hear echo then the source of . . . → Read More: ECHO in Telecom

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