2013-12-31

TSQL - SSMS intellisense refresh

Go to a query window in SQL Server Management Studio
Press CTRL + SHIFT + R

PS. This works at least on SQL Server 2012.

2013-12-30

TSQL - Dynamic SQL execution results into variable


declare @RecordCount as int;
       set @RecordCount = 0;
declare @SQL as varchar(2000);
       set @SQL = 'select @x=FIELD_NAME from TABLE1;';


exec sp_executesql @SQL, N'@x int out', @RecordCount out;

TSQL - List of all linked servers

SELECT * FROM sysservers;

2013-12-12

Apache Web Server PHP - How to enable PHP in MacOS embedded apache web server


(1) Locate this file, and open it.
/private/etc/apache2/httpd.conf

(2) Look for this line and uncomment it (remove the starting # sign)
# LoadModule php5_module libexec/httpd/libphp5.so

(3) Restart the apache web server
sudo apachectl -k restart

2013-12-10

SharePoint - Configure managed accounts error "object reference not set to an instance of an object"


Open SharePoint 2010 Management Shell (Programs > Microsoft SharePoint...)

$ma=Get-SPManagedAccount -Identity "\"
$ma.AutomaticChange=$false
$ma.Update()


Original source...
http://social.technet.microsoft.com/Forums/sharepoint/en-US/406f1817-d687-49d7-9691-26e487fb5577/configure-managed-accounts-object-reference-not-set-to-an-instance-of-an-object-error?forum=sharepointadminprevious