Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways.
For this article, I'm going to demonstrate some of the popular ways of importing JSON data into MS SQL Server.
With the introduction of AlwaysOn Availability Group (AAG) in SQL Server 2012, log shipping seems to be less widely used than before. AlwaysOn Availability Group provides real-time log shipping as transactions are committed/applied to the primary da…