Script To Generate Server level Permissions in SQL Server

Script To Generate Server level Permissions in SQL Server

Facts About Enabling / Disabling Indexes in Sql Server

How To Disable - Enable Indexes In SQL Server

Find SQL Server Details Using Query Analyzer

How To Explicitly Connect SQL Server Using Specific ( Named Pipes / TCP / Shared Memory ) Protocol : Interview Question

What is Statistic in Sql Server Part - 3

 Yes ! Auto update stats causing Performance issues??

What is Statistic in Sql Server Part - 1

What is Statistic in Sql Server Part - 2

What is Statistic in Sql Server Part - 2

Interview Question : Does sp_updatestats update the statistics of a table if I just run it or does it use specific formula??

What is Statistic in Sql Server Part - 1

What is Statistic in Sql Server Part - 3

How To Change SQL Server Port In SQL Cluster : Demo

How To Change Sql Server Service Account In Sql Cluster : Demo

An error occurred during the execution of xp_cmdshell. A call to ‘LogonUserW’ failed with error code : ‘1385’.

How To Shrink All database Log Files Together

How To view Registered SPN (Existing Service Principal Name )

How To Set SPN ( Service Principal Name ) : Demo

Procedure has no Parameters and Arguments were Supplied.

Sql Server Configuration Manager Remote Procedure Call Failed (0x800706be)

SQL Server Installation Add Features is not Showing All Instances

Today we get a request to install SQL server reporting services for 4 of 8 of the instances on a server.
As usual we pick our sql 2012 dump and start installing. When we reached to Add feature page of installation we were not able to see 4 of 8 instances in drop down as in screen shot

Difference Between varchar(max) and varchar(8000)

Script for Multiple Restore in one shot SQL server

Windows update can't check for updates because the service is not running

Patching does have its own issues, hard to predict

 This time I was doing windows updates

Control panel --> System and security --> Windows update -->check for updates