MSSQL

User Defined Function is a feature of SQL Server that takes parameters like a programming language functions and returns a result or result set. With …

Before you read this article, I recommend that you read the article “What is Data-Tier Application” to avoid confusion. In the article I mentioned above, …

Data-Tier Application Version 1.1 (DAC) was introduced with SQL Server 2008 R2. With Data-Tier Application, we are able to transfer the databases of our applications …

IntelliSense was introduced with SQL Server 2008. With this feature, we can now write TSQL Code in a more practical way. So where can we …

Since SQL Server 2008, we can debug our TSQL queries as in Visual Studio. In this way, we can see which variable gets what value …

Each database administrator wants to detect and delete unused logins. By default in SQL Server, the last time the login was logged is not stored …

Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

During the 12c database creation process , you can see ORA-20001 error in the alert log file when the “SYS.ORA $ AT_OS_OPT_SY_ <NN>” auto job …

Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

Policy-Based Management is a feature that is introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …