Skip to content

Instantly share code, notes, and snippets.

@phaniav
phaniav / Sitecore Database Backup script.sql
Created November 21, 2017 11:13
Script to take Sitecore database backups
BACKUP DATABASE [sc821Sitecore_core]
TO DISK = N'E:\SitecoreInstances\sc821\821db\sc821Sitecore_core'
WITH NOFORMAT, NOINIT,
NAME = N'sc821Sitecore_core-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [sc821Sitecore_master]
TO DISK = N'E:\SitecoreInstances\sc821\821db\sc821Sitecore_master'
WITH NOFORMAT, NOINIT,
NAME = N'sc821Sitecore_master-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
@phaniav
phaniav / MasterVariablesReplacer.config
Created September 17, 2017 18:46
Custom Sitecore Tokens and replacement
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">
<sitecore>
<settings>
<setting name="MasterVariablesReplacer">
<patch:attribute name="value">Sitecore.Sharedsource.Data.MasterVariablesReplacer,Sitecore.Sharedsource</patch:attribute>
</setting>
</settings>
</sitecore>
</configuration>
@phaniav
phaniav / Dictionary2QueryStringExtension.cs
Created September 12, 2017 22:24
Dictionary to Querystring convertor
using System.Collections.Generic;
using System.Linq;
using System.Text;
public static class CollectionExtensions
{
public static string ToQueryString(this IDictionary<string, string> dict)
{
if (dict.Count == 0) return string.Empty;
@phaniav
phaniav / LuisHelpIntent.cs
Created August 28, 2017 09:54
Sample LuisIntent["Help"] for slack with channel data hydration
[LuisIntent("Help")]
public async Task Help(IDialogContext context, IAwaitable<IMessageActivity> activity, LuisResult result)
{
var message = await activity;
var reply = context.MakeMessage();
reply.TextFormat = "markdown";
reply.Text = @"You can try some of the below options
* find me sweaters
* do you have wallets
* show me yellow v - neck sweaters";
@phaniav
phaniav / HabitatSolutionScript.ps1
Last active March 2, 2017 03:36 — forked from akshaysura/HabitatSolutionScript.ps1
Updated the Visual Studio installation location using powershell environment variable
#paths to the project templates on your system
$global:classTemplate = "$env:VS140COMNTOOLS..\IDE\ProjectTemplatesCache\CSharp\Windows Root\Windows\1033\ClassLibrary\csClassLibrary.vstemplate"
$global:webTemplate = "$env:VS140COMNTOOLS..\IDE\ProjectTemplatesCache\CSharp\Web\1033\WebApplicationProject40\EmptyWebApplicationProject40.vstemplate"
#variable used to store the path for the empty Habitat folder
$global:helixPath =""
#empty variable used to store the solution name
$global:solutionName = ""