Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  How do you find out if a specific record in a particular table is in the Buffer pool / data cache or in the …

  Did you know the CHOOSE function in SQL Server? This function introduced with SQL Server 2012. [crayon-67683491992f8164507773/] The CHOOSE command can provide practical use …

  With the collaboration of Hortonworks, Microsoft has made Hadoop framework work with Windows Servers and Windows Azure, and they called it HDInsight. For those …

  The most practical way to prepare a Server Side Trace is to use the SQL Server Profiler. First, open Profiler, select the desired Events …

  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 …

  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 …

  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 …

  After some SQL Server installations, the SQL Server Performance Counter on the server is not created at all, and we notice later, or because …

  In SQL Server 2005 and later versions, you can find the active node of SQL Server Failover Cluster using the following query. [crayon-67683491997d7091681442/]

  What do you do if you need to know when the password of a SQL Login is changed? You can use the command below …