[Notes from Pinal]: If we get one server, we want two servers, and if we get two servers, we want four servers. If we know we are going to get only two servers, we try our best to get maximum out of our available server. Maximum utilization of resources is always our primary goal. In this blog post we are going to talk about almost the same story where we try to get maximum out of our servers. Let us assume that we have two servers, how do we get maximum performance from them. Well, our generic answer would be that we will keep the most important task on our primary server and move all the not so important task on secondary server. This is common sense and essential too. This is when I reached out to Eduardo and asked him what can we do to make our primary server faster by offloading backups to secondary replica.
SQL SERVER 2016 – New T-SQL Functions – COMPRESS – DECOMPRESS
With every release of SQL Server, Microsoft has been adding enhancements to the product. Earlier I have written below blogs talking about new features/enhancements. Now I will write about features for SQL Server 2016 which are COMPRESS – DECOMPRESS.
SQL SERVER – The Best Time to Buy – Devart Christmas Price Fall
Have you missed out the deals you were hoping to grab on Black Friday or Cyber Monday? Good news! You still have time to save. 16 December 2015 — 16 January 2016 is your next big window of opportunity for many software products from Devart.
Interview Question of the Week #050 – Query to Retrieve Second Highest Salary of Employee
MySQL – Date and Time Related System Functions
SQL SERVER – Recompiling InMemory OLTP with SQL Server 2016
SQL SERVER – How to Create a Readable Secondary Server in SQL Server Standard – Notes from the Field #107
[Notes from Pinal]: The basic nature of human is greedy. When we get one thing which we desire the next thing. In the early world of SQL Server we got a secondary server as a backup or high availability. In earlier times the secondary server was not readable, it just served as a backup. At this point of time our human nature kicked in and we want to get more from the server, which was just sitting there most of the time. We wanted to make our secondary server readable. This is when I reached out to Kenneth and asked him what can we do to make our secondary server as a readable.





