SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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 

  1. Open Central Administration
  2. System Settings
  3. Manage Farm…

Read more

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

Read more

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.


Read more

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.


$style = "<"…

Read more

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.

$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()…

Read more

5 comments, 2,286 reads

Posted in SQL Server Tips on 23 June 2011