Tag: SQL Server

SQL SERVER – Troubleshooting: When Database Creation Takes Long Time

Monday Coffee 2017-02-27

SQL SERVER – Maintenance Plan failing with 0x80131904 – A network-related or instance-specific error occurred while establishing a connection to SQL Server.

SQL SERVER – Event ID 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance Name)

SQL SERVER – Fix: Error: 1934, Level 16, INSERT or UPDATE Failed Because the Following SET Options have Incorrect Settings: ‘QUOTED_IDENTIFIER’.

SQL SERVER – Improve Application Performance on Cloud While Reducing Bandwidth Cost

A Program to Find INSERT Statements That Don’t Specify Columns

SSMS Presenter Mode

Quick Tips:- Add SQL User/Rolemember to all Databases in SQL Server

SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup

SQL Server vNext: sys.dm_db_stats_histogram