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.

SQL Server 2022: Backup and Restore database to AWS S3 bucket - Part 1

by Additional Articles

MSSQLTips.com

SQL Server

In this article we look at how to configure AWS to allow backup and restore from a SQL Server 2022 database using AWS S3 storage.

Power BI Report Builder Parameters Tutorial

by Daniel Calbimonte

SQLServerCentral

Learn how you can adjust the way users interact with reports and change font sizes as well as add parameters for filtering.

Rebooting for a Reason

by Steve Jones

SQLServerCentral

computer theory

Steve wasn't happy with the tech support advice of rebooting a computer. He feels better now.

Datamarts and exploratory analysis using Power BI

by Additional Articles

SimpleTalk

During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and provides and example.

DevOps 101: Unlock the value of frequent deployments with Database DevOps

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

Frequent deployments can give you greater flexibility in meeting changing business requirements, but if code quality is poor this may cause major headaches for your customers and your whole organization. Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover the benefits of, and best practices for frequent deployments.