MSSQL

  I explained in detail how to create a database in the article “How to Create a Database on SQL Server“. If you do not …

  Sequence is a table-independent structure similar to the identity logic in SQL Server. You can use the sequence in more than one table. You …

  You may need to delete the certificate that you created with TDE(Transparent Data Encryption) during the database encryption process. And during this deletion process, …

The other day I had to concatenate a query result. In this article, I’m going to tell you how to do this through an example. …

When developing code in TSQL, we may need to delete the last character of a string in some cases. The other day, I used the …

We can use the SQL INTERSECT Operator between two SQL Statement. This operator returns the intersection of the first SQL Statement and the second SQL …

  When there is an error in the database, the first place to look at is SQL Server Error Log. Sometimes there is no problem …

We can use the SQL EXCEPT Operator between two SQL Statement. It allows us to return records that exist in the first SQL Statement, but …

Hello there, In-Memory concept, which was first introduced into our lives with SQL 2014, was made more useful and compatible with SQL 2017. In this …

  In order to restore the backup of a database encrypted with TDE (Transparent Data Encryption) to another instance, we need to transfer the certificate …