How to check Sitecore Item Update without Publishing?

As Developer, We always looking to accelerate our development effort.

Here is a scenario where wanted to do some updates on sitecore item and wanted to see the presentation without publishing each time.
After doing some to and fro, found useful existing sitecore config change.

Sitecore have already LiveMode.Config (~/App_Config/Include/).
By default this config is disabled.

To enable LiveMode.Config remove example extension from config.

After enabling LiveMode.Config we can see the changes of sitecore item without publishing.

And now it's time for demo and unit testing:

1. Goto any page item on web database update any field with value (Say A)
2. Now on same page item on master database update that field with value (Say B)
3. Now check this page on live mode
and will see changes as A

4. and if LiveMode.Config is enabled then will see changes as B

So this is cool features, if we need to verify the presentation changes before publishing to Web Database.


Enjoy your Day!!!

How to Schedule SQL Database backup Task with Powershell?

We're done with  SQL DB Backup using Powershell
Now my goal is to make it automated and Scheduled, and we can achieve this with 'ScheduledTask' command of PowerShell.

To create schedule task we basically require four main things:

Define an ScheduledTaskAction
Will create         ScheduledTaskTrigger
Create NewScheduledTask
Registered Register-ScheduledTask

So let's start practically,

First will write script to generate db_backup with powershell script (click here)

Once done with this now we're going to create scheduledTask by following steps:

1. will initialize variables

   $TaskName = "ScheduledDBBackupTask"
   $TaskCommand = "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe"
   $TaskScript = "D:\DB_Backup.ps1"
 
2. here we're defining an action

   $Action = New-ScheduledTaskAction -Execute $TaskCommand -Argument "-NONInteractive -NoLogo -NoProfile -File $TaskScript"

3. here setting up the trigger, (our task will run everyday at 05:35PM)

   $Trigger = New-ScheduledTaskTrigger -Daily -At '05:35PM'
 
4. here creating new scheduledtask

   $Task = New-ScheduledTask -Action $Action -Trigger $Trigger -Settings (New-ScheduledTaskSettingsSet)
 
5. task has been created, now it's time to register this newly created task:
         
   $Task | Register-ScheduledTask -TaskName $TaskName
 
    For source code of this script click here

once tasted on your local and if you not required in future then remove scheduledtask by

Unregister-ScheduledTask ScheduedDBBackupTask

To verfiy that your custom scheduled task has been removed:

Get-ScheduledTask

Happy Scripting