Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In the article named “FileGroup Backup and FileGroup Restore Operations On SQL Server(Partial Backup-Restore)“, I explained the issue that we can restore only read-write …
Read More »Find the logical and physical database source that is experiencing IO problem
Interesting title, right? We may want to see the processes that are currently running, especially when there are problems. In these cases you can …
Read More »How do you know that a record is in Data Cache On SQL Server
How do you find out if a specific record in a particular table is in the Buffer pool / data cache or in the …
Read More »CHOOSE Function On SQL Server
Did you know the CHOOSE function in SQL Server? This function introduced with SQL Server 2012. [crayon-673f6fc803fa8243516149/] The CHOOSE command can provide practical use …
Read More »HDInsight
With the collaboration of Hortonworks, Microsoft has made Hadoop framework work with Windows Servers and Windows Azure, and they called it HDInsight. For those …
Read More »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 »