In this article we look at how to add the zoom feature to your charts and graphs in Power BI reports for a better user experience.
The post Power BI Zoom and Focus appeared first on SQLServerCentral.

Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.
The post Quantifier predicates appeared first on SQLServerCentral.

You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
The post Performance Tuning Using Free Tools, Part 2 appeared first on SQLServerCentral.

Tony Davis describes a typical database development cycle and deployment pipeline supported by Redgate Deploy. It allows branch-based database development, using disposable databases (clones) and version control tools, promotes continuous integration and testing of changes and automates the build and deployment processes so that they are repeatable, fast and reliable.
The post A Database DevOps Workflow Using Redgate Deploy appeared first on SQLServerCentral.

In this article we walk through how you can run Python scripts using SQL Server Agent, so you can setup scheduled jobs to run your Python code.
The post Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment appeared first on SQLServerCentral.

How to auto-generate first-cut undo scripts for every Flyway migration. For every new version of a database created by a Flyway versioned migration, we compare it to a 'source' directory containing object-level build scripts for the previous version. The SQL Compare engine does the rest, producing the associated undo script that will revert the database to the previous version, if required.
The post Automating Flyway Undos appeared first on SQLServerCentral.

This article will get you started with Spawn, a hosted database cloning service running entirely on Amazons AWS.
The post Getting Started with Cloud-hosted Databases using Spawn appeared first on SQLServerCentral.

DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.
The post How to filter DAX for paginated reports appeared first on SQLServerCentral.