Speaker at second online Office 365 Saturday Event!

Office 365 Saturday

I’ve been selected to deliver an online session for the Office 365 Saturday Europe Event! Join us for the second Online Office 365 Saturday event! Learn from the knowledge and experience of our speakers on how Microsoft Office 365 can be used to deliver world-class communications, collaboration, and social solutions. Technologies covered include Office 365, Exchange Online, SharePoint Online, Lync Online, Windows Azure and Yammer, and they will be spread over various different tracks you can choose from.

Office 365 Saturday

My session? The good, the bad and the ugly part for Office 365 

Office 365 is becoming more and more indispensable for small and lone companies. Moving to Office 365 comes with multiple key benefits and key features. Everybody’s focal points are on the benefits (Generate greater productivity with Office 365, Access from anywhere with Office 365, Robust security …) but the drawbacks are being omitted. What about the issues that the corporates are facing? This session focalises on all interested parties who might be interested in the whole cloud process (migration, upgrade…). Why can’t I migrate to the cloud for Public Facing Websites? What are the possible risks? Why should you think twice before designing a hybrid environment? Will Yammer play a key factor in your cloud Migration or upgrade process? 

After this session you’ll be able to know exactly what the “cloud” represents with his benefits and drawbacks and should be able to lead any SharePoint project wherever it may be required.

More info on: http://office365saturday.net

Register here

Check the sessions list and speakers

Speaker aux Journées SQL Server 2014 #JSS2014


Bonne nouvelle!

Les Journées SQL Server reviennent pour leur 4ième édition. Il s’agit tout simplement du plus gros événement dédié à SQL Server en France. Et devinez quoi? J’ai été sélectionné en tant que speaker pour les Journées SQL Serveur 2014 !

Quand ?

Les Journées SQL Server se déroulent sur 2 journées. Elles auront lieu les : Lundi 1er Décembre & Mardi 2 Décembre 2014 9h – 18h

Où ?

Comme lors des deux précédentes éditions, le Centre de Conférences Microsoft accueillera les JSS :

  • Centre de Conférences Microsoft
  • 41 quai du Président Roosevelt
  • Issy-les-Moulineaux


L’inscription générale à l’événement se fait sur cette page. Une fois l’agenda connu, vous pourrez vous inscrire aux sessions sur une page dédiée. Besoin d’être convaincu ? Jetez un œil sur tous les Webcast de l’édition 2013 : http://guss.pro/2013/12/07/slides-journees-sql-server-2013/

Ma Session ?

J’interviendrais le lundi, juste après Serge Luca; avec mon compère Benoit Jester; Optimisation SQL Server pour SharePoint ( Eh oui, parfois on à pas le choix :-) )


Au plaisir de vous y trouvez nombreux !

Happy Speaking !

Speaking at SQL Saturday Istanbul 359

I’m extremely happy and honored to announce you that I’m going to deliver a session at SQL Saturday Istanbul 2014!


On the 06th of December 2014, I’m joining an incredible team MVPs, MCMs and MCTs for a great event. If you want to join us, here is the link to register: https://www.sqlsaturday.com/359/register.aspx .

It’s going to be a great event with lots of SQL and SharePoint awesomeness as my session is SharePoint related :-)

Awesome content, awesome speakers, awesome venue, awesome city. I am truly excited because Istanbul is one of the greatest cities to visit in the world. Well, Istanbul is not the only thing, because last year at SQL Saturday Istanbul they had a real blast and that’s the major reason why I wanted to go to my second country: TURKEY!

Please check this video to see http://f.vimeocdn.com/p/flash/moogaloop/6.0.20/moogaloop.swf?clip_id=103630966


This is the biggest free conference of its kind in Turkey so well worth going for a day of SQL!

Microsoft – Bellevue Residences, Levent Mahallesi, Aydin Sokak, NO:7, Levent 34340, Istanbul/Turkey, Istanbul, 34340, Turkey

Hope to see you there!


Delete of an Application Pool via Powershell or by the Object Model

Delete Service Application Pool via PowerShell

When creating a new website or a new Service Application, SharePoint asks you to create or to use an existing Application Pool. Well, this is not completely true. SharePoint asks you this only if you’re creating a new website.


If you create a Service Application trough the User Interface or PowerShell cmdlets, you don’t always have the choice to create a User Friendly Application Pool without a GUID.


As you can see on the image, I have the Subscription and Application Management Service Applications running on my SharePoint Farm and if I didn’t use a managed account, I couldn’t easily know witch Service Applications belongs to witch GUID.

