How to include SSRS and SSIS in devops deployments

Does anyone have any experience of deploying only changed SSRS reports and SSIS packages when they deploy?

We have around 150 reports to deploy to a similar number of servers across dev, uat and production.

We use TFS to do the building of the database objects, reports and packages and a Powershell deployment script to deploy the reports and packages. We always deploy all the reports and packages even if none of them have changed.

I should mention we use a Powershell script for the deployment because we create a new SSRS folder for each customer, upload all of the reports, apply the datasources and subscriptions from the existing folder then rename the new folder and the old folder to switch them over.

I’ve watched lots of talks about database devops but none mention reports or packages.

While we have different upgrade cycles for different customers (some get a release every month, some every two months, some less frequently) we only need to support going from their current version to the latest version – the question is, how can we determine what their current version is?

We’ve considered putting a build number in the rdl and dtsx as a variable then comparing it with the build number being released and if they’re not the same deploying the item.

If anyone is doing this I’d be interested in any pointers you could give, whether it’s scripts or tools.

Go to Source
Author: get-username

RDS Monitoring using PMM2, Missing Host Metrics for Postgres

I am using PMM2 for monitoring all my RDS instances.

I added Postgres as a remote database, But by adding a database as remote in PMM2 we miss host-level metrics like CPU, Memory etc. What is the recommended way of adding Postgres (RDS) or a way to inject missing metrics to get the complete Node Summary?

Go to Source
Author: xrage

How Do I See the List of Users Allowed on a MS SQL Server Database

I want to know the users that are allowed access to a MS SQL Server database. I only want a specific database. Is there a user list hidden somewhere?

What are the ways to go about doing this? Is there an app or through a SQL query?

ANSWER

Use Microsoft SQL Server Management Studio. That is the fastest way to do it. Find the database from the explorer menu on the left-hand side. Expand the folder icon. Go to the Security folder, then click on Users next. That’s it!

If you’re using a different SQL client and you can’t see Security > Users from the GUI. Then your other option is through a SQL query.

This is the query below. More details at this page here: https://www.joseyamut.xyz/2020/08/06/get-user-list-in-a-microsoft-sql-server-database/.

USE <database_name>;
SELECT name AS username,
       type_desc AS type,
       authentication_type_desc AS auth_type
FROM sys.database_principals
ORDER BY type;

Happy user hunting! =)

Does Snowflake Data Sharing add any real security?

Snowflake is a cloud database like Google BigQuery or Amazon Redshift. Unlike them, however, it markets a “Secure Data Sharing” feature.

They go to some effort (including a full “Data Sharing for Dummies” book) to position this as something unique. In terms of clearly defining who has access to what in a user-friendly way, maybe they are correct.

But does this add any extra security above simply sharing a BigQuery dataset or creating a read-only Redshift user?

Go to Source
Author: Seamus Abshere