Upgrade Storage array on HP server

To upgrade a HP raid1 disk array with 2 disks of each 70 gb to bigger disks.

1. First make sure that the array is functioning and replicated.

2. Pull on 70gb disk. Insert a bigger one.

3. Wait for array to finish replicating disks.

4. Pull the second 70gb disk. Insert a bigger one.

5. Wait for array to finish replicating.

6. Open HP Array configuration utility.

7. Create a new logical diskspace on the free space.

All this done with all systems live on the hostserver!

Identify version of SQL Server installed

To identify version run query: select @@version

Or on older versions (pre2005) run query:

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

And you get served with information layed out like below:

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
    Jul  9 2008 14:43:34
    Copyright (c) 1988-2008 Microsoft Corporation
    Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

Twitter lingo

Found a great site for getting the grip on all the twitter lingo floating around. Finally I know what the hell a retweet is about!

http://kikolani.com/twitter-lingo-tips-twitter-facebook-users.html

Allow pdf documents to be opened directly in browser

In sharepoint 2010, the default pdf-documentbehaviour is to save to disk. A method that isn’t optimal.

To change this to open directly in browser:

On your sharepointserver.

1. Application Management> Manage web applications > [Your site] > General Settings

2. Change Browser File handling to Permissive

3. Reset IIS

Note that is is considered bad security practice by some, but in smaller user groups this is the only way to discourage users from saving documents locally.

References:

http://www.sharepointedutech.com/2010/05/05/opening-pdfs-in-sharepoint-2010/

http://blog.mikehacker.net/2010/05/03/unable-to-open-pdf-directly-from-sharepoint-2010/

Handy site to get icons

Visit http://www.iconfinder.com/ to satisfy all your icony needs. Remember the days when you had to create your own icons? Now we don’t need to!

Create quickerease job in Backup Exec 2012

To create a quick ereasejob
1. Register Backup Exec powershell modules in Windows.
notepad $profile.AllUserssCurrentHost , add import-module “\program files\symantec\backup exec\modules\bemcli\bemcli” Create document if it doesn’t already exist.
2. Allow signedScripts: />set-executionpolicy remotesigned
3. Create ereaseTape.ps1 . Add Line : get-betapedrivedevice "[YOURDEVICENAME]" |submit-beerasemediajob -confirm:$false
4. Create startScript.bat. Add line: powershell -file "\Script\ereaseTape.ps1"
5. Create Windows Scheduled Task to start startScript.bat whenever you want.
 
Now, I only do it like this because I haven’t found my way around the new and much more confusing be2012. But the Powershell capabilities are looking good.
References:
http://www.symantec.com/connect/articles/preparing-your-powershell-environment-run-bemcli-and-scripts