Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Synonym is to give alias (an alternative name) to some objects on a database basis. The synonym can be created for following objects. Table View …
Read More »MSSQL
How To Convert Gregorian Date to Hijri Date or Hijri Date to Gregorian Date
A friend ask to me to conversion about gregorian date to hijri date or hijri date to gregorian date. I will explan this conversions in …
Read More »DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS Function in SQL Server(TSQL)
We can get a date by combining the values such as year, month and day with the help of DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS functions. …
Read More »How To Change Owner of Database in SQL Server(ALTER AUTHORIZATION)
When a database owner changes his password, you may receive errors as follows. Therefore, it would make more sense to set the owner of …
Read More »SQL Server Columnstore Index(2012,2014,2016,2017)
ColumnStore Index entered our lives with SQL Server 2012. Normally the index is stored in the disk as row-based, and the index is created …
Read More »DATEDIFF and DATEDIFF_BIG Functions in SQL Server(TSQL)
We can find the difference between the two dates using the following dateparts with the DATEDIFF function. The return data type is int. If …
Read More »Make Sure that Database Mail is running in SQL Server(Failsafe Operator)
Before reading this article, I recommend that you read the articles “How To Configure Database Mail on SQL Server” and “How to Create an …
Read More »DATEADD Function in SQL Server(TSQL)
With the DATEADD function we can add or remove a datepart to a date. Below is a list of the dateparts we can add. …
Read More »SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs)
There was a license-related change in the edition of Enterprise Edition in SQL Server 2012. There are two Enterprise Edition Models. Enterprise Edition with …
Read More »SET DATEFIRST Statement and @@DATEFIRST Function in SQL Server(TSQL)
We can set the first day of the week for a session with SET DATEFIRST Statement. We can query the first day of the …
Read More »