Untitled @funbirdcouk - Tumblr Blog

Excel Trick Tip 1: Change dates like 20050923 to one Excel can "understand"

Excel Trick Tip 1: Change dates like 20050923 to one Excel can “understand”

Suppose you are looking at a worksheet which contains dates which can’t be formatted as “real” dates because of their structure: Select the date(s), and use Data tab, Text-to-Columns, [Excel2003:Data|Text to Columns] Which brings up the Text-to-Columns wizard: Even though the dates are fixed width, in this case you can simply click “Next” twice. In step 3 of wizard Select Date, YMD: If you click…

View On WordPress

#date #excel #trick

iPhone sending attachment problems Sending this message failed

When you use certificate authentication you have to set the uploadReadAheadSize in the IIS metabase to your max email size, the default is 48KB so nearly any attachment cannot be sent/forwarded. With the following command you can change the value (in this case 10MB): C:\Windows\System32\inetsrv\appcmd.exe set config -section:system.webServer/serverRuntime /uploadReadAheadSize:"10485760"…

View On WordPress

#attachement #exchange #iPhone #sbs

How to disable Java updates by deleteing registry key via GPO ?

In group policy go to “Computer Configuration” -> “Preferences” -> “Windows Settings” -> “Registry” Right click on “Registry” and select “New”->”Registry Item” In the new registry item select “Delete” then specify the path and item you want to delete. Following values are for java updates HKLM\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Run\SunJavaUpdateSched…

View On WordPress

Install ImageMagick on CentOS

ImageMagick® is a software suite to create, edit, compose, or convert bitmap images. It can read and write images in a variety of formats (over 100) including DPX, EXR, GIF, JPEG, JPEG-2000, PDF, PNG, Postscript, SVG, and TIFF. Use ImageMagick to resize, flip, mirror, rotate, distort, shear and transform images, adjust image colors, apply various special effects, or draw text, lines, polygons,…

View On WordPress

#centos #ImageMagick #Install #linux

How to Start-Stop MySQL Server on CentOS Server

This small post is to explain how you can start/stop/restart MySQL server from command line on CentOS Server. Stop MySQL Server # /etc/init.d/mysqld stop Start MySQL Server # /etc/init.d/mysqld start Restart MySQL Server # /etc/init.d/mysqld restart Hope you find this small tip useful

View On WordPress

#centos #database #mysql

Restore MySQL Database from FileSystem Backup

Always backup your MySQL database with mysqldump but if you didn’t you can restore it from file system. If your backup include the /var/lib/mysql directory, if so then you should be able to restore the database. Each database is contained in a separate subdirectory off /var/lib/mysql, so look for one named with the name of your database (WordPress or any other). To restore it, shutdown the mysql…

View On WordPress

#Backup #filesystem #mysql #restore

Disk Management in Windows 2012 R2

In Windows Server 2012 R2 I to find the option to reassign the drive letter for a CD/DVD drive where the disks are normally managed Run diskmgmt.msc just like previous versions of Windows.

View On WordPress

How do I restart Apache?

On RedHat-like operating systems, you may restart the service using the following command line: ~# /etc/init.d/httpd stop ~# /etc/init.d/httpd start Debian/Ubuntu: ~# /etc/init.d/apache2 stop ~# /etc/init.d/apache2 start

View On WordPress

#apache #apache failed after plesk upgrade #centos #redhat #restart apache #restart apache centos #restart httpd

Group Policy to Turn Off Display

To turn off the user’s monitor/display to save power and extend monitor life using Group Policy & Active Directory, consider the following group policy setting: Computer Configuration > Policies > Administrative Templates > System > Power Management > Video and Display Settings > Turn Off the Display (Plugged In or On Battery)

View On WordPress

#Group Policy #Turn Off Display #Windows #windows1012

Lock screen using Group Policy without setting a screen saver server 2012

To lock screen of workstation using Group Policy without setting a screen saver, after certain time screen will be locked. Computer Config > Policies > Windows Settings > Security Settings > Local Policies > Security Options > “Interactive logon: Machine inactivity limit”

View On WordPress

#active directory #ad #gpo #group polics #loclked #microsorf.windows 2012 #windows 2012. screen

How to change to Admin mode in CMD ?

To start the cmd as a normal user and get the admin privilege later for the same command prompt. This approach will start the cmd as admin or the specific user. runas /user:(UserNameHere) CMD.exe

View On WordPress

#admin.mode #cmd #command prompt #command syntax #switch #Windows

Simple Cake Ingredients Butter 8 ounces Sugar 8 ounces Flour 8 ounces Eggs 4 Baking powder 2 tsp heaped…

Chapli kabab Chapli kabab Ingredients Mince ½ kg Butter 2 ounce Crushed red pepper 1 tbsp Crushed coriander seeds 1 tbsp…

#beef #chapli #indian chapli kebab #indian kebab #kabak #kebab #lam #mince #pakistani kebab

How to find Windows uptime?

Option 1: 1. Go to “Start” -> “Run”. 2. Write “CMD” and press on “Enter” key. 3. Write the command “net statistics server” and press on “Enter” key. 4. The line that start with “Statistics since …” provides the time that the server was up from. The command “net stats srv” can be use instead. Option 2: Uptime.exe Tool Allows You to Estimate Server Availability with Windows NT 4.0 SP4 or Higher…

View On WordPress

#2010 #uptime #Windows #windows 2008 #windows 2012

Configure Dropbox as Service on Windows 2008 Win 7

– Remote desktop to your server (e.g.: with username = YourUser) – On server, download dropbox.exe to C:\ – Start command prompt (with “YourUser” please, the idea is dropbox will be installed under this account credential and its role/right) – Install dropbox by command prompt: "C:\dropbox.exe" /D=C:\Program Files\Dropbox – Run through DropBox setup, login to dropbox, use advanced install,…

View On WordPress

#2012 #dropbox #services #Windows #windows20008

Samsung Galaxy S5 SIM-Free Smartphone Genuine UK Stock - Black

Samsung Galaxy S5 SIM-Free Smartphone Genuine UK Stock – Black

[prosociate]

View On WordPress

Samson Meteor USB Studio Cardioid Microphone - Titanium Black

Samson Meteor USB Studio Cardioid Microphone – Titanium Black

[prosociate]

View On WordPress

Trending Blogs

Recently Viewed Blogs

Untitled