SharePoint Home - Tips & Tricks (2010/2013/O365)

Roadmap: SharePoint 2013 DR to Azure - Full steps

2015-04-28T01:36:00.002-07:00

Dears,Here is a summary for how to implement log shipping for SharePoint 2013 in a disaster-recovery scenario.Full Reference: https://technet.microsoft.com/en-us/library/dn743677.aspx

Log shipping consists of three jobs. Each job performs one of the following operations:

Backs up the transaction log at the primary server instance.
Copies the transaction log file to the secondary server instance.
Restores the log backup on the secondary server instance.

Note: If you switch the database to simple recovery, log shipping will stop working.

The required steps to configure, run, and validate log shipping are condensed and summarized in the following list:

Back up the database.
1. Configure the full and differential backups to a local folder and also a shared folder on the file server.
2. Verify backups were made to both the local folder and shared folder.
Set up and test Distributed File System (DFS) Replication.
1. Create Namespace and Replication to transfer the transaction logs and backup files between the on-premises and Azure farms on the shared folder in file server.
2. Verify all transfers after log shipping runs.

Set up and test log shipping.

Set up log shipping on the primary database server by using the following script: Primary-Logshippingsetupparameter. This script creates backup jobs, schedules them for log shipping and then initiates the jobs.

SET NOCOUNT ON
USE MSDB
GO

--@PrimServer : Primary Server name
--@SecServer  : DR/Secondary Server Name
--@SecInstance : DR/Secondary FQDN
--@Domain  : Domain Name
--@BkpDrive : Production Backup server Name
--@DBName : DatabaseName

DECLARE @LS_BackupJobIdAS uniqueidentifier,  @LS_PrimaryIdAS uniqueidentifier , @SP_Add_RetCode As int 
DECLARE @Time as nvarchar(10),@SecInstance as nvarchar(250), @PrimServer as nvarchar(50),@SecServer as nvarchar(50),
@Domain as nvarchar(50),@DBName as nvarchar(max),@BkpDrive as nvarchar(250),@CMD as nvarchar(max),@Counter int
----------------------------------------------------------------------------
IF OBJECT_ID ('tempdb.DBO.#LogShipping','U') IS NOT NULL DROP TABLE #LogShipping
Create table #LogShipping ( LSDBs nvarchar(max))

Set @PrimServer ='SQL1'
Set @SecServer ='SQL2'
Set @SecInstance ='SQL2.corp.adventureworks.com'
Set @Domain ='corp.adventureworks.com'
Set @BkpDrive ='FS1.corp.adventureworks.com'
Set @DBName = 'Social_DB'
Set @Time = '0130'

SET @DBName = UPPER(REPLACE(@DBName, ' ', ''))
SET @DBName = '''' + REPLACE(@DBName, ',', ''', ''') + ''''

Set @CMD =   ' Select ' +
'''DECLARE  @SP_Add_RetCode As int, @LS_BackupJobIdAS uniqueidentifier,  @LS_PrimaryIdAS uniqueidentifier
EXEC @SP_Add_RetCode = master.dbo.sp_add_log_shipping_primary_database ' + CHAR(10) +
'@database = ''''''  + db.Name + ''''''' + CHAR(10) +
',@backup_directory = ''''\\' + @BkpDrive + '\LS\' + ''' + db.Name + ''''' + '''' + CHAR(10) +
',@backup_share = ' + '''''\\' + @BkpDrive + '\LS\' + ''' + db.Name + ''''' + ''''  + CHAR(10) +
',@backup_job_name = ''''' + 'LSBackup_' + ''' + db.Name + ''''' + '''' + CHAR(10) +
',@backup_retention_period = 4320
,@backup_compression = 1
,@backup_threshold = 180 
,@threshold_alert_enabled = 1
,@history_retention_period = 5760 
,@backup_job_id = @LS_BackupJobId OUTPUT 
,@primary_id = @LS_PrimaryId OUTPUT 
,@overwrite = 1 ' +

