MSSQL

  The use of “Auto Increment Identitiy Column” in tables is common. In some cases, we may want to find the last Identitiy value generated. In this article, we will …

  If you want to delete the database, you will get this error if there is an open session on the database. First, set the database to single_user mode. Then …

With the DATALENGTH function, we can calculate the size of the data in a column in bytes. Usually, its useful for calculating the size of lob columns. Let’s make examples …

  With Database Mail, you can get this error when you want to send mail using msdb.dbo.sp_send_dbmail. This is because none of the Database Mail Profiles are set as global …

  With the @@ SPID Function, we can find the session id of the current session. Usually we use when we want to exclude the current session in our queries. …

  Finding the total size of all your databases may be a bit difficult when your number of instances and your database count increases. Sometimes your manager can want to …

Hello there, User management is very important in our database systems. We prefer DBAs to create or use more windows authentication instead of sql authentication. But conditions may not always …

Hello there, A query operation is performed on SQL Server. If the cursor is on the line, the data in that line is processed. DML (insert – update – delete) …

  You can find the name of the SQL Server Instance that you are connected to with the @@ SERVICENAME Function. If the instance you connected to is default instance, …

If you ran a validation report on the windows, a warning might appear. “The RegisterAllProvidersIP property for network name ‘Name: ‘ is set to 1. For the current cluster configuration …