Exchange versus gmail film.

http://youtu.be/3eIEwRKWdSA

Posted on 12:24 PM by Nathan aka Mysteryn11 and filed under , | 0 Comments »

Really nice comparison of Intel processors

Useful to have handy if you’re spec’ing up PCs.

http://allyncs.com/docs/IntelProcGuide.html

Posted on 1:21 PM by Nathan aka Mysteryn11 and filed under | 0 Comments »

Free plugin for Office and Google Docs

I'm testing it at the moment. It should allow upload /open of Google docs in Office 2010. :)
Posted on 2:11 PM by Nathan aka Mysteryn11 and filed under | 0 Comments »

Rebuilding SQL Server on different hardware after a failure

 

useful to have … one day you may need it.

Winking smile

http://www.mssqltips.com/tip.asp?tip=2425

Posted on 9:24 AM by Nathan aka Mysteryn11 and filed under | 0 Comments »

Hyper-V Backup

http://www.rectiphy.com/product-tour/

Posted on 10:48 AM by Nathan aka Mysteryn11 and filed under , | 0 Comments »

Hyper-V Remote management (of Core)

 

Hyper-V Remote Management Configuration Utility

http://archive.msdn.microsoft.com/HVRemote

Posted on 10:46 AM by Nathan aka Mysteryn11 and filed under , | 0 Comments »

T-SQL Script–Change compatibility level all databases and set recovery mode.

 

-- Declare variable used by the cursor

DECLARE @databasename AS nvarchar(128)

-- Create a cursor with all custom databases on the server

DECLARE db_list CURSOR FOR

SELECT [name] AS databasename

FROM master.dbo.sysdatabases

WHERE [name] NOT IN ('master', 'tempdb', 'model', 'msdb')

-- Open the cursor

OPEN db_list

-- Fetch next database name from the list and process it

FETCH NEXT FROM db_list INTO @databasename

WHILE @@FETCH_STATUS = 0 BEGIN

DECLARE @sqlCmd AS nvarchar(4000)

-- Set master as database

EXECUTE dbo.sp_ExecuteSQL N'USE [master]'

-- Modify logging mode instantly

SET @sqlCmd = N'ALTER DATABASE [' + @databasename + N']

SET RECOVERY FULL WITH NO_WAIT'

EXECUTE dbo.sp_ExecuteSQL @sqlCmd

-- Here I’m a little unsure but I think this will work

SET @sqlCmd = N'ALTER DATABASE [' + @databasename + N']

SET COMPATIBILITY_LEVEL = 100' -- valid values are 80, 90, 100

EXECUTE dbo.sp_ExecuteSQL @sqlCmd

FETCH NEXT FROM db_list

INTO @databasename END

-- Close and release the cursor

CLOSE db_list

DEALLOCATE db_list

Posted on 9:44 AM by Nathan aka Mysteryn11 and filed under , | 0 Comments »

Continuous improvement from an IT blogger’s perspective.

http://www.basilv.com/psd/blog/2009/continuous-improvement-framework

Posted on 12:39 PM by Nathan aka Mysteryn11 and filed under | 0 Comments »

The Lefthand SAN Technology Overview.

I’m doing some research on SANs and found this nice presentation of the HP Lefthand technology. Lefthand was an acquisition that HP made recently which seems to give some cool possibilities. I like the idea of VSA (Virtual SAN appliance) and reusing old servers as SAN nodes!


HP LeftHand SAN Technology Overview from Simon Seagrave on Vimeo.
Posted on 3:06 PM by Nathan aka Mysteryn11 and filed under , | 0 Comments »