Recover access to a SQL Server instance

Recover access to a SQL Server instance:

Another way is to start sql in single user mode, but the above approach using psexec is much better!

The SQL Server Reporting Services (MSSQLSERVER) service failed to start + after SP2 installation on Windows 2008 R2 | Data Base Internal

The SQL Server Reporting Services (MSSQLSERVER) service failed to start + after SP2 installation on Windows 2008 R2 | Data Base Internal:

'via Blog this'

delete orphaned sql jobs

--select * from sys.master_files order by physical_name

select * from dbo.sysjobs
select * from dbo.sysmaintplan_subplans

delete from dbo.sysmaintplan_subplans where subplan_id='7659F4CD-F98D-4F28-9372-5DBDC0BE168D'

delete from dbo.sysmaintplan_log where subplan_id='7659F4CD-F98D-4F28-9372-5DBDC0BE168D'

--sp_help sysmaintplan_subplans

delete from sysjobs where job_id='B3FECCA3-A0D2-4BEA-88D6-685EBE2F1164'

Cannot open or create word documents in SharePoint 2013 with Office 2010 and Project 2013 - Microsoft Project For All - Site Home - TechNet Blogs

Cannot open or create word documents in SharePoint 2013 with Office 2010 and Project 2013 - Microsoft Project For All - Site Home - TechNet Blogs:

'via Blog this'

BizTalk 2013 and SharePoint 2013

There is no need to install the sharepoint web service adapter...the default biztalk installation already get the connectivity to sharepoint 2013 without installing anything on the sharepoint server :-)

SharePoint 2013 - Drag and drop requirements ~ Microsoft..what else?

SharePoint 2013 - Drag and drop requirements ~ Microsoft..what else?:

'via Blog this'

Throttle a Query in Mid-Execution - SQLServerCentral

Throttle a Query in Mid-Execution - SQLServerCentral:

'via Blog this'