Have you ever wondered how to make your SSIS more dynamic by putting your variable values in SQL server? Well its quite straightforward all you need to know is to enable package configuration on your solution.
Have you ever encountered this SharePoint issue where a certain user gets an Access Denied message when he accesses a certain resource in SharePoint and you already given that user the rights through a group in Active Directory?
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 […]
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 […]
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.
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.
1. Install Reporting Services in SharePoint mode. 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 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.
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 […]
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 […]