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.
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… Read More »
You might have reached the threshold of a SharePoint List and you’re afraid to increase the limit as you might affect the performance of you server. Now you are thinking of other solutions and one thing came to mind, why not archive the data? Well that is a good idea but how are you going… Read More »
SSIS is a really good tool for performing ETL Transactions but have you ever wondered whether you can use this tool to perform CRUD operations from a data source? What if the datasource is from an Excel, this adds more complexity to the given problem, how would I loop through the rows of an Excel… Read More »
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.
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… Read More »
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… Read More »
Now that you have mirrored your servers, it does not mean that your users are also mirrored (isn’t it nice to have this feature included in next SQL Server releases). You should configure your users properly as well so when a disaster hits you wont have a login error issue when your application user tries… Read More »
We are in a middle of a SQL Server 2012 migration project and one of the main tasks is to completely mirror all of the databases. Having said that it does not mean we did not mirrored it before, some of the legacy databases are already mirroring and we have one dedicated server to do… Read More »
Did you encountered a problem where you wanted to change your database collation to default or even just changing it to a different type? I guess what you had initially done (like me) was to change the collation of the Database