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

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

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

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

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

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

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