Replication and Log Shipping Compared
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.… Read More »Replication and Log Shipping Compared
SQL Server HAVING clause on SELECT statements
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… Read More »SQL Server HAVING clause on SELECT statements
SQL Server Recovery Point Objective vs. Recovery Time Objective
Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are two important concepts in disaster recovery planning. Recovery Point Objective (RPO)…… is the maximum amount… Read More »SQL Server Recovery Point Objective vs. Recovery Time Objective
SQL Server Windowing Functions
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… Read More »SQL Server Windowing Functions
SQL Server Log Backups
In SQL Server, log backups are copies of the transaction log that can be used to restore the database to a specific point in time.… Read More »SQL Server Log Backups
Merry Christmas
Merry Christmas from the team at Stedman Solutions, LLC. Our offices will be closed to celebrate Christmas this year. If you need emergency help during… Read More »Merry Christmas
Christmas Queries
Here is a sample Christmas-themed query for SQL Server: This query returns the greeting “Merry Christmas!” and the current date. It only selects user tables… Read More »Christmas Queries
Merry Christmas! 2022-12-25 00:00:00.000
Merry Christmas! 2022-12-25 00:00:00.000 This output shows that the query is only returning user tables with an even object ID and the date is December… Read More »Merry Christmas! 2022-12-25 00:00:00.000
Min and Max Aggregate Functions in TSQL
Here is a sample query using the MIN and MAX functions in T-SQL: This query selects the minimum and maximum values for the Price column… Read More »Min and Max Aggregate Functions in TSQL
Do Not Email Passwords
It’s never a good idea to email passwords, whether it’s your own personal password or a password that you’re sharing with someone else. Here are… Read More »Do Not Email Passwords