About these ads

How to create Data driven report subscriptions in SQL Server Standard Version

I guess you are here because you are looking for a solution that will send your SSRS reports via email to a dynamic recipient list related to your data in your SSRS report.  In SQL Servers Business Intelligence and Enterprise Edition this feature is included but if you use a lower edition like Standard and Web well you are out of luck as this feature is not available.  Don’t loose hope though as there are lots of workarounds where we can recreate these function using only what you already have SSIS.

Read more of this post

About these ads

Generate Multiple Worksheets by Groups in SSRS Exported Excel Spreadsheets

You might be wondering how to generate multiple dynamic worksheets in SQL Server Reporting Services, is this even possible or not? Well if you are using SQL Server 2008 R2 and above you are lucky as this is now possible if not I guess it is the time to upgrade.

So how do you achieve this?

It is fairly easy, all you need is to follow this 4 easy steps. Read more of this post

Grouping and Calculate Totals from one SharePoint List to another

You might be wondering how to summarize list items by grouping and summing them up together to another SharePoint List? Well it’s quite simple and you can achieve them just by using workflows created in SharePoint Designer. Read more of this post

How to use Secure Store Service in an External Content Type in SharePoint Foundation 2013

When SharePoint Foundation 2013 was released and you saw Secure Store Service is included you almost jumped in joy as you know this will give you a lot of possibilities. You then started to tinker by creating a new page and a new external content type that can connect to your database. Read more of this post

Installing Integrated Reporting Services on Sharepoint 2013 in 7 easy steps

1. Install Reporting Services in SharePoint mode.

01 Install Sharepoint Add In

Get your SQL Server installation media, go to the New SQL Server stand-alone installation or add features to an existing installation then select the following

Reporting Services – SharePoint
Reporting Services add-in for SharePoint Products
SQL Server Data Tools
Management Tools – Basic
Management Tools – Complete

continue with the defaults then when you reach the Reporting Services Configuration page just choose the Install Only, complete the process. Read more of this post

Enabling and Disabling Claims Based Authentication in Sharepoint 2013

With the coming of new SharePoint 2013 you have to the option of using the Claims Based Authentication or the classic Windows but you might be wondering how do you change that setting.  Well you need to do it in SharePoint 2013 Management Shell and here is how its done. Read more of this post

Live Migration of SharePoint 2010 to SharePoint 2013

This post will give you a step by step process on how you upgrade your SharePoint 2010 to SharePoint 2013.  While this is a live migration I suggest you do proper backups of the server and the database before continuing.  Having said that live migration means that you can upgrade your SharePoint instance from one server to another without any downtime, but during the process anything that happens between like adding new items on the list or deleting a wiki page will not be captured after the copy database has been performed. Read more of this post

Migrate Team Foundation Server’s SQL Server to another SQL Server (same or new version)

Yesterday we migrated SharePoint’s SQL Server to a new instance today we will be migrating Team Foundation Server (TFS) SQL database to new SQL instance.
In this example we are migrating it to a new version of SQL Server which is from SQL 2008 R2 to SQL 2012, this will also work on the same SQL version. Read more of this post

Migrate SharePoint’s SQL Server to another SQL Server (same or new version)

This is a step by step guide on how you migrate your SharePoint’s (I used 2010 version in this instance) SQL Server to an new SQL Server host.  In this exercise I tried migrating it in a new version of SQL server which is 2012 from 2008 R2, also had tried it in the same version.  There are only 9 steps to perform this task but it takes into consideration you already have a new SQL Server provisioned. Read more of this post

Upgrading S#arp to MVC4

First of all I can assure you that S#arp will work on MVC4 and I am using Sharp Architecture 2.0.4.  We just recently migrated and tested 2 large S#arp projects and it is fully working and is running in production. Read more of this post


Get every new post delivered to your Inbox.

Join 197 other followers

%d bloggers like this: