In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.
The post Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security appeared first on SQLServerCentral.

Introduction The sp_HorizontalTree procedure introduced here may be used to audit tables with dependent columns. A column is dependent on another if the meaning of the first column depends on the meaning of the second. For example, in a table containing accounting information, the meaning of a Fiscal Quarter column depends on the Fiscal Year to […]
The post Horizontal Trees appeared first on SQLServerCentral.

Learn how to use the Plotly library to visualize time series data in Python in this step-by-step article.
The post How to Visualize Timeseries Data with the Plotly Python Library appeared first on SQLServerCentral.

This article describes a simple technique that will allow you to use Flyway securely, even in cases where more than just the login credentials need to be protected. It uses a PowerShell technique that converts an encrypted Flyway configuration file into an array of parameters that Flyway can read just as if you were typing them in.
The post Using Windows Security and Encryption with Flyway appeared first on SQLServerCentral.

Ordinary PostgreSQL users often do not know that PostgreSQL configuration parameters exist, let alone what they are and what they mean. Some parameter tuning can improve the database performance, and we are usually talking about 10%, 20%, and in rare cases, up to 50% performance improvement.
The post Are PostgreSQL memory parameters magic? appeared first on SQLServerCentral.

This article looks at calculating prime numbers less than n with one query.
The post Calculating Prime Numbers With One Query appeared first on SQLServerCentral.

Learn about the Kimball method for data warehouses and how you can get started building one.
The post Building a Kimball Data Warehouse appeared first on SQLServerCentral.

If you are using SSDT for authoring, building, debugging, and publishing a database project, how do you change to, or preferably migrate towards, a Flyway-based database development? Flyway doesn't need to replace any code part of SSDT, but if allowed to manage every release candidate, it does allow for much cleaner branching, merging, and deployments.
The post Flyway for SQL Server Data Tools Users appeared first on SQLServerCentral.