Get the first record added per day group by the user in SQL

In the previous post Get the last record added per day group by the user in SQL I explained How to get the last entry for each user per day.

In this post, I am gonna to explain

How to get the first record added per day for each user in SQL.

Get the first entry added per day for each user in SQL

Consider you have a [Transaction] table to save multiple transactions for different users daily!

Continue reading Get the first record added per day group by the user in SQL

Get the last record added per day group by the user in SQL

In this post, I am gonna explain

SQL Query

How to get the last record added per day for each user in SQL.

Get the last entry added per day group by the user in SQL

Consider you have a [Transaction] table to store multiple transactions for different users daily!

Continue reading Get the last record added per day group by the user in SQL

Windows Server 2016: Switch from Server Core to Desktop Experience

I tried to install Windows Server 2016, I got the dialog that ask me to select the operating system that I would like to install as shown below:

Windows Server 2016 without desktop experience

You may be also interested to check Windows Server 2016: Expand Virtual Machine Hard Disk & Extend the Operating System Drive.

Actually, I have confused which option should I use

  • Windows Server 2016 Standard or,
  • Windows Server 2016 Standard (Desktop Experience).
Continue reading Windows Server 2016: Switch from Server Core to Desktop Experience