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 PowerPivot Web Application to the sharepoint application, we will get the following error
Error: Could not load type 'Microsoft.AnalysisServices.Sharepoint.Integration.ASLinkFilePage'.
To solve the error
- Open Central Administration
- System Settings
- Manage Farm…
0 comments, 2,604 reads
Posted in SQL Server Tips on 21 March 2012
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 link http://www.sqlserverlaunch.com
and you can reach the full agenda from the http://www.sqlserverlaunch.com/ww/agenda
0 comments, 830 reads
Posted in SQL Server Tips on 2 February 2012
Remove All Foreign Keys
To clear test data from a database we could use truncate commands but sometimes we need to get rid of foreign keys.
we could get constaint list from INFORMATION_SCHEMA.TABLE_CONSTRAINTS table.
for example :
we could remove foreign key by using this table and the following query.
while(exists(select 1 from INFORMATION_SCHEMA.TABLE_CONSTRAINTS…
3 comments, 28,631 reads
Posted in SQL Server Tips on 11 October 2011
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 specific registry keys , because of this you need to restart the computer after executing the script.
Change new path variable to your custom folder path, execute script using… Read more
1 comments, 1,608 reads
Posted in SQL Server Tips on 14 August 2011
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 html file to read easily from our web server.
that is the simpel version of the script that i published on the Microsoft Script Repository Site.
http://gallery.technet.microsoft.com/scriptcenter/bcdb30d6-b6ee-490f-ab8b-2e124c9159f4
$style = "<"…
2 comments, 964 reads
Posted in SQL Server Tips on 23 June 2011
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 organizations are made sysadmin by default but sysadmin role gives them full control over the data. The basic idea behind Seperation of Duty is to create user for… Read more
1 comments, 1,310 reads
Posted in SQL Server Tips on 23 June 2011
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 jobs at one time.
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") $server = New-Object Microsoft.SqlServer.Management.Smo.Server("localhost") $scripter = New-Object Microsoft.SqlServer.Management.Smo.Scripter($server) $jobs = $server.JobServer.get_Jobs() | Where-Object {$_.Name -notlike "sys*"} $script = "" foreach($job in $jobs){ $script += $job.Script()…
5 comments, 2,286 reads
Posted in SQL Server Tips on 23 June 2011