MSSQL

Due to the principle of “minimum authority for maximum security”, we should regularly check which user is authorized on the sql server, and revoke the …

To send mail through the SQL Server, you must first configure Database Mail. You can find details in the article “How To Configure Database Mail …

SQL Server Logs and Operating System Logs(Event Logs) are logs that SQL Server Database Administrators checks on a daily basis, or use to find the …

Sometimes we need to list table sizes in SQL Server. For example, we need to find large tables before we start making Compression or before …

We can compress some tables to reduce the size of the table. I / O performance increases as data size decreases. It also increases CPU …

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 …