Tag: server

How to setup a Linux server on Amazon AWS

How to setup a Linux server on Amazon AWS AWS (Amazon Web Services) is one of the leading cloud server providers worldwide. You can setup a server within a minute using the AWS platform. On AWS, you can fine tune many techncal details of your server …

SET CONCAT_NULL_YIELDS_NULL in SQL Server

  How often do we think of NULL values while concatenating NULLs with string values? String concentration with NULL values can give us some unexpected results if we are not aware of CONCAT_NULL_YIELDS_NULL database SET options. CONCAT_NULL_YIELDS_NULL options control whether concatenation results shall be treated as …

Logical Query Processing in SQL Server

  To learn the basics of SQL Server, you must have an understanding of how an SQL Server query engine executes an SQL query. T-SQL involves both logical and physical query processing. Physical query processing is about how a database engine processes a query. Logical query …

Windows Server 2016: DFS-R vs. Storage Replica

  In today’s Ask the Admin, I’ll look at the key differences between Distributed File System Replication (DFS-R) and Storage Replica (SR), and why you might want to upgrade to Storage Replica if you’re using DFS for server-to-server replication. Storage Replica is a new feature in …

Auditing Improvements in Windows Server 2016

  In today’s Ask the Admin, I’ll look at two new audit events in Windows Server 2016 that can help identify malicious activity, as well as other general auditing improvements. Windows 10 included some improvements to auditing and new events. Those changes are naturally now available …