The Real Story behind the Story

URL/Link Extractor

2012-01-29T13:45:00.000-08:00

Ever want to extract a list of URL's from a website?

Great link which also allows you to donwload the extraction to CSV's and excel

www.copoint.co.uk/LinkExtractor

Enjoy

Searching For users within an Active Directory group - .Net 3.5 Style!

2009-11-30T05:58:00.000-08:00

In .Net 3.5, Microsoft has introduced a new library that makes search for users/groups etc in Active Directory a doodle.

This new namspace is :
System.DirectoryServices.AccountManagement

As an example of its flexibility i have included 2 examples:

Example 1: Getting a Principals' (user) Details from AD:

 using (PrincipalContext ctx = new PrincipalContext(ContextType.Domain, "[ADSERVER]"))
          {
              Principal principal = Principal.FindByIdentity(ctx, IdentityType.SamAccountName, "[USERNAME]");
              Console.WriteLine(principal.DisplayName);
}

Example 2: Getting All users belonging to an AD Group:

 using (PrincipalContext ctx = new PrincipalContext(ContextType.Domain, "[AD SERVER]"))
           {
              
               GroupPrincipal groupPrincipal = GroupPrincipal.FindByIdentity(ctx,[GROUP DN or GROUP NAME]);

               PrincipalSearchResult<Principal> results = groupPrincipal.GetMembers(true);

               foreach (Principal p in results)
               {
                   Console.WriteLine(p.Name);
               }              
              
           }

VS 2008 or MSBuild Bug

2009-09-23T07:38:00.000-07:00

While i was trying to add a reference to an external project I came accross the following error while compiling a WPF project in xaml:

Error 1 Unknown build error, ''clr-namespace:[MyNameSpace]' mapping URI is not valid. Line 4 Position 21.'

After a bit of research I realised the problem was with the Assembly Name having spaces within.
To fix this right click the project and change the assembly name so that there are no spaces.

Running Spotify in the background on the IPhone

2009-09-13T13:00:00.000-07:00

Since Apple has not allowed applications to run simultaneously on the IPhone, applications like Spotify can only work when they are the only application running. If you would like to perform a task such as browsing the web while listening to music from Spotify, you need to have a 3rd party application installed on your iPhone. This 3rd party application is called backgrounder. It enables any application to run in the background to leave your iPhone free to run other applications. This is useful if you would like to leave an application and come back to it later, but not to close the application. eg: To listen to Spotify while checking your SMSs.

Because the application (Backgrounder) would never be approved on the app store in a million years (Apple are slightly controlling and want every single application reviewed by them for "quality control" or more likely "consumer control") you have to download it from another installer application called Cydia. Before you can run Cydia, your IPhone needs to be jailbroken. If your IPhone is not Jailbroken, you can run through this quick tutorial to unlock your IPhone in minutes.

Once your IPhone is Jailbroken:

1) Install backgrounder from cydia.

2) A new icon will appear on your IPhone, this is the actual backgrounder application. If you like, from here you can add some cool settings for applications that you will use backgrounder with.

3) When you are in the Spotify application, hold the home button down for 3 seconds.This will put Spotify into background mode.

3) Voila!! you are now able to run other applications while Spotify is playing your favourite Spice Girls song.

Jailbreak and your Iphone!

2009-09-13T12:51:00.000-07:00

What is Jailbreaking?

Jailbreaking is the process by which an IPhone firmware is modified to allow applications that apple would otherwise not allowed to run on the IPhone. Jailbreaking adds an unofficial installer application (similar to the AppStore) called Cydia or Icy which let you download many more 3rd party applications that Apple have hidden/blocked from users of the IPhone to "protect" them.

There are very minor risks involved with jailbreaking and iPhone. Worst case, if something goes wrong, you will have to reset it to factory settings through ITunes. In this scenario, you would lose all your settings/apps.

Two of the main reasons to Jailbreak your IPhone is to install 3rd party applications, or to Unlock your IPhone so that it works on any provider.

I have written a simple tutorial to Jailbreak your IPhone.

Jailbreak your Iphone (3.0) with RedSn0w

2009-09-13T12:13:00.000-07:00

This guide & tutorial will show you how to use and application called RedSn0w to jailbreak your iPhone 2G, iPhone 3G IPhone 3GS, or iPod Touch 2G. If you would like a better understanding of what jailbreaking is, or how it works, please read this.

This tutorial will explain how to use Jailbreak your phone in Windows, but RedSn0w works in windows or Mac OS X almost exactly the same.

(Please note: If you would like to Unlock your phone from your locked in network provider, you will have to Jailbreak your phone first)

1) Firstly, before doing anything, check what firmware you have on your Iphone. Currently RedSn0w 0.8 supports up to firmware 3.0.1 (NOT 3.1) please check here for the latest supported versions direct from the guys who created RedSn0w

2) Download 2 things: RedSn0w and your corresponding firmware that you have on your phone from here.

3) Unzip and launch RedSn0w.

4) Click "browse" and select the 3.0 firmware you downloaded in step 2. (NOTE: If you are running firmware 3.0.1, please use Firmware 3.0 to Jailbreak.

5) Once RedSn0w has verified the firmware, click next.

6) Select "Install Cydia" and click next. (I would reccomend unselecting Icy as this could cause other issues)

7) RedSn0w will guide you through the Jailbreaking process and tell you to turn off your phone and hold the power/home buttons at different times. follow these steps as written on the screen.

8) If done correctly, your iphone will reboot and the Jailbreak should start. it could take up to 15 minutes so be patient. Click Finish on RedSn0w and wait for the Jailbreak to complete.

9) After your Iphone reboots, you should see a new icon on your iphone called "Cydia" from here you can download a load of applications.

10) When a new firmware comes out (EG: 3.1) DO NOT UPGRADE. This will disable your jailbreak. and you will lose all jailbroken apps and also cydia.

Enjoy!

Spotify and using apple remote control

2009-07-19T16:19:00.000-07:00

The other day i came across a great source for music called Spotify. Spotify is a proprietary peer-to-peer music program that allows instant listening to specific tracks or albums with almost no buffer delay.

I wanted to be able to use my Apple Remote Control to change tracks, but unfortunatley Spotify does not open up the API to accept inputs for changing controls. But there is a solution!

Spotify Mac Remote is a plugin for Spotify that allows you to use your Mac’s remote control to Play, Pause and change tracks.

1) Firstly you need to Install SIMBL
2) Secondly download the plugin
3) Extract the the zip file and place the .bundle file in (Macintosh HD /Library/Application Support/SIMBL/Plugins/)
4) Restart Spotify and you should be flying!

For more information visit http://themacbox.co.uk/smr/

Copying over configuration to a 64Bit IIS Server

2009-06-25T08:58:00.001-07:00

When copying over configuration settings for IIS when moving you web sites to a new server, You can run into problems when copying over the configuration to a 64bit machine from a 32 bit machine. This can occur after using the iiscnfg.vbs script. You will receive a Service Unavailable error when navigating to your web site.

also in the event log you will get the following error:

ISAPI Filter ‘C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll’ could not be loaded due to a configuration problem. The current configuration only supports loading images built for a AMD64 processor architecture. The data field contains the error number. To learn more about this issue, including how to troubleshooting this kind of processor architecture mismatch error, see http://go.microsoft.com/fwlink/?LinkId=29349.

To resolve this issue:

1) Disable the 32 bit mode for your web server
cscript C:\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0

2) Register ASP.NET 2.0 as the default framework for the server
C:\Windows\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i

3) Restart IIS
c:\iisreset

for more information on exporting configuration to a new server or moving your web sites to a new server click here

Moving IIS Websites to a new server

2009-06-25T08:41:00.000-07:00

Many people will sooner or later need to move there IIS web sites to a new server.
Either becuase of popularity and the need for more hardware, for clustering or even to virtualise the web server.
You can easily create a new web site on the new server and just copy over the original web site.
But what about permissions? what about all the configuration settings?
IIS offers a vbs script to copy a web site over to a new server.

1) to run the configuration copy script execute the following:
C:\WINDOWS\system32>iiscnfg.vbs /copy /ts [Target Server] /tu [Target Server username] /tp [Target Server Password]
this will backup your server and do the rest for you, including copy over the metadata.
(for more information on iiscnfg.vbs click here)

2) You will also need to manually copy over the actuall web site files, the iiscnfg script only copying over configuration

If you are exporting the configuration to a 64 bit iis server from a 32 bit server you will get a "Service unavailable" error when trying to access your web site. To more information to resolve this click here

Restoring multiple database files and catalogs programatically in SQL Server 2005/2008

2009-06-16T09:00:00.000-07:00

I am restoring a database onto another server with different drive sizes and mappings. The thing is, I have over 100 catalogs to restore.
I don't want to have to define each catalog name and its new location Like below:

    RESTORE DATABASE Northwinds
  FROM DISK = 'C:\db.bak'
          WITH MOVE 'Catalog1' TO 'D:\Catalog1'
          WITH MOVE 'Catalog2' TO 'D:\Catalog2'
          WITH MOVE 'Catalog3' TO 'D:\Catalog3'
          WITH MOVE 'Catalog4' TO 'D:\Catalog4'
          WITH MOVE 'Catalog5' TO 'D:\Catalog5'
          WITH MOVE 'Catalog6' TO 'D:\Catalog6'
          ...WITH MOVE 'Catalog100' TO 'D:\Catalog100'

This would just take forever.

I found a usefull script that will generate the restore code and also exectue it if required.
(I modified the script to add support for catalogs)

(This script below will work on SQL 2005, to get it to work on SQL 2008 include the following lines by uncommenting them)

--TDEThumbprint varbinary(32) NULL

--CompressedBackupSize binary(8) NULL

IF OBJECT_ID(N'RestoreDatabase_SQL2005') IS NOT NULL

DROP PROCEDURE RestoreDatabase_SQL2005

GO

CREATE PROCEDURE RestoreDatabase_SQL2005

    @BackupFile NVARCHAR(260),

    @NewDatabaseName sysname = NULL,

    @FileNumber INT = 1,

    @DataFolder NVARCHAR(260) = NULL,

    @LogFolder NVARCHAR(260) = NULL,

    @CatalogFolder NVARCHAR(260) = NULL,

    @ExecuteRestoreImmediately CHAR(1) = 'N',

    @ChangePhysicalFileNames CHAR(1) = 'Y',

    @ChangeLogicalNames CHAR(1) = 'Y',

    @DatabaseOwner sysname = NULL,

    @AdditionalOptions NVARCHAR(500) = NULL

            AS

    SET NOCOUNT ON;

DECLARE @LogicalName NVARCHAR(128),

    @PhysicalName NVARCHAR(260),

    @PhysicalFolderName NVARCHAR(260),

    @PhysicalFileName NVARCHAR(260),

    @NewPhysicalName NVARCHAR(260),

    @NewLogicalName NVARCHAR(128),

    @OldDatabaseName NVARCHAR(128),

    @RestoreStatement NVARCHAR(MAX),

    @Command NVARCHAR(MAX),

    @ReturnCode INT,

    @FileType CHAR(1),

    @ServerName NVARCHAR(128),

    @BackupFinishDate datetime,

    @Message NVARCHAR(MAX),

    @ChangeLogicalNamesSql NVARCHAR(MAX),

    @AlterAuthorizationSql NVARCHAR(MAX),

    @Error INT;

DECLARE @BackupHeader TABLE

    (

                BackupName NVARCHAR(128) NULL,

                BackupDescription  NVARCHAR(255) NULL,

                BackupType smallint NULL,

                ExpirationDate datetime NULL,

                Compressed tinyint NULL,

                Position smallint NULL,

                DeviceType tinyint NULL,

                UserName NVARCHAR(128) NULL,

                ServerName NVARCHAR(128) NULL,

                DatabaseName NVARCHAR(128) NULL,

                DatabaseVersion INT NULL,

                DatabaseCreationDate  datetime NULL,

                BackupSize numeric(20,0) NULL,

                FirstLSN numeric(25,0) NULL,

                LastLSN numeric(25,0) NULL,

                CheckpointLSN  numeric(25,0) NULL,

                DatabaseBackupLSN  numeric(25,0) NULL,

                BackupStartDate  datetime NULL,

                BackupFinishDate  datetime NULL,

                SortOrder smallint NULL,

                CodePage smallint NULL,

                UnicodeLocaleId INT NULL,

                UnicodeComparisonStyle INT NULL,

                CompatibilityLevel  tinyint NULL,

                SoftwareVendorId INT NULL,

                SoftwareVersionMajor INT NULL,

                SoftwareVersionMinor INT NULL,

                SoftwareVersionBuild INT NULL,

                MachineName NVARCHAR(128) NULL,

                Flags INT NULL,

                BindingID uniqueidentifier NULL,

                RecoveryForkID uniqueidentifier NULL,

                Collation NVARCHAR(128) NULL,

                FamilyGUID uniqueidentifier NULL,

                HasBulkLoggedData bit NULL,

                IsSnapshot bit NULL,

                IsReadOnly bit NULL,

                IsSingleUser bit NULL,

                HasBackupChecksums bit NULL,

                IsDamaged bit NULL,

                BeginsLogChain bit NULL,

                HasIncompleteMetaData bit NULL,

                IsForceOffline bit NULL,

                IsCopyOnly bit NULL,

                FirstRecoveryForkID uniqueidentifier NULL,

                ForkPointLSN decimal(25, 0) NULL,

                RecoveryModel NVARCHAR(60) NULL,

                DifferentialBaseLSN decimal(25, 0) NULL,

                DifferentialBaseGUID uniqueidentifier NULL,

                BackupTypeDescription  NVARCHAR(60) NULL,

                BackupSetGUID uniqueidentifier NULL--,

        --CompressedBackupSize binary(8) NULL

    );

DECLARE @FileList TABLE

    (

                LogicalName NVARCHAR(128) NOT NULL,

                PhysicalName NVARCHAR(260) NOT NULL,

                Type CHAR(1) NOT NULL,

                FileGroupName NVARCHAR(120) NULL,

                Size numeric(20, 0) NOT NULL,

                MaxSize numeric(20, 0) NOT NULL,

                FileID bigint NULL,

                CreateLSN numeric(25,0) NULL,

                DropLSN numeric(25,0) NULL,

                UniqueID uniqueidentifier NULL,

                ReadOnlyLSN numeric(25,0) NULL ,

                ReadWriteLSN numeric(25,0) NULL,

                BackupSizeInBytes bigint NULL,

                SourceBlockSize INT NUULL,

                FileGroupID INT NULL,

                LogGroupGUID uniqueidentifier NULL,

                DifferentialBaseLSN numeric(25,0)NULL,

                DifferentialBaseGUID uniqueidentifier NULL,

                IsReadOnly bit NULL,

                IsPresent bit NULL--,

        --      TDEThumbprint varbinary(32) NULL

    );

    SET @Error = 0;

    --add trailing backslash to folder names if not already specified

