December Blog Post Wrap-up

Replication and Log Shipping Compared

Fri, 30 Dec 2022

Replication and log shipping are two features of SQL Server that are used for managing data and ensuring that it is available in multiple locations. Both of these features can be useful for organizations that need to maintain multiple copie Read more…

SQL Server HAVING clause on SELECT statements

Thu, 29 Dec 2022

The SQL HAVING clause is used in conjunction with the GROUP BY clause to filter the results of a query based on the group by clause. The HAVING clause is used to filter the results of a GROUP BY clause Read more…

SQL Server Recovery Point Objective vs. Recovery Time Objective

Wed, 28 Dec 2022

Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are two important concepts in disaster recovery planning. Recovery Point Objective (RP Read more…

SQL Server Windowing Functions

Tue, 27 Dec 2022

SQL Server windowing functions are a powerful and versatile set of tools that allow you to perform complex calculations and operations on a set of rows within a query. These functions operate on a set of rows, called a window Read more…