A Fine Slice Of SQL Server
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 closedRobert 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 closedReza 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 closedKevin Chant has some links for us:
Last week the January 2023 video of the Azure Synapse Analytics and Microsoft MVP series was released. Where I covered how to do CI/CD for dedicated SQL Pools in Azure Synapse Analytics.
Since the release of that video the most popular question raised has been how to perform CI/CD for serverless SQL Pools within Azure Synapse Analytics?
Read on for links galore.
Comments closedMeagan 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 closedAndy 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