MSSQL

Always Encrypted is a security solution that introduced with SQL Server 2016. With this solution, application developers can encrypt the columns from the client side. …

You should receive this error when you use “Execute as ower” in your script or in your jobs. I received this error when I want …

The Natively Compiled Stored Procedure is a new type of stored procedure offered by SQL Server 2014 with In Memory OLTP. Available in Memory Optimized …

In this article, we will explain what is In Memory OLTP and how to use this feature in SQL Server 2014 and what is limitations. …

In this article, we’ll examine the Distributed Partitioned Views, which we can combine data from tables on multiple instances with UNION ALL. If you combine …

As you know, partition is the division of large tables into small tables. For more information about Partition, please read the article “How To Create …

You can receive this error when you want to get a total result by using the SUM function. In order to avoid this error, you …

You may receive this error when you want to chage an instance level parameter by using sp_configure in SQL Server. I would recommend reading the …

                  Security is the biggest concern nowadays particularly for those who manage critical applications.Every database must have …

In this article, I will describe a few of the most known types and solutions of this error. Possible Errors Transaction Log is Full Due …