If you’re interested in creating the Subscription and Application Management Service Applications, please refer to the following link: http://technet.microsoft.com/en-us/library/fp161236(v=office.15).aspx

According to TechNet you can use the following PowerShell cmdlets to create the Subscription and Application Management Service Application:

$account = Get-SPManagedAccount "______________" 
$appPoolSubSvc = New-SPServiceApplicationPool -Name "______________" -Account $account
$appSubSvc = New-SPSubscriptionSettingsServiceApplication -ApplicationPool $appPoolSubSvc -Name "______________" -DatabaseName “______________”
$proxySubSvc = New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $appSubSvc
$account = Get-SPManagedAccount "______________" 
$appPoolAppSvc = New-SPServiceApplicationPool -Name "______________" -Account $account
$appAppSvc = New-SPAppManagementServiceApplication -ApplicationPool $appPoolAppSvc -Name "______________" -DatabaseName “______________”
$proxyAppSvc = New-SPAppManagementServiceApplicationProxy -ServiceApplication $appAppSvc


The PowerShell cmdlets works perfectly, but if you delete the Service Application (through Central Administration or PowerShell) and run the same cmdlets on the same server; you can receive an error that the Application Pool named “________________” already exists under the parent named “SharePoint Web Services”. Rename your object or delete the existing.


There is no way to delete a Service Application Pool via Central Administration or IIS. Therefore you need PowerShell. Open PowerShell in Administrator mode and execute the following cmdlet: Get-SPServiceApplicationPool. This will show you all the Service Application Pools used by SharePoint.


By a simple where operation you can get your Service Application Pool. Don’t forget to put the Service Application Pool in to a variable to facilitate operational tasks.

$var = Get-SPServiceApplicationPool | where {$_.Name –eq “Application Management”}


And finally you can delete the Service Application Pool with the Delete() Function.



Delete Service Application Pool via Object Model

We just saw, deleting the Service Application Pool is pretty easy. But this can be very difficult when you want to delete/modify an already running Service Application Pool. This is an extremely specific case. To give an example: if you are deleting a Service Application or Website and another SharePoint Administrator is resetting the Application Domain, SharePoint can’t properly delete everything. Make sense he?

Well there is no out of the box cmdlets, so you’ll have to deal with the Object Model. Please use the following cmdlets

$ServiceApplicationPool = [Microsoft.SharePoint.Administration.SPWebService]::ContentService.ApplicationPools | where {$_.Name -eq "Application Management"}

If you want to list every Application Pool used by your SharePoint farm you can execute the following powershell cmdlets

[Microsoft.SharePoint.Administration.SPWebService]::ContentService.ApplicationPools | ft Name

Notice, however, the Central Administration Application Pool is not listed .Only Application Pools from content-based web applications are listed.


To get the administrative Application Pools, use the following cmdlets:

[Microsoft.SharePoint.Administration.SPWebService]::AdministrationService.ApplicationPools | ft Name



Application Pool Security

I once a time asked to Microsoft why we easily could decrypt the IIS Application Pool passwords. The classic answer was “it’s by design”. I don’t know if it’s a security issue or not but at the last part of this article we’ll have a look on how de decrypt an Application Pool Password in a few clicks.

Take the example that you lost your SharePoint Central Administration password – who is actually your SharePoint Farm Administrator Password.


  1. Open CMD in administrator mode and browse to the following path. C:\system32\inetsrv\



  1. Run APPCMD List AppPool “Your Application Pool” /text:*


  1. Replace “Your Application Pool” with the App Pool name of which you want to retrieve the password.

And Hooray, you can see your Password in clear text in the Command Prompt.


Action of Microsoft SharePoint Upgrade SPContentDatabaseSequence failed to rollback

When I wanted to migrate a content database I got the following error: Action of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed to rollback.

I was receiving this while doing a 2007 to 2010 database detach – attach method. The PowerShell cmdlets that I was using where the following: Mount-SPContentDatabase “MyDatabase” -DatabaseServer “MyServer” -WebApplication http://sitename


On many internet sites, you can see that this can be easily resolved by extending the space on the SQL drive where the MDF and LDF are located (out-of-space). Following these articles, I saw that I still had 150GB free space on my Drive.

The database that I was trying to restore was 110 GB and the space on the drive was 150GB. So according to all the articles that I found, nothing was applicable to me.


But when navigating to the Userdata and Userlog folders, I saw a strange folder logo. According to the global administrator here at the organization this was a mount point.


