Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We find the minimum value in a column in a dataset, with the MIN Function and we find the maximum value in a column …
Read More »MSSQL
Validate Windows Cluster Configuration
In this article I will show you how to validate windows cluster configuration step by step with screen shots. You can perform validate configuration to …
Read More »COUNT_BIG Function in SQL Server(TSQL)
The COUNT_BIG function performs the same function as the COUNT function. The only difference is that the COUNT_BIG function returns the BIGINT value while …
Read More »Set a Database To Read Only Mode, Take Database Offline or Detach a Database
Sometimes we need to move the database from one instance to another instance. But we don’t dare to erase our old database right away. …
Read More »COUNT Function in SQL Server(TSQL)
We find the number of records in a data set with the Count function. For example, we can find the number of records in …
Read More »What is DeadLock in SQL Server
What is DeadLock? Although it is like a movie star, it causes serious problems in applications. If we want to briefly summarize DeadLock, two or …
Read More »How To Capture DeadLocks With Extended Events
Application developers sometimes receive a deadlock error and cannot see which queries are deadlocked. That’s why they demand this information from you. We can capture …
Read More »the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine
You may receive this error when you want to import data from a file such as Excel to the sql server. You must install …
Read More »GROUPING and GROUPING_ID Functions in SQL Server(TSQL)
We can create subtotal and grandtotal rows for the grouped data with WITH ROLLUP, WITH CUBE and GROUPING SETS operators. You can find details …
Read More »WITH ROLLUP and WITH CUBE Operators in SQL Server(TSQL)
We use the WITH ROLLUP and WITH CUBE operators with the GROUP BY statement. So before you read this article, I suggest you read the …
Read More »