What is the best way to use an office? Or is there even a best way? Steve asks the question today.

[From the archives] Your guide to choosing the right monitoring tool [Video]

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

Join Grant Fritchey in this 35 minute video to learn his top tips for evaluating monitoring tools and vendors, the common pitfalls when implementing a new solution, and how you can demonstrate Return on Investment (ROI) to the business post-purchase.

SQL Server 2022: Backup Database Options to AWS S3 Bucket - Part 2

by Additional Articles

MSSQLTips.com

SQL Server

In this article we look at how to backup a SQL Server 2022 database using AWS S3 storage along with all the supported backup options.

Finding a New Job

by Steve Jones

SQLServerCentral

Career Growth

Steve has a few thoughts on finding a new job and what might help you.

How to Find the Start and End Dates for the Current Week (and more)

by Jeff Moden

SQLServerCentral

Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)

Cross-RDBMS Version Checks in Flyway

by Additional Articles

Redgate

Vendors/3rd-party Products

How does one check that a database is definitively at the version that Flyway says it is? Or that a test teardown procedure leaves no trace in the database? Or verify that an undo script returns a database's metadata to that state it should be in for the version to which you're rolling back? This article shows how to do high-level version checks, by comparing JSON models.