'IF (@@ERROR = 0 AND @SP_Add_RetCode = 0) 
BEGIN 
DECLARE @LS_BackUpScheduleUIDAs uniqueidentifier ,@LS_BackUpScheduleIDAS int 
EXEC msdb.dbo.sp_add_schedule 
@schedule_name = ''''' + 'LSBackupSchedule_'+ @PrimServer + '_' + ''' + db.Name + ''''' + ''''  + CHAR(10) +
',@enabled = 1 
,@freq_type = 4 
,@freq_interval = 1 
,@freq_subday_type = 4 
,@freq_subday_interval = 13 
,@freq_recurrence_factor = 0 
,@active_start_date = 20090506 
,@active_end_date = 99991231 
,@active_start_time = ' + @Time  + CHAR(10) +
',@active_end_time = 235900 
,@schedule_uid = @LS_BackUpScheduleUID OUTPUT 
,@schedule_id = @LS_BackUpScheduleID OUTPUT 

EXEC msdb.dbo.sp_attach_schedule @job_id = @LS_BackupJobId ,@schedule_id = @LS_BackUpScheduleID  
EXEC msdb.dbo.sp_update_job @job_id = @LS_BackupJobId ,@enabled = 1 
END 

EXEC master.dbo.sp_add_log_shipping_alert_job 
EXEC master.dbo.sp_add_log_shipping_primary_secondary 
@primary_database = '''  + ''''' + db.Name + ''''' + ''''  + CHAR(10) + 
',@secondary_server = ''''' + @SecInstance + ''''''  + CHAR(10) +
',@secondary_database = ''' + ''''' + db.Name + ''''' + ''''  + CHAR(10) +
',@overwrite = 1 ''' +
' [LSDBs] FROM sys.databases db  where name in (' + @DBName + ')' +

'and    db.name  not in (''master'',''model'',''msdb'',''tempdb'',''metricsops'',''periscope'' )
and   Not (exists (select lss.Secondary_database from msdb.dbo.log_shipping_Secondary_databases lss where  db.Name = lss.Secondary_database)
or exists (select lsp.primary_database from msdb.dbo.log_shipping_primary_databases lsp where  db.Name = lsp.primary_database)
   )'

Insert #LogShipping (LSDBs)
Exec ( @CMD)

Set @Counter = @@rowcount

While (@counter > 0)
  Begin
  select top 1  @CMD = LSDBs from #LogShipping
  exec sp_executesql @CMD
  set @counter = @counter - 1
  delete top (1) from #LogShipping

  End

IF OBJECT_ID ('tempdb.DBO.#LogShipping','U') IS NOT NULL DROP TABLE #LogShipping
-- ****** End: Script to be run at Primary: [DB1-PSMSQL-01]  ******

Set up log shipping on a secondary database server by using the following script: Secondary-Logshippingsetupparameter scripts. In our lab environment, the secondary database server is in recovery farm located in Azure.

-- ****** Begin: Script to be run at Secondary:  9.3 BUILD******
SET NOCOUNT ON
USE MSDB
GO
--@PrimServer : Primary Server name
--@SecServer  : DR/Secondary Server Name
--@SecInstance : DR/Secondary FQDN
--@Domain  : Domain Name
--@PrimaryBkpDrive : Production Backup server Name
--@BkpDrive : Secondary Backup server Name
--@DBName : DatabaseName

DECLARE @LS_BackupJobIdAS uniqueidentifier,  @LS_PrimaryIdAS uniqueidentifier , @SP_Add_RetCode As int 
DECLARE @Time as nvarchar(10),@SecInstance as nvarchar(250), @PrimServer as nvarchar(50),@SecServer as nvarchar(50),
@Domain as nvarchar(50),@DBName as nvarchar(max),@PrimaryBkpDrive as nvarchar(250),@BkpDrive as nvarchar(250),@CMD as nvarchar(max),@CMD2 as nvarchar(max),@Counter int
DECLARE  @Delimeter char(1),@DB nvarchar(200), @StartPos int, @Length int

IF OBJECT_ID ('tempdb.DBO.#LogShipping','U') IS NOT NULL DROP TABLE #LogShipping
Create table #LogShipping ( LSDBs nvarchar(max))

IF OBJECT_ID ('tempdb.DBO.#DBs','U') IS NOT NULL DROP TABLE #DBs
Create TABLE #DBs (Name nvarchar(200))

Set @PrimServer ='az-sql-ha1'
Set @SecServer =' az-sql-ha2'
Set @SecInstance ='SQL1.corp.adventureworks.com'
Set @Domain =' corp.adventureworks.com '
SET @PrimaryBkpDrive = 'fs1.corp.adventureworks.com'
Set @BkpDrive =' az-sp-fs.corp.adventureworks.com '
Set @DBName = 'Social_DB'
Set @Time = '0130'

--Parsing Function

SET @Delimeter = ','

WHILE LEN(@DBName) > 0
  BEGIN
    SET @StartPos = CHARINDEX(@Delimeter, @DBName)
    IF @StartPos < 0 SET @StartPos = 0
    SET @Length = LEN(@DBName) - @StartPos - 1
    IF @Length < 0 SET @Length = 0
    IF @StartPos > 0
      BEGIN
        SET @DB = Rtrim(Ltrim(SUBSTRING(@DBName, 1, @StartPos - 1)))
        SET @DBName = SUBSTRING(@DBName, @StartPos + 1, LEN(@DBName) - @StartPos)
      END
    ELSE
      BEGIN
        SET @DB = Rtrim(Ltrim(@DBName))
        SET @DBName = ''
      END
    INSERT #DBs (Name) VALUES(@DB)
END

--SET @DBName = UPPER(REPLACE(@DBName, ' ', ''))
--SET @DBName = '''' + REPLACE(@DBName, ',', ''', ''') + ''''

Set @CMD = 'Select ' +
''' DECLARE @LS_Secondary__CopyJobId AS uniqueidentifier, @LS_Secondary__RestoreJobId AS uniqueidentifier ,@LS_Secondary__SecondaryId AS uniqueidentifier , @LS_Add_RetCode As int ,@LS_Add_RetCode2 As int 
  DECLARE @LS_SecondaryCopyJobScheduleUIDAs uniqueidentifier ,@LS_SecondaryCopyJobScheduleIDAS int, @LS_SecondaryRestoreJobScheduleUIDAs uniqueidentifier ,@LS_SecondaryRestoreJobScheduleIDAS int 
  EXEC @LS_Add_RetCode = master.dbo.sp_add_log_shipping_secondary_primary 
@primary_server = ''''' + @PrimServer + ''''''+  CHAR(10) +
',@primary_database = '' + ' +  ''''''''' + db.Name + ''''''''' +  CHAR(10) +
' + '',@backup_source_directory = ' + '''''\\' + @PrimaryBkpDrive + '\LS\'' + db.Name + ''''''' +  CHAR(10) +
' ,@backup_destination_directory =  ' + '''''\\' + @BkpDrive + '\LS\'' + db.Name + ''''''' +  CHAR(10) +
',@copy_job_name = ''''LSCopy_DB1-PSMSQL-01_'' + db.Name + ''''''' +  CHAR(10) +
',@restore_job_name = ''''LSRestore_'+ @PrimServer + '_'' + db.Name + ''''''' +  CHAR(10) +
',@file_retention_period = 4320 
,@overwrite = 1 
,@copy_job_id = @LS_Secondary__CopyJobId OUTPUT 
,@restore_job_id = @LS_Secondary__RestoreJobId OUTPUT 
,@secondary_id = @LS_Secondary__SecondaryId OUTPUT 
IF (@@ERROR = 0 AND @LS_Add_RetCode = 0) 
BEGIN 
EXEC msdb.dbo.sp_add_schedule 
@schedule_name =''''DefaultCopyJobSchedule'''' 
,@enabled = 1 
,@freq_type = 4 
,@freq_interval = 1 
,@freq_subday_type = 4 
,@freq_subday_interval = 15 
,@freq_recurrence_factor = 0 
,@active_start_date = 20090506 
,@active_end_date = 99991231 
,@active_start_time = ' + @Time + ' 
,@active_end_time = 235900 
,@schedule_uid = @LS_SecondaryCopyJobScheduleUID OUTPUT 
,@schedule_id = @LS_SecondaryCopyJobScheduleID OUTPUT 

EXEC msdb.dbo.sp_attach_schedule 
@job_id = @LS_Secondary__CopyJobId 
,@schedule_id = @LS_SecondaryCopyJobScheduleID  

EXEC msdb.dbo.sp_add_schedule 
@schedule_name =''''DefaultRestoreJobSchedule'''' 
,@enabled = 1 
,@freq_type = 4 
,@freq_interval = 1 
,@freq_subday_type = 4 
,@freq_subday_interval = 15 
,@freq_recurrence_factor = 0 
,@active_start_date = 20090506 
,@active_end_date = 99991231 
,@active_start_time = ' + @Time + '
,@active_end_time = 235900 
,@schedule_uid = @LS_SecondaryRestoreJobScheduleUID OUTPUT 
,@schedule_id = @LS_SecondaryRestoreJobScheduleID OUTPUT 

EXEC msdb.dbo.sp_attach_schedule 
@job_id = @LS_Secondary__RestoreJobId 
,@schedule_id = @LS_SecondaryRestoreJobScheduleID  
END 

IF (@@ERROR = 0 AND @LS_Add_RetCode = 0) 
BEGIN 
EXEC @LS_Add_RetCode2 = master.dbo.sp_add_log_shipping_secondary_database 
@secondary_database = ' +  ''''''' + db.Name + ''''''' +  CHAR(10) + '
,@primary_server = ''''' + @PrimServer + '''''
,@primary_database = '+  ''''''' + db.Name + ''''''' +  CHAR(10) +
',@restore_delay = 0 
,@restore_mode = 1 
,@disconnect_users= 1 
,@restore_threshold = 180   
,@threshold_alert_enabled = 1 
,@history_retention_period= 5760 
,@overwrite = 1 
END 
IF (@@error = 0 AND @LS_Add_RetCode = 0) 
BEGIN 
EXEC msdb.dbo.sp_update_job @job_id = @LS_Secondary__CopyJobId ,@enabled = 0 
EXEC msdb.dbo.sp_update_job @job_id = @LS_Secondary__RestoreJobId ,@enabled = 1 
END '''  + '[LSDBs] FROM #DBs db'

--Print @CMD
Insert #LogShipping (LSDBs)
Exec ( @CMD)

Set @Counter = @@rowcount

While (@counter > 0)
  Begin
  select top 1  @CMD = LSDBs from #LogShipping
  exec sp_executesql @CMD
  set @counter = @counter - 1
  delete top (1) from #LogShipping

  End

IF OBJECT_ID ('tempdb.DBO.#LogShipping','U') IS NOT NULL DROP TABLE #LogShipping
IF OBJECT_ID ('tempdb.DBO.#DBs','U') IS NOT NULL DROP TABLE #DBs

-- ****** End: Script to be run at Secondary:  9.3 Build ******

Verify that the transaction logs are shipped to the share and that DFS is replicating these logs to the share on the Azure file server. Open the Job Activity Monitor in SQL Server to verify the transaction logs were shipped successfully. Open the shared folders on both file servers in the production and Azure farms to verify DFS is transferring the transaction logs.

SharePoint Server 2016 update - Focus Areas

2015-04-19T02:48:00.003-07:00

Hi All,
In February, Microsoft shared their vision on the evolution of SharePoint, outlining their plans for continued cloud innovation with SharePoint in Office 365, and providing a glimpse of the work underway to deliver their next on-premises server release, SharePoint Server 2016.
This post will mention the new updates:
1- SharePoint 2016 Focus Areas

Improved user experiences

Making decisions faster and keeping in contact are critical capabilities for increasing effectiveness in any organization. Users’ ability to access information while on the go is now a workplace necessity. SharePoint Server 2016 will provide improved mobile access to content, people and applications along with touch-based experiences across devices and screen sizes. It will make file storage and document collaboration more people-centric. And it will enable improved user experiences and capabilities derived from innovations in Office 365, available either as part of your on-premises deployment or through a hybrid implementation of SharePoint Server 2016 and Office 365. For example, users will be able to quickly discover contextually relevant information and data that is stored across both on-premises and cloud environments powered by Office Graph and Delve. And, we’re focused on helping you streamline communications with richer integration with Exchange and Yammer, as well as broadening access and management of new types of media thru integration with Office 365 Video as examples.

Cloud inspired-infrastructure

SharePoint 2016 is the first on-premises server release representative of our experience running SharePoint at scale in Office 365, bringing our own internal investments to your datacenter that improve performance, reliability and scale as well as enabling true hybrid scenarios that can enrich your existing on-premises investments.

In addition, with an improved, simplified user experience and integration with products such as the next release of Windows Server, the next generation of SQL Server, and Exchange Server 2016, SharePoint Server 2016 will simplify end-user training and support for IT.

Finally, we’re focused on enabling a broad ecosystem of solutions and partners through a standardized set of APIs and experiences that span on-premises and the cloud.

Learn more about how we’re reshaping SharePoint at Microsoft Ignite:

Compliance and reporting

Data Loss Prevention (DLP) is non-negotiable, and overexposure to information can have legal and compliance implications. SharePoint Server 2016 will provide a broad array of features and capabilities designed to make certain that sensitive information remains protected with investments in DLP, new scenarios to enable data encryption, and compliance tools that span on-premises servers and Office 365 while providing a balance between enabling user self-service and ensuring content usage adheres to corporate policy.

Architectural changes in SharePoint Workflow 2010/2013

2014-08-02T23:00:00.000-07:00

Dears,
here is simple diagram explains the architectural changes between Workflows in SharePoint 2010 vs. SharePoint 2013:

The SharePoint 2010 Workflow platform has been carried forward to SharePoint Server 2013. All of your workflows that were built by using SharePoint Server 2010 will continue to work in SharePoint Server 2013.

In SharePoint Server 2010 the workflow engine installed automatically with the product. This continues to be the case with the SharePoint 2010 Workflow platform in SharePoint Server 2013. If you simply install SharePoint Server 2013 and do not install and configure Workflow Manager then you will have a nearly identical experience with building workflows as you did in SharePoint Server 2010.

The SharePoint 2013 Workflow platform only becomes available to you, and your tools, after you download and install the new Workflow Manager service and configure it to communicate with your SharePoint Server 2013 farm. For a detailed guide on this process, see Start: Set up and configure SharePoint 2013 Workflow Manager.

SharePoint Online: The Full Story (Key Features, Vs. SharePoint 2013, Its Needs and Limitations)

2014-07-03T00:53:00.000-07:00

Dears,

here is a full story regarding SharePoint Online:

1- Key Features

2- Needs

3- Limitations

1- Major key differences between SharePoint 2013 and SharePoint Online

2- Its Needs

3- Limitations

References: From SharePoint Online and OneDrive, Is now the time to move to the cloud? Presentation

SharePoint 2013 & Office365 Application Development Security & Identity Management

2014-06-29T00:31:00.000-07:00

Hello,
It's very essential to all SharePoint developers when developing custom applications and related features in SharePoint 2013, Office 365, SharePoint Online and Microsoft Azure to know the available options for security, identity management and authentication considerations

Here is one of the greatest article describe this critical topic in very organized way

http://www.aiim.org/community/blogs/expert/Security-Identity-Management-Considerations-for-Application-Development-in-SharePoint-2013-Office-365

Enjoy :)

Free News App for SharePoint 2013

2014-04-09T23:07:00.000-07:00

Hi All,
I found this great App on CodePlex for Corporate News inside SharePoint Sites.

Project Description
This project is an open and free App for SharePoint 2013. This tool helps site owners to add simple corporate news client app parts in SharePoint sites. With this app, you could have a dedicated app for a SharePoint site to manage news content directly in SharePoint lists or libraries, and you will be able to insert in pages 3 different client App parts to display these news with Javascript animations, like vertical or horizontal carousels.

You can download this App on Codeplex (manual install), or direct download and install the App from the Office & SharePoint App Store : http://office.microsoft.com/en-us/store/corporate-news-app-WA103532495.aspx

Enjoy :)

New in SharePoint 2013: Search SQL syntax

2013-12-18T22:38:00.002-08:00

Description: In SharePoint Server 2010, you could construct complex search queries by using SQL syntax.

Search in SharePoint 2013 supports FAST Query Language (FQL) syntax and Keyword Query Language (KQL) syntax for custom search solutions. You cannot use SQL syntax in custom search solutions.

Custom search solutions that use SQL syntax with the Query object model and the Query web service that were created in earlier versions of SharePoint Serverdo not work when you upgrade them to SharePoint 2013. If you submit queries by using these applications, you will receive an error.

Reason for change: The core search architecture has changed in SharePoint 2013, and the SQL syntax is no longer supported.

Migration path: Change current search solutions to use either the KQL syntax or FQL syntax for queries.

Enjoy the Keyword Query Language Structure Protocol

Click here to view this version of the [MS-KQL] PDF

References:

http://msdn.microsoft.com/en-us/library/hh644280(v=office.12).aspx

Troubleshooting - The type initializer for 'Microsoft.Office.Server.Search.LocStringIdLookupTable' threw an exception

2013-12-03T02:22:00.001-08:00

Dear All,
After adding new application service i.e. Project Server/Performance Point, SharePoint runs the SharePoint 2010 Products Configuration wizard to apply the new changes on the farm.

Here is the error you can face when you open Central Administration or any web application:

System.Configuration.ConfigurationErrorsException: The type initializer for 'Microsoft.Office.Server.Search.LocStringIdLookupTable' threw an exception. (C:\inetpub\wwwroot\wss\VirtualDirectories\46114\web.config line 437)

The error maybe weird or shocked but before your doubts flow on the top to your mind. follow these steps
1- restart SharePoint 2010 Timer service
2- reset IIS

then try it again :)

SharePoint 2010 User Profile Sync - user profile sync is not currently provisioned

2013-11-26T23:34:00.000-08:00

Dears,
In SharePoint 2010, maintaining User Profile Sync is not easy job. Sometimes without any reason, when you check the Profile Synchronization Settings, you will find this error:
user profile sync is not currently provisioned

I surfed much on Internet, I found many articles that describe this error and suggest many solutions. But many of them went so far even backup the UserProfile db was an option :|

I recommend to check these 2 steps before going far :)

1- User Profile Synchronization Service is started
2- Configure Synchronization Connections is OK (username and password are provided correctly)

Enjoy :)

SharePoint Stretched farm for High Availability Architecture

2013-11-02T23:42:00.000-07:00

Hi All,
A high-availability strategy is an important requirement for any SharePoint Production Environment. An end-to-end strategy includes operational processes, platform governance, architecture, and technical solutions. One of these strategies is SharePoint Stretched Farm. It offers a supported high availability solution the follow prerequisites must be met:

There is a highly consistent intra-farm latency of <1ms 99.9="" a="" and="" as="" between="" commonly="" database="" defined="" font="" front-end="" is="" latency="" minutes.="" ntra-farm="" of="" one="" over="" period="" servers.="" servers="" ten="" the="" time="" way="" web="">
The bandwidth speed must be at least 1 gigabit per second.

To provide fault tolerance in a stretched farm, use the standard best practice guidance to configure redundant service applications and databases.

The following illustration shows a stretched farm.

Stretched farm

Full Article Here

CodePlex - SharePoint 2013 Client Browser

2013-09-25T05:33:00.001-07:00

Hi All,
Remote SharePoint development is getting more important. Especially with SharePoint Apps. To speed up development, find hidden lists/items/documents, discover the structure or specific artifact properties use the SharePoint Client Browser which supports both SharePoint 2010 and SharePoint 2013.

Download

SharePoint 2013 Client Browser: download release (view release)
SharePoint 2010 Client Browser: download release (view release)

Just Try it :)

Services in SharePoint 2013 - Poster

2013-09-15T05:52:00.001-07:00

Hello All,
The below Poster describes and illustrates the services architecture, including common ways to deploy services in your overall solution design. V.Useful & Completed Ref.

Full Details: http://zoom.it/OLLG

SharePoint 2013 Kerberos Configuration - Complete Guide

2013-07-15T04:58:00.002-07:00

Dears,
I just finished SharePoint 2013 Kerberos Installation. one of the best references that helped me much was The first Kerberos guide for SharePoint 2013 technicians

here is the Checklist:

Step	Summary
1. Name Resolution	An entry for the Web Applications URL must exist in either DNS or in the clients hosts file.
2. Service Principal Names	HTTP SPN’s must be created for the Web Application URL(s) and its Application Pool service account.
3. Delegation	The SharePoint Web Server must be ‘Trusted for delegation’ in Active Directory. (Note added 2012-12-08)
4. Authentication Provider	The Web Applications Authentication provider must be set toAuthentication type: WindowsIIS Authentication setting: Integrated Windows authentication/Negotiate(Kerberos)
5. Verification of functionality(IMPORTANT!)	Klist.exe on client must have a HTTP ticket for URL and User accountSecurity log on SharePoint Web Server must have event ID 4624 with user and kerberos. (If Kerberos fails NTLM authentication will be used! Unless, see links at the end of step 5.)
References and Credits

Note: you must be a member of the Domain Admins group or the Enterprise Admins group in Active Directory and you have to be a member of the Farm Administrators Group in SharePoint

Troubleshooting: Installing WindowsServerAppFabric (Prerequisite SharePoint 2013 Setup) Issues

2013-07-11T01:09:00.002-07:00

Dears,
During setup SharePoint 2013 Prerequisites, WindowsServerAppFabric has a unique setup procedure. It's not just exe file you will install it. As the following TechNet reference:
http://blogs.technet.com/b/meamcs/archive/2012/12/26/install-and-download-sharepoint-2013-prerequisites-offline-manually.aspx

you should let the prerequisite installer to install AppFabric and configure it manually for you by running the following command from command prompt:
prerequisiteInstaller.exe /appfabric:[Full AppFabric Installer path]

I faced these errors during this procedure:
1- Error: This argument requires a custom file location
2- Error: Startup task doesn't exist. This is not a continuation after a restart.

Both errors mean that the filepath is not correct. It supposed to use " " to determine this is a full installer path.

umm.. Don't forget to run the command prompt using the Run as administrator

Enjoy :)

SharePoint 2010 - Export security groups and users to Excel / Text using Power Shell

2013-06-06T06:39:00.000-07:00

Dears,
One of my tasks today is listing all security groups with their members under specific site collection. I checked the Internet for the best approach but most of the articles were handling this topic using object model code. I found Power Shell is the most useful tool for achieving my task.
Here is my Script:

$site = Get-SPsite http://servername/sites/sitecollection

$allwebs = $site.AllWebs

$output = ""

foreach ( $web in $allwebs)

{

$groups = $web.groups;

foreach ($grp in $groups)

{ foreach ($user in $grp.users)

{ $Output += $web.name + "##" + $grp.name + "##" + $user.name + "@@@"

}

$site.Dispose()

$Output > "C:\AllWebsMemberExport.txt"

Enjoy :))

Configure SharePoint Server 2013 in a Three-Tier Farm

2013-03-10T03:45:00.003-07:00

Hi All,

This paper contains a brief introduction to SharePoint Server 2013 and step-by-step instructions for creating a test lab that contains a three-tier SharePoint farm that is based on the Base Configuration test lab guide (http://go.microsoft.com/fwlink/p/?LinkId=198140) and the SQL Server 2012 test lab guide (http://go.microsoft.com/fwlink/p/?LinkID=256663). It also demonstrates the facilities of a default team site.

File name	Size
tlg-sp2013-three-tier.docx	159 KB	Download
tlg-sp2013-three-tier.pdf	514 KB	Download

SharePoint 2010 Metro Style UX Trial

2013-02-26T01:16:00.001-08:00

Hi All,
It's my pleasure sharing with you my first trial using Metro Style UI with SharePoint 2010 - Intranet Portal. I used MetroGrid webpart - CodePlex has great features:

jQuery modal dialog window for adding, editing, deleting metro grid tiles
Slick jquery ajax interaction, including dragging and sorting (using jQuery UI)
251 metro-ish icons included in 7 different sizes (32px, 48, 64, 80, 96, 112, 128).
Use your own icons too, by entering image URL with preview
Only web/site/site collection admins can create, update, delete, re-arrange grid tiles.

SPContext.Current.Web.CurrentUser.IsSiteAdmin
or, SPContext.Current.Web.UserIsSiteAdmin
or, SPContext.Current.Web.UserIsWebAdmin

with little enhancements in masterpage UI, simply I introduce my 1st trial :)

hope you like it :))

E-Book Gallery for Microsoft Technologies - SharePoint

2013-02-05T22:53:00.000-08:00

Hi All,
TechNet offers a great collection of e-books. you can download content for ASP.NET, Office, SQL Server, Windows Azure, SharePoint Server and other Microsoft technologies in e-book formats. Reference, guide, and step-by-step information are all available. All the e-books are free. New books will be posted as they become available. I'll share with you SharePoint Section

SharePoint Section

SharePoint

Developer training | apps for Office and SharePoint 2013

2012-11-03T11:37:00.004-07:00

Hi All,
Learn about apps for Office and SharePoint with this interactive course offering developer-focused how to training and walk through videos.

http://msdn.microsoft.com/en-us/office/apps/fp123626.aspx

Enjoy :))

Shrink your database automatically from Central Administration

2012-10-09T04:02:00.000-07:00

Hi All,
Most of us face this issue "How to shrink my SharePoint Databases?" there are a lot of references on the web talk about this issue and how can i use the best practice for maintaining my databases.

In this post, you may find the best way to handle this hassle with the out of box solution
From Central Administration -> Review problems and solutions
http://yourcentraladmin/Lists/HealthReports/AllItems.aspx

If you see a warning under the "Availability" - "Database has large amounts of unused space", Select the item and View Item

Click on "Repair Automatically" button
If you change the rule definition, SharePoint should be able to fix it for you.

Enjoy :)

SharePoint Store - Snapshot

2012-08-26T07:19:00.001-07:00

Hi All,

SharePoint Store

I'd like to share my 1st experience with SharePoint store and wait for more :))

ME & SharePoint 2013 Preview

2012-08-02T08:00:00.001-07:00

Hi All,
It seems amazing...Let's start :))

After finishing installing Office 365 Preview online

Deployment guide for SharePoint 2013 Preview

2012-07-18T08:16:00.001-07:00

Download this free ebook to learn how to install and configure SharePoint Server and SharePoint Foundation .. here

Enjoy :))

SharePoint 2013 Preview is here!

2012-07-17T10:12:00.000-07:00

Hi All,

Microsoft just introduced SharePoint 2013 to the public. This is the Preview (Beta) version has a lot of changes and new features in the new version and everyone who is working on Office and SharePoint should give it a try.

Here are the most updated references that contain all reviews, training, and API references, and other documentation for SharePoint 2013 Preview.

Download SharePoint Foundation 2013 Preview:

http://www.microsoft.com/en-us/download/details.aspx?id=30345

Find how-tos, overviews, training, and API references, and other documentation:

http://msdn.microsoft.com/en-us/library/jj162979%28office.15%29.aspx

What's new for developers in SharePoint 2013:

http://msdn.microsoft.com/en-uhttp://www.blogger.com/blogger.g?blogID=6955671627571340396#editor/target=post;postID=2570975622987439476s/library/sharepoint/jj163091%28v=office.15%29

SharePoint for developers (Landing Page):

http://msdn.microsoft.com/en-us/sharepoint

SharePoint 2013: presentation: IT pro training:

http://www.microsoft.com/en-us/download/details.aspx?id=30361

Sharepoint 2013 Project Server 2013 Office 2013 Preview Resources (faisalmasood.com):

http://blog.faisalmasood.com/2012/07/sharepoint-2013-project-server-2013.html

Enjoy :))

SharePoint 2010 (June 2012 CU) has been released

2012-07-07T06:29:00.000-07:00

The next cumulative update is available. It is still highly recommended to install SP1 before you install post SP1 updates.

MSF2010: 2598373 The full server package for Microsoft SharePoint Foundation 2010
http://support.microsoft.com/default.aspx?scid=kb;EN-US;2598373

Download link: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2598373&kbln=en-us

SPS2010: 2598354 The full server package for SharePoint Server 2010 and contains also the MSF2010 fixes so you need only this one package.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;2598354

Download link: http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2598354&kbln=en-us

SPS2010 with Project Server 2010:

KB 2598355 - SharePoint Server 2010 with Project Server

Download SharePoint Server 2010 with Project Server June 2012 CU

Important for all Server Applications listed above: After applying the preceding updates, run the SharePoint Products and Technologies Configuration Wizard or “psconfig –cmd upgrade –inplace b2b -wait” in command line. This needs to be done on all servers in the farm with SharePoint installed. You can run psconfig in parallel on all SharePoint machines.