Press "Enter" to skip to content

Day: January 25, 2023

Tools for the DBA Jumpbox

Tracy Boggiano has a script:

I wrote a blog post a few months ago about the tools I use on my jumpbox you can read here.  Since then, I have automated most of the install with Chocately and so I’ll have the script later I’m going to blog it here.  First, we need to install Chocately on the jumpbox by opening PowerShell as the adminstrator.

Read on to see how to do that, the installation of a slew of tools via Chocolatey, and then several Powershell modules.

Comments closed

PostgreSQL Sans Superuser in v16

Robert Haas doesn’t wear a cape:

As I’ve written about before, a PostgreSQL superuser always has the ability to take over the operating system account in which PostgreSQL is running, but sometimes you’d like to have a role that can administer the database but not break out of it. In existing releases, there’s no good way to accomplish that. You can either make a new role so weak that it can’t perform ordinary administration tasks, or you can make it so strong that it can easily break into the operating system account and thus take over the superuser role as well. Unless you hack the source code, which some people have done, there’s no real way to set up an account that has enough power to usefully administer the database in meaningful ways but yet not enough power to take over everything. I’ve committed a number of patches to v16 to try to improve the situation, and I think that we can look forward to big improvements in this area once it is released.

Read on for some of the implications of this change.

Comments closed

Dashboard Sharing in Power BI

Reza Rad takes us through one form of data sharing in Power BI:

Power BI provides multiple ways of sharing content with users. Each sharing method has pros and cons and can be used for specific scenarios. Some sharing methods can be used together to build a framework for sharing. This article and video discuss the most basic way to share Power BI content. This method is called Dashboard (or Report) Sharing. Dashboard sharing is the easiest way of sharing; however, it may not always be the best way. In this article and video, you’ll learn how this method works, you will learn about the pros and cons of this method, and the scenarios of using it.

Click through for a video and article.

Comments closed

Unpivoting a Multi-Field Matrix in Power BI

Meagan Longoria gets out of a tricky situation:

I had to do this for a client the other day, and I realized I hadn’t blogged about it. Let’s say you need to include data in a Power BI model, but the only source of the data is a matrix that is output from another system. And that matrix has multiple fields populating the columns. An example of this is below. The matrix has fiscal year and product category on columns, vertical on rows, and the profit metric populating the values.

Read on for a step-by-step guide on how to do this.

Comments closed

A Free Training Offer for the Recently Laid Off

Andy Leonard has an offer for free training:

My LinkedIn and social media feeds are filled with contacts and friends sharing their availability for a new career opportunity. While some are more gracious than concerned and others more concerned than gracious, it’s normal to be both concerned and gracious. Well, it was normal for me when it happened to me. If you haven’t been laid off before, I hope you never learn what that feels like.

If you have been laid off already, or if you’ve been notified you are about to be laid off, I encourage you to see this as the beginning on your Next Opportunity.

Click through for the details on this generous offer.

Comments closed