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…
SQL Server Log Backups
Mon, 26 Dec 2022
Merry Christmas
Sun, 25 Dec 2022
Christmas Queries
Sat, 24 Dec 2022
Merry Christmas! 2022-12-25 00:00:00.000
Fri, 23 Dec 2022
Min and Max Aggregate Functions in TSQL
Thu, 22 Dec 2022
Do Not Email Passwords
Wed, 21 Dec 2022
New Course – Preparing for Corruption in SQL Server
Tue, 20 Dec 2022
Common Waits Reported by Daily Monitoring This Month
Mon, 19 Dec 2022