Well its been quite sometime now since our last post, was so busy with lots of things now that I manage three teams, Development, Operations and Project Management. My programming activity drastically went down as I do a lot of juggling between three roles plus managing them, imagine a portfolio of 63 projects last year… Read More »
Have you ever encountered this error when you are trying to add a database on your Always On Availability Groups? “This database is encrypted by database master key, you need to provide valid password when adding it to the availability group.” You get this on the Wizard after warning you that a Password is required… Read More »
You might be in a scenario where you were assigned to find a certain text on all the records on your database. Well you might think that’s easy, well yes if you have only one database with few tables and records but what if you have a large database with tons of tables then its… Read More »
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.
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… Read More »
You might have upgraded your Sharepoint to 2013, have this “Sorry, something went wrong error” and you don’t know whats causing it. This was my issues several week ago when I migrated our Sharepoint. I looked at the old version and it all works fine but on the new instance it does not work, I checked everything and compare… Read More »