Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 870 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, 489 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…

Read more

2 comments, 10,860 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, 844 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 = "<"…

Read more

2 comments, 539 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, 792 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()…

Read more

5 comments, 1,324 reads

Posted in SQL Server Tips on 23 June 2011