Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Did you know the CHOOSE function in SQL Server? This function introduced with SQL Server 2012. [crayon-6629cf4f6d946214284992/] The CHOOSE command can provide practical use …
Read More »MSSQL
How To Create a Server Side Trace On SQL Server
The most practical way to prepare a Server Side Trace is to use the SQL Server Profiler. First, open Profiler, select the desired Events …
Read More »Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)
ERROR: SQLServer Error: 17750, Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be …
Read More »Could not load package “packet_name” because of error 0xC0014062
ERROR: Could not load package “packet name” because of error 0xC0014062.Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80040E4D (Login failed for …
Read More »The database owner SID recorded in the master database differs from the database owner SID recorded in database
ERROR: The database owner SID recorded in the master database differs from the database owner SID recorded in database ‘database_name’. You should correct this …
Read More »Re-creation of SQL Server Performance Counter
After some SQL Server installations, the SQL Server Performance Counter on the server is not created at all, and we notice later, or because …
Read More »What is the Active Node of SQL Server Failover Cluster?
In SQL Server 2005 and later versions, you can find the active node of SQL Server Failover Cluster using the following query. [crayon-6629cf4f6e409636596909/]
Read More »When was the password for SQL Login changed?
What do you do if you need to know when the password of a SQL Login is changed? You can use the command below …
Read More »Internal I/O request 0x4BD9EAE8: Op: Write, pBuffer: 0x05350000, Size: 983040, Position: 369629696, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x16081A00, OffsetHigh: 0x0, m_buf: 0x05350000, m_len: 983040, m_actualBytes: 0, m_errcode: 112, BackupFile:
ERROR: “Internal I/O request 0x4BD9EAE8: Op: Write, pBuffer: 0x05350000, Size: 983040, Position: 369629696, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x16081A00, OffsetHigh: 0x0, m_buf: 0x05350000, …
Read More »Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission.
ERROR: “Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do …
Read More »