Skip to main content

Posts

Showing posts from December, 2015

Featured post

XM Cloud content sync from prod to uat or UAT to prod step by step

When working with Sitecore, it’s common to need content synchronization across environments. Today, I’ll walk you through the steps to sync content from Production to UAT/TEST and vice versa. Steps to Follow 1. Set Up Your Workspace Create a folder on your computer where you will manage the script files and exported data. Open the folder path in PowerShell to begin scripting. We need to run some scripts in PowerShell to update the folder with the basic requirements for syncing content. PS C:\Soft\ContentSync> dotnet new tool-manifest PS C:\Soft\ContentSync> dotnet nuget add source -n Sitecore https://nuget.sitecore.com/resources/v3/index.json PS C:\Soft\ContentSync> dotnet tool install Sitecore.CLI PS C:\Soft\ContentSync> dotnet sitecore cloud login If the above error occurs, you will need to run a different command to resolve the issue. PS C:\Soft\ContentSync> dotnet sitecore init now, Again run above command to open and authenticate with XM Cloud. It will be there a...
Post a Comment
Read more

How to do partition of table in sql server

CREATE PARTITION FUNCTION myDateRangePF (datetime) AS RANGE RIGHT FOR VALUES ('20110101', '20120101','20130101') GO CREATE PARTITION SCHEME myPartitionScheme AS PARTITION myDateRangePF ALL TO ([PRIMARY]) ALTER TABLE dbo.TABLE1 DROP CONSTRAINT PK_TABLE1 GO ALTER TABLE dbo.TABLE1 ADD CONSTRAINT PK_TABLE1 PRIMARY KEY NONCLUSTERED   (pkcol)    WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,          ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO CREATE CLUSTERED INDEX IX_TABLE1_partitioncol ON dbo.TABLE1 (partitioncol)   WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,         ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)   ON myPartitionScheme(partitioncol)
Post a Comment
Read more

How to get last identity value after inserted in table of sql server ? or How to use scope identity in sql server ?

SCOPE_IDENTITY in sql server It returns the last identity value which is just   inserted into an identity column. It returns value only if it in same scope. using (var conn = new SqlConnection(ConnectionString)) {     int ID;     var cmd = "INSERT INTO foo (column_name)VALUES (@data);SELECT CAST(scope_identity() AS int)";     using (var insertCom = new SqlCommand(cmd, conn)) {         insertCom.Parameters.AddWithValue("@data", "Shashi Keshar");         conn.Open();         ID = (int)insertCom.ExecuteScalar();     } }
Post a Comment
Read more

Multilevel Inheritance in C#

Example of Multilevel Inheritance in C# using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Test {     class Program     {         static void Main( string [] args)         {             b bb = new c ();            Console .ReadKey();         }     }     class a     {         public   a()         {             Console .WriteLine( "I am a" );         }     }     class b : a     {  ...
Post a Comment
Read more

How to use ajax in AngularJS

Here you may learn to get details through web api url and use them to bind in table. AngularJS offers $http control which working as a service to read data from the server. Below written example help you to get information .Use below syntax to call any file name or global url which return JSON data. Example : This code is of ajax syntax in angularjs . see the below code to pass url or file name. <script>          function employeeController($scope,$http) {              var url = “www.getapi.com/api”; // file name which return JSON data.                      $http.get(url).success( function(response) {                $scope. employees = response;       ...
Post a Comment
Read more