MSSQL

With SQL Server 2014, we are able to back up a database to a URL via SSMS. In fact, this feature came with SQL Server …

If you do not want to send the entire query result to the client, you can use OFFSET and FETCH in SQL Server to specify …

In this article I will describe SQL Server Architecture. In the article, I will proceed through the following image that I received from wikipedia. And …

ACID is the four main rules that relational database management systems (RDBMS) must provide. For more detailed information about relational databases and SQL Server, you …

We can easily perform point-in-time recovery with Database Recovery Advisor. For example, we have a Full backup that has taken at 14:00 PM and we …

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 …