Microsoft SQL Server Error: SQL SERVER – Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ‘)’ or msg 102 level 15 state 1 line 3 incorrect syntax near ‘ ‘

Microsoft SQL Server Error: SQL SERVER – Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ‘)’ or msg 102 level 15 state 1 line 3 incorrect syntax near ‘ ‘ Details of Error: This error message occurs if we use GETDATE() like function as a parameter to Stored Procedure or Function Statement.…

Microsoft SQL Server Error: SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated

Microsoft SQL Server Error: SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated Details of Error: String or binary data would be truncated. The statement has been terminated. This error message below occurs when part data is been truncated while loading a table. Actual error message: Msg…

Microsoft SQL Server Error: 53 or Microsoft SQL Server Error: 11001 or SQL Server error 53 and 40. SQL server error 53 and 17

Protecting your database using Transparent Data Encryption in SQL Server 2008

Encryption: Encryption is the process of transforming information in plain text using a cipher, or algorithm, to make it unreadable to everyone other than the person who has the key. There are two types of keys; symmetric and asymmetric. When the same value is used to encrypt and decrypt, then it is known as a…

SQL Server RPO and RTO

ASYNC_NETWORK_IO Waits SQL Server 2005 2008 2012 2014 2016

SQL Server 2008 Authentication modes

Before we go into SQL Server 2008 Authentication modes, it is better to have quick look at Active Directory Services. Active Directory (AD) is a directory service created by Microsoft for Windows domain networks. It is included in most Windows Server operating systems. Server computers on which Active Directory is running are called domain controllers.…

Changing the Service Accounts Used by SQL Services

Firstly its good to know the types of startup accounts: Local User Account: This user account is created in your server where SQL Server is installed, this account does not have access to network resources. Local Service Account: This is a builtin windows account that is available for configuring services in windows. This account has…