Melick's Blog

Sp.js contains a GUID JavaScript class which will give you  a GUID SP.Guid.newGuid()

AutoSPInstaller Online is one of a great project that facilitate Automated SharePoint installation including Sharepoint 2010, 2013 and 2016. Auto SP Installer provides a powerful way to deploy and configure a single-server development environment to multiple-server SharePoint farm. Reference: https://autospinstaller.com/ Before doing anything we will set up the environment for SharePoint three server Farm. Will name these servers as SPWFE - Share Point Front End Server SPAPP - Share Point App server SPDB - DB server Please find the reference for SharePoint minimum requirement and practices from https://docs.microsoft.com/en-us/SharePoint/install/install-sharepoint-server-2016-across-multiple-servers For the the medium segregation, we have to create below list of service accounts. Service Accounts for Active Directory Service Account name : spadmin Rights : Local Admin All Servers (DB,WFE,APP) SQL DB Rights: SQL DB Creator and Security Admin Rights Domain Privileges: Service ...

The XSS Auditor refused to execute a script in http://default.aspx because its source code was found within the request. The auditor was enabled as the server sent neither an 'X-XSS-Protection' nor 'Content-Security-Policy' header in SharePoint 2013 Recent google chrome update may breaks the sharepoint layout pages and other custom development pages due to XSS Auditor. I have added the HTTP Response Header  to the SharePoint Web Front End Servers  and then it worked fine.    

SqlConnection SC = new SqlConnection( "Place your connection string here" ); string sqltxt = "" ; string ipath = "C:\Backup.Bak" ; sqltxt = @"BACKUP DATABASE SampleDB TO DISK = ' " + ipath + "' WITH INIT " ;     SqlCommand sqlCm = new SqlCommand(sqltxt, SC); SC.Open(); sqlCm.ExecuteNonQuery(); SC.Close();

Open a new Visual Studio windows application project (c#) Right click the project and goto AddNew item . and it will popup the following dialog. select the Linq to SQL Classes and give a neme add click add. then double click the added class in your solution explorer. Then it will load following type of screen. In the Data connection (Assumme you already created a SQL Server Database and also a table nemed "Table1"), Drag and drop the table to the window. Then it will ask for connection string saving dialog. For the moment keep it NO. Now we will see how to use LINQ to do Insert , Update , Delete. Coding is describing below. ( sample is the name given by me to the LinqtoSQL class). private void cmdAdd_Click( object sender, EventArgs e) { sampleDataContext Dt = new sampleDataContext(); Table1 T = new Table1(); T.Address = "Address 1" ; T.Name = "a" ;   Dt.Table1s.InsertOnSubmit(T); Dt.SubmitChanges(); ...

There are many scenarios that you need to list down all your existing Reporting subscription in the SharePoint. Sometimes , you might find your reporting server subscription is not showing the in the manage subscription menu. There is a reason for it. Currently subscriptions  are saved based on URL (Alternative access URL) and User. So if your farm has different AAMs, even though you are a same user , it will not show under your subscriptions. So how you can get it. There is a no direct function to get this unless you are using SSRS API to query the data. but you can find these entries by simply querying SSRS SharePoint database.   SELECT   *    FROM [ReportingService_ServiceApplication_DB].[dbo].[Subscriptions] with(nolock) You can find below details [SubscriptionID] ,[OwnerID] ,[Report_OID] ,[Locale] ,[InactiveFlags] ,[ExtensionSettings] ,[ModifiedByID] ,[ModifiedDate] ,[Description] ,[LastStatus] ,[EventType] ,[MatchData] ,[LastRunTime] ,[P...

How to copy you production SharePoint  database to development environment. I had my production environment as SharePoint 2013 SQL Server 2012 and I want to move the instance to another environment , which is freshly installed and different environment and different KBs Share Point 2013 SQL Server 2016 How to migrate SharePoint 2013 , SQL Server 2012 Content Database to SharePoint 2013 SQL Server 2016. Method 1. This is a general method, which is used for upgrading your content database. 1 . Get the back up of the current Content Database 2. Copy SQL backup to new environment 3. Restore the SQL Back Up in to the new environment 4. Go to the Security Login section and grant permission to content database for existing SharePoint Users.   5. You need to select the User mapping and DBO for the content database. 6 Then, execute below PS in SharePoint PowerShell. Make sure you executed as Run as Administrator 7 Firstly, You need to Update the content database. 8. then, mount the usi...