Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In some cases, SSMS (SQL Server Management Studio) is not installed on the server and you may need to connect to SQL Server from the …
Read More »MSSQL
Like Operator in SQL Server(TSQL)
We use the LIKE operator with WHERE clause. I suggest you read the following article about WHERE clause. “Where Clause in SQL Server and SQL …
Read More »How To List Availability Group Names, Database Names, IPs, Ports, DNS Names in SQL Server
If you are using SQL Server Availability Group and you have multiple availability groups and instances; if you want to list Availability Group Names, Database Names, …
Read More »How To Encrypt SQL Server Stored Procedures, Views and Functions
Stored procedures, functions, and views are objects that each application uses at the database tier. In some cases, it may be necessary to encrypt …
Read More »HAVING Clause in SQL Server and Difference Between WHERE Clause(TSQL)
HAVING Clause is used for filtering like WHERE Clause. The difference is that while WHERE Clause is filtering on ungrouped data, HAVING Clause filters on …
Read More »How To Change Default Paths of the Data and Log Files
I explained in detail how to create a database in the article “How to Create a Database on SQL Server“. If you do not …
Read More »SEQUENCE in SQL Server(TSQL)
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 …
Read More »The certificate ‘xxx’ cannot be dropped because it is bound to one or more database encryption key(Deleting a Certificate)
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, …
Read More »How To Concatenate Query Results in SQL Server(TSQL)
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. …
Read More »How To Delete the Last Character of a String in TSQL(DATALENGTH and LEFT Functions)
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 …
Read More »