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.
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.
Learn how you can adjust the way users interact with reports and change font sizes as well as add parameters for filtering.
Steve wasn't happy with the tech support advice of rebooting a computer. He feels better now.
During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and provides and example.
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.
Learn about how you can monitor your Azure Storage account and set alerts to let you know when to take action.
In this article we cover different ways to convert a SQL Server numeric value into a string value.
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Comments posted to this topic are about the item BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers