Skip to content

Recent Articles


Delivering Tax Technology Solutions with SQL 2012

For those of you who don’t know for the past couple of years I’ve been focusing on creating our services around Tax Technology using the latest Microsoft technologies. Our fiscal year ends at the end of this month and thinking back I’m happy to say that last year was a very productive year. The Solution Center that I run was able to launch several services and solutions for the Tax world. Some of the solutions we rolled out to our clients are Tax Operations Manager, Tax Data Warehouse Service, Data Import and Set-Up Service, Corporate Tax Reporting (ITRS), Tax Community of Interest Site, Transfer Pricing Integration Manager (TPiM), Audit Manager, Tax Operations Manager for Live Events, and Tax Development Service which are all compatible with SQL Server 2012 and sit on SharePoint.

Even though SharePoint was the core foundation, SQL 2012 was a very critical part of all of these solutions. We’re leveraging all aspects of SQL 2012 from Integration Services to Analysis Services to Reporting Services. We’re leveraging Data Quality services and Master Data Services. Tabular BISMs are a core part of our architecture which allows us to quickly create new models for our Tax clients. BI with SQL 2012 is just pure fun to work with. My team was very happy with what we could accomplish very limited budget and time. As always after a long year of developing on SQL 2012 I’m putting together series of blogs, content and presentations.  I’m looking forward to getting back to the presenting world and connecting with all of you.

Having said that I’m super excited to let you know that my next session will be the  SharePoint Fest – D.C. 2013  August 5-7 – Bethesda North Marriott Conference Center Feel free to use the following code (Cavusoglu100DC) for a discount when you’re registering.  Below are the details for the session. Look forward to seeing you there.

BI 102 – Data in the Cloud: Creating SharePoint 2013 BI Solutions using Azure

In this session we will cover the different flavors of Azure and to Windows Azure SQL Services. We will look at creating reports using Data in the Cloud. We will connect to a Azure SQL Database through WCF Data Services. We will also cover the topic of Big Data. An overview of Big Data concepts and and how to use big data without crashing your budget and servers. And finally we will go over the Azure Data Market, we will look at the basic concepts around building an app to consume data from a Windows Azure Data Market feed.


SharePoint 2013 Trial

When I talk to most of my clients I see that most of them aren’t aware that you can actually spin up a trial version of SharePoint 2013 on an Office 365 Environment. If you quickly want to setup a SP2013 Trial Environment I would defintely recommend that you click on the below link to get this going. It takes only about 5 minutes to set everything up.

If you’re an IT Pro, I’m sure you have the link to download SharePoint 2013, but just in case you don’t have it here is the link




SSRS 2012 Service Application in Sharepoint 2013 returns internal Server Error (500)

So you are installing SQL Reporting Services in a 2 or more server farm. And when you go to the service to manage it you’re getting the following error

Application error when access /_admin/ReportServer/ReportingServicesSystemSettings.aspx, Error=The remote server returned an error

If you’re getting this error after you installed the SQL Reporting Services Add-in for SP2013 that means you haven’t installed Reporting Services on a SharePoint 2013 server. You can either install SharePoint on your Reporting Services installed server or  install Reporting Services to one of your SharePoint App servers.

Install SQL Server 2012 Reporting Services on a SharePoint application server. In the SQL Server 2012 installation wizard, choose ‘Reporting Services – SharePoint’ on the feature selection page.


Hardware and software requirements for SharePoint 2013 Development Environment

For single server installations that you would typically use for your development environment you need minimum 24 GBs of RAM, 4 Cores, and 80 GBs of space.

Based on the MSDN article located at –

PowerView SQL 2012 and SharePoint 2013

Install Reporting Services SharePoint Mode for SharePoint 2013

So you installed SQL 2012 and SharePoint 2013 but you don’t know how to get Reporting Services working so you can use Power view? Well no worries here is a summary of what you need to do.

First, Install the Service

The first thing you need to make sure you do is install the service on SharePoint. Run the following PowerShell commands in SharePoint 2013 Management Shell as an administrator.

  1. Install-SPRSService
  2. Install-SPRSServiceProxy
  3. get-spserviceinstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance

Second, Create the Service Application

After you install the service in Central Administration you will now have the option to create a new SQL Server Reporting Services Service Application.  Go to  Application Management group, click Manage Service Applications and create a new service application. If you don’t see this option that means the above steps weren’t successful in creating the service. So make sure you have that completed before you try to create a new service application.

Third, Activate the Powerview Feature

To activate the feature, go to the site collection features and find the feature Power View Integration Feature  in the list and click Activate.



For detailed step by step how to visit the MSDN article – Install Reporting Services SharePoint Mode as a Single Server Farm


Hi blog, I’m back!

It’s been a crazy year since I started PwC. I’ve been lucky enough to be working with great people – with world class talent … It has been fun and exciting, but it has been just a super high tempo of traveling around the country transforming tax technology using SharePoint. My team has been waiting for SharePoint 2013 and we’ve been working on creating a solution for Tax Departments using the new SharePoint 2013 functionality. I’m looking forward to sharing with you some of our best practices and findings with our SharePoint 2013 implementations. Let the blogging begin!



Published Content Types and Reusable Workflows

Here is a great post on Published Content Types and Workflows by Jennifer Mason.



How to create a Custom Theme for SharePoint 2010 in 10 minutes

Here is a great post on a tool called Theme Builder. Lou van der Bijl has done a great job in explaining how the tool works. Check it out!


SharePoint Saturday Virginia Beach

This year in SPSVB 2011 I spoke on two topics.

– SharePoint 2010 Records Management Capabilites

– SharePoint 2010 Workflows

Below are the links to the slides, please feel free to contact me I always welcome your feedback!


Live Online SharePoint Saturday EMEA

Live Online SharePoint Saturday EMEA is back on January 22nd, 2011. This is the second annual SPSEMEA and promises to be a huge event with over 30 sessions, 4 simultaneous Live Meeting Channels and a public text chatroom open to participants and speakers.
Registration for SPSEMEA begins on January 11 and is free to the global SharePoint Community. There are over 30 SharePoint Evangelists, including 10 SharePoint MVPs, from around the world providing content you would normally only see at a paid SharePoint Conference. Tracks are set for SharePoint End Users and Business Managers on topics for “How We Did It: Real World Case Studies“, “No Code/Assembly Solutions“, “SharePoint Interface Branding“, and “SharePoint for Business“. The sessions will be recorded and made available two weeks after the event.
I will be talking about Records Management in SharePoint 2010 and hope to see you there and will be ready to answer your questions.
We hope you’ll join us for Live Online SharePoint Saturday EMEA. Please register in advance to guarantee yourself free access to some of the best presentations available, all aimed at SharePoint End Users.
See you there.
Coskun Cavusoglu