According to TechNet: Volume mount points are robust against system changes that occur when devices are added or removed from a computer. A volume mount point can be placed in any empty folder of the host NTFS volume. The mounting is handled transparently to the user and applications. The version of NTFS included with Windows 2000 must be used on the host volume. However, the volume to be mounted can be formatted in any Windows 2000-accessible file system, including NTFS, FAT16, FAT32, CDFS, or UDF

You can check all your Mount Points via Administrative Tools >> Computer Management >> Disk Management.


And well, strike! Even if my D drive had 150GB of free space, the volumes where my LDF and MDF files were stored had no more than 8% free.

Just ask for more space and you’re attach should go without any problem

ReBuild 2014 PowerPoint Presentation and Pictures

Today, I had the chance to speak at the second edition of the Rebuild 2014 at Nantes, France – organised by l’association les Comm​unautés MS. 40 technical sessions, 38 speakers and more than 15 Microsoft MVP’s were present at Rebuild 2014 this year.

ReBuild 2014

A great success organised by Laurent Milten Delinchamp (Office365 MVP) and Kevin Trelohan (SharePoint MVP). You can always check the official site for more information about the organization and more on: https://lescommunautesms-public.sharepoint.com/rebuild

My PowerPoint Presentation

If you are a fellow follower of my blog, you’ll notice that the presentation is the same as last week-end; presented at SharePoint Saturday Jersey!


Nantes by Night

Nantes - Rebuild 2014

Keynote held by Laurent !Nantes - Rebuild 2014

A selfie at the Speakers room. 5 French and 1 Belgian MVP!

Many other experts and MVP’s where present, but this was the most “crazy” group at Rebuild! 2 SharePoint, 2 Office 365, 1 Powershell and 1 Lync Server! A big up to Patrick Guimonet, Gilles Pomier, Guillaume Meyer, Eudes-Olivier Robert, Fabien Dibot!

Nantes - Rebuild 2014

Me in action:

Rebuild 2014

Rebuild 2014 Twitter98765a8

And of course; our Patrick Guimonet and Gilles Pompier! Well, Benoit, in French : “tu nous as (pas) manqué” :-)


Microsoft SharePoint MVP for a second year


1 day ago the Microsoft MVP Award team announced on their blog that 1031 exemplary community leaders around the world were notified that they have received the MVP Award! You can read the complete blog post here: http://blogs.msdn.com/b/mvpawardprogram/archive/2014/10/01/congratulations-to-all-the-new-and-renewed-mvps.aspx

Banner MVP

While there are more than 100 million social and technical community members, only a small portion are selected to be recognized as MVPs. Each year, around 4,000 MVPs are honored. They are nominated by Microsoft, other community individuals, or in some cases themselves. Candidates are rigorously evaluated for their technical expertise, community leadership, and voluntary community contributions for the previous year. They come from more than 90 countries, speak over 40 different languages, and are awarded in more than 90 Microsoft technologies. Together, they answer more than 10 million questions a year!

I am once again very honored and humbled that Microsoft recognized my community contributions and selected me as a SharePoint MVP for the second consecutive year. You can always check my MVP Profile to see my contributions: https://mvp.microsoft.com/en-us/mvp/Gokan%20Ozcifci-5000391

Here is a list of all my contributions last year:

  • TechNet SharePoint Forums Moderator
  • eBook: WikiNinjas Member (Tat leader, MTTC and MTFC Award, …)
  • eBook: The Wiki Ninjas Guide to SharePoint 2013 – IDTP
  • MVP Forum Stats – Top 5
  • eBook: SharePoint Customer Auditing Process
  • Speaking: TechDays Paris 2014 : Ask The Expert
  • Speaking: SharePoint Saturday Gulf
  • Speaking: SharePoint 24 Conference
  • Speaking: PimpMySharePoint : Le cloud est-il adapté aux grandes entreprises
  • Speaking: CozumPark: Office 365 ile Yammer ister istemez gelecegimizdir. Peki SharePoint?
  • Speaking: Microsoft Innovation Center: The difference between On-Premises and Their-Premisses
  • eBook: The WikiNinjas Guide to SharePoint – Part II
  • Speaking: SharePoint 2013 Architecture – Fundamentals
  • Speaking: GUSS France: Sharepoint 2013 et SQL Server 2012 sur les bonnes pratiques à adopter
  • eBook: Les usages et techniques de Yammer et Office 365
  • Speaking: SharePoint Saturday Cairo
  • Speaking: UGSF
  • Speaking: SQL Saturday France
  • Speaking: SharePoint Saturday Jersey
  • Speaking: Rebuild 2014

This is my second consecutive year, and again, been an awesome year, particularly since SharePoint goes from strength to strength. A big thanks of course goes to my MVP Lead and all other SharePoint community members!

MVP x2