IF LEFT(REVERSE(@DataFolder), 1) <> '\' SET @DataFolder = @DataFolder + '\';

    IF LEFT(REVERSE(@LogFolder), 1) <> '\' SET @LogFolder = @LogFolder + '\';

    IF LEFT(REVERSE(@CatalogFolder), 1) <> '\' SET @CatalogFolder = @CatalogFolder + '\';

        -- get backup header info and display

    SET @RestoreStatement = N'RESTORE HEADERONLY



      FROM DISK=N''' + @BackupFile + ''' WITH FILE=' + CAST(@FileNumber AS NVARCHAR(10));

                PRINT @RestoreStatement

    INSERT INTO @BackupHeader

    EXEC('RESTORE HEADERONLY FROM DISK=N''' + @BackupFile + ''' WITH FILE = 1');

    SET @Error = @@ERROR;

IF @Error <> 0 GOTO Done;

    IF NOT EXISTS(

    SELECT *

        FROM @BackupHeader) GOTO Done;

    SELECT

    @OldDatabaseName = DatabaseName,

    @ServerName = ServerName,

    @BackupFinishDate = BackupFinishDate

    FROM @BackupHeader;

IF @NewDatabaseName IS NULL SET @NewDatabaseName = @OldDatabaseName;

    SET @Message = N'--Backup source: ServerName=%s, DatabaseName=%s, BackupFinishDate=' +

                CONVERT(NVARCHAR(23), @BackupFinishDate, 121);

    RAISERROR(@Message, 0, 1, @ServerName, @OldDatabaseName) WITH NOWAIT;

    -- get filelist info

    SET @RestoreStatement = N'RESTORE FILELISTONLY



      FROM DISK=N''' + @BackupFile + ''' WITH FILE=' + CAST(@FileNumber AS NVARCHAR(10));

INSERT INTO @FileList

    EXEC(@RestoreStatement);

    SET @Error = @@ERROR;

IF @Error <> 0 GOTO Done;

    IF NOT EXISTS(

    SELECT *

        FROM @FileList) GOTO Done;

        -- generate RESTORE DATABASE statement and ALTER DATABASE statements

    SET @ChangeLogicalNamesSql = '';

    SET @RestoreStatement =

        N'RESTORE DATABASE ' +

                QUOTENAME(@NewDatabaseName) +

        N'



      FROM DISK=N''' +

        @BackupFile + '''' +

        N'



      WITH



            FILE=' +

                CAST(@FileNumber AS NVARCHAR(10))

    DECLARE FileList CURSOR LOCAL STATIC READ_ONLY FOR

SELECT

            Type AS FileTyoe,

            LogicalName,

    --extract folder name from full path

            LEFT(PhysicalName,

                LEN(LTRIM(RTRIM(PhysicalName))) -

                CHARINDEX('\',

                    REVERSE(LTRIM(RTRIM(PhysicalName)))) + 1)

            AS PhysicalFolderName,

    --extract file name from full path

            LTRIM(RTRIM(RIGHT(PhysicalName,

                        CHARINDEX('\',

                            REVERSE(PhysicalName)) - 1))) AS PhysicalFileName

    FROM @FileList;

OPEN FileList;

WHILE 1 = 1

    BEGIN

                FETCH NEXT

        FROM FileList INTO

        @FileType, @LogicalName, @PhysicalFolderName, @PhysicalFileName;

    IF @@FETCH_STATUS = -1 BREAK;

            -- build new physical name

        SET @NewPhysicalName =

        CASE @FileType

                    WHEN 'D' THEN

                    COALESCE(@DataFolder, @PhysicalFolderName) +

            CASE

                        WHEN UPPER(@ChangePhysicalFileNames) IN ('Y', '1')

                    AND

                        LEFT(@PhysicalFileName, LEN(@OldDatabaseName)) = @OldDatabaseName

                        THEN

                @NewDatabaseName + RIGHT(@PhysicalFileName, LEN(@PhysicalFileName) - LEN(@OldDatabaseName))

            ELSE

                @PhysicalFileName

            END

                    WHEN 'L' THEN

                    COALESCE(@LogFolder, @PhysicalFolderName) +

            CASE

                        WHEN UPPER(@ChangePhysicalFileNames) IN ('Y', '1')

                    AND

                        LEFT(@PhysicalFileName, LEN(@OldDatabaseName)) = @OldDatabaseName

                        THEN

                @NewDatabaseName + RIGHT(@PhysicalFileName, LEN(@PhysicalFileName) - LEN(@OldDatabaseName))

            ELSE

                @PhysicalFileName

            END

                    WHEN 'F' THEN

                    COALESCE(@CatalogFolder, @PhysicalFolderName) +

            CASE

                        WHEN UPPER(@ChangePhysicalFileNames) IN ('Y', '1')

                    AND

                        LEFT(@PhysicalFileName, LEN(@OldDatabaseName)) = @OldDatabaseName

                        THEN

                @NewDatabaseName + RIGHT(@PhysicalFileName, LEN(@PhysicalFileName) - LEN(@OldDatabaseName))

            ELSE

                @PhysicalFileName

            END

        END;

            -- build new logical name

        SET @NewLogicalName =

        CASE

                    WHEN @ChangeLogicalNames IN ('y', 'Y', 't', 'T', '1')

                AND

                    LEFT(@LogicalName, LEN(@OldDatabaseName)) = @OldDatabaseName

                    THEN

            @NewDatabaseName + RIGHT(@LogicalName, LEN(@LogicalName) - LEN(@OldDatabaseName))

        ELSE

            @LogicalName

        END;

            -- generate ALTER DATABASE...MODIFY FILE statement if logical file name is different

        IF @NewLogicalName <> @LogicalName

        SET @ChangeLogicalNamesSql = @ChangeLogicalNamesSql + N'ALTER DATABASE ' + QUOTENAME(@NewDatabaseName) + N'



                  MODIFY FILE (NAME=''' + @LogicalName + N''', NEWNAME=''' + @NewLogicalName + N''');



'

            -- add MOVE option as needed if folder and/or file names are changed

        IF @PhysicalFolderName + @PhysicalFileName <> @NewPhysicalName

        BEGIN

            SET @RestoreStatement = @RestoreStatement +

            N',



                  MOVE ''' +

            @LogicalName +

            N''' TO ''' +

            @NewPhysicalName +

            N'''';



      END;







END;



CLOSE FileList;



DEALLOCATE FileList;







IF @AdditionalOptions IS NOT NULL



      SET @RestoreStatement =



            @RestoreStatement + N', ' + @AdditionalOptions



          



IF @DatabaseOwner IS NOT NULL



      SET @AlterAuthorizationSql = N'

        ALTER AUTHORIZATION ON DATABASE::' +



            QUOTENAME(@NewDatabaseName) + N' TO ' + QUOTENAME(@DatabaseOwner)



ELSE



      SET @AlterAuthorizationSql = N''



--execute RESTORE statement



IF UPPER(@ExecuteRestoreImmediately) IN ('Y', '1')



BEGIN







      RAISERROR(N'Executing:

                    %s', 0, 1, @RestoreStatement) WITH NOWAIT



      EXEC (@RestoreStatement);



      SET @Error = @@ERROR;



      IF @Error <> 0 GOTO Done;







      --execute ALTER DATABASE statement(s)



      IF @ChangeLogicalNamesSql <> ''



      BEGIN



            RAISERROR(N'Executing:

                    %s', 0, 1, @ChangeLogicalNamesSql) WITH NOWAIT



            EXEC (@ChangeLogicalNamesSql);



            SET @Error = @@ERROR;



            IF @Error <> 0 GOTO Done;



      END



    



      IF @AlterAuthorizationSql <> ''



      BEGIN



            RAISERROR(N'Executing:

                    %s', 0, 1, @AlterAuthorizationSql) WITH NOWAIT



            EXEC (@AlterAuthorizationSql);



            SET @Error = @@ERROR;



            IF @Error <> 0 GOTO Done;



      END



    



END



ELSE



BEGIN



      RAISERROR(N'%s', 0, 1, @RestoreStatement) WITH NOWAIT



      IF @ChangeLogicalNamesSql <> ''



      BEGIN



            RAISERROR(N'%s', 0, 1, @ChangeLogicalNamesSql) WITH NOWAIT;



      END



      IF @AlterAuthorizationSql <> ''



      BEGIN



            RAISERROR(N'%s', 0, 1, @AlterAuthorizationSql) WITH NOWAIT;



      END



END;





print @RestoreStatement

Done:





RETURN @Error;



GO'

/*

This procedure will generate and optionally execute a RESTORE DATABASE

script from the specified disk database backup file.

Parameters:

@BackupFile: Required. Specifies fully-qualified path to the disk
backup file. For remote (network) files, UNC path should
be specified. The SQL Server service account will need
permissions to the file.

@NewDatabaseName: Optional. Specifies the target database name
for the restore. If not specified, the database is
restored using the original database name.

@FileNumber: Optional. Specifies the file number of the desired
backup set. This is needed only when when the backup file
contains multiple backup sets. If not specified, a
default of 1 is used.

@DataFolder: Optional. Specifies the folder for all database data
files. If not specified, data files are restored using the
original file names and locations.

@LogFolder: Optional. Specifies the folder for all database log
files. If not specified, log files are restored to the
original log file locations.

@CatalogFolder: Optional. Specifies the folder for all catalog
files. If not specified, catalog files are restored to the
original log file locations.

@ExecuteRestoreImmediately: Optional. Specifies whether or not to
execute the restore. When, 'Y' is specified, then restore is
executed immediately. When 'Y' is specified, the restore script
is printed but not executed. If not specified, a default of 'N'
is used.

@ChangePhysicalFileNames: Optional. Indicates that physical file
names are to be renamed during the restore to match the
new database name. When 'Y' is specified, the leftmost
part of the original file name matching the original
database name is replaced with the new database name. The
file name is not changed when 'N' is specified or if the
leftmost part of the file name doesn't match the original
database name. If not specified, a default of 'Y' is used.

@ChangeLogicalNames: Optional. Indicates that logical file names
are to be renamed following the restore to match the new
database name. When 'Y' is specified, the leftmost part
of the original file name matching the original database
name is replaced with the new database name. The file name
is not changed when 'N' is specified or if the leftmost
part of the file name doesn't match the original database
name. If not specified, a default of 'Y' is used.

@DatabaseOwner: Optional. Specifies the new database owner
(authorization) of the restored database. If not specified, the
database will be owned by the accunt used to restore the database.

@AdditionalOptions: Optional. Specifies options to be added the the
RESTORE statement WITH clause (e.g. STATS=5, REPLACE). If not
specified, only the FILE and MOVE are included.

Sample usages:

restore database with same name and file locations

EXEC #RestoreDatabase_SQL2008

@BackupFile = N'C:\Backups\Foo.bak',

@AdditionalOptions=N'STATS=5, REPLACE';

Results:

--Backup source: ServerName=MYSERVER, DatabaseName=Foo, BackupFinishDate=2009-06-13 11:20:52.000

RESTORE DATABASE [MyDatabase]

FROM DISK=N'C:\Backups\Foo.bak'

WITH

FILE=1, STATS=5, REPLACE

--restore database with new name and change logical and physical names

EXEC #RestoreDatabase_SQL2008

@BackupFile = N'C:\Backups\Foo.bak',

@NewDatabaseName = 'Foo2';

Results:

--Backup source: ServerName=MYSERVER, DatabaseName=Foo, BackupFinishDate=2009-06-13 11:20:52.000

RESTORE DATABASE [Foo2]

FROM DISK=N'C:\Backups\Foo.bak'

WITH

FILE=1,

MOVE 'Foo' TO 'C:\DataFolder\Foo2.mdf',

MOVE 'Foo_log' TO 'D:\LogFolder\Foo2_log.LDF'

ALTER DATABASE [Foo2]

MODIFY FILE (NAME='Foo', NEWNAME='Foo2');

ALTER DATABASE [Foo2]

MODIFY FILE (NAME='Foo_log', NEWNAME='Foo2_log');

--restore database to different file folders and change owner after restore:

EXEC #RestoreDatabase_SQL2008

@BackupFile = N'C:\Backups\Foo.bak',

@DataFolder = N'E:\DataFiles',

@LogFolder = N'F:\LogFiles',

@DatabaseOwner = 'sa',

@AdditionalOptions=N'STATS=5;

Results:

--Backup source: ServerName=MYSERVER, DatabaseName=Foo, BackupFinishDate=2009-06-13 11:20:52.000

RESTORE DATABASE [Foo]

FROM DISK=N'C:\Backups\Foo.bak'

WITH

FILE=1,

MOVE 'Foo' TO 'E:\DataFiles\Foo.mdf',

MOVE 'Foo_log' TO 'F:\LogFiles\Foo_log.LDF'

ALTER AUTHORIZATION ON DATABASE::[Foo] TO [sa]
*/

Typed DataSet and CommandTimeOut

2008-01-17T05:35:00.000-08:00

To set the command timeout on a typed dataset:

Modify the InitCommandCollection() method in the Dataset.designer.cs class

add:



            this._commandCollection[0].CommandTimeout = 90;

            this._commandCollection[1].CommandTimeout = 90;

Why did America back down on Iran?

2007-12-04T05:33:00.000-08:00

the National Intelligence Council released a mild report on Iran's intentions to get the bomb.
Stating that Iran gave up its nuclear program back in 2003
Why this sudden U-turn? Why would the Bush administration let out a report that contradicts all there hard work they've been doing to push sanctions on Iran?

Recently at the Annapolis conference which was held to boost peace talks between Israel and the Palestinians, Prime Minister Olmert met with Bush on several occasions to discuss Iran. A week later America releases a National Intelligence Estimate (coordinated judgments of the US Intelligence Community made up of 16 intelligence agencies) on Iran. Then Israeli Defence Minister Ehud Barak publicly challenged the US intelligence consensus that Iran had stopped its nuclear weapons programme. Why would you give your enemy leverage?

Are the Americans trying to relieve themselves of the duty to face this problem head on, are they leaving the burden on Israel? Is this all a intricate ploy to give the Iranians some breathing space so that they can be caught off guard or maybe even open a channel of communication on a lower level of trust?

The fact remains, Iran is a threat! Whatever is going on here, I sure hope something is done soon before mad men like Ahmadinejad get even madder