There are several ways to remove duplicate records during an ETL process. An easy way to accomplish this is using the SSIS Sort Transformation. Create a Data Flow Task in SSIS. Drag an OLEDB Source task, Sort Transformation and OLEDB...

If you have to add new apps to SharePoint, you have to first setup an app catalog site. Here are the steps to get it setup. Open and Login to the Office 365 admin Center Office 365 Admin Center Open...

In a SharePoint Discussion Board there is a default checkbox column named ‘Question’. Unfortunately this is a sealed column and unlike other SharePoint columns, we are not able to change its properties and make it ‘Yes’ by default. A way...

SQL Server Reporting Services traditionally has been used for creating paginated reports. Paginated reports are formatted for printing and are reports you can export and email. Paginated Reports is just one of the type of reports today that companies use...

Here are some SQL queries that I find very useful when writing stored procedures. Using these queries, you can easily find the first date and last date of the current month, previous month or next month. Current Date without Time:...