Error: Could not load type 'Microsoft.AnalysisServices.Sharepoint.Integration.ASLinkFilePage'.

To create a PowerView report first we need to create a BI Semantic Model Connection,

but If we did not deploy...

SQL Server 2012 Virtual Launch

Microsoft organized a virtual event for SQL Server 2012 on March 7, 2012.

You can register the event by using the...

Remove All Foreign Keys

To clear test data from a database we could use truncate commands but sometimes we need to get rid of...

Change User Desktop Folder Path by Using PowerShell

We could change your desktop folder location by using the following powershell script. Actually we need to change values of...

Export SQL Server Error Messages from Event Viewer As HTML

i use the following powershell script to retrive all sql server error logs from event viewer and export as a...

SQL Server Separation of Duties

Microsoft published a white paper named "SQL Server Seperation of Duties". Security always an important problem for DBAs and many...

Taking Script of Sql Server Jobs for Migration

when migration sql server database to a new server, i use the following powershell script to take all sql server...