A Fine Slice Of SQL Server
Jon Fletcher needs to get some PBIX files:
In this blog post I will be sharing a PowerShell script that allows multiple Power BI reports to be downloaded at once.
In the Power BI service, there is no way of downloading multiple Power BI reports at once. Therefore, users must download files one by one which is slow, time consuming and inefficient. Thankfully, there are ways around this, one of which is using PowerShell.
Read on for the script and some additional notes.
Comments closedJeffrey Hicks does some marketing:
It is easy to search the PowerShell Gallery online and from a PowerShell prompt. But I felt there could be more. To address this “marketing” need, I’ve started PSGallery Report.
This is not a PowerShell module. I have set up a process to generate daily reports on what has recently been published in the PowerShell Gallery. I’m generating a set of reports in markdown and posting them to Github.
This is an interesting idea, though you might need to browse to yesterday’s version of the code (if you’re reading this today, 2022-04-11) because the latest run appears to have removed everything.
Comments closedIn researching some things for a presentation, I was to give at Intersections, Spring 2022, I came across this documentation page for SQL Server PowerShell that in the SQL Server Agent section it indicates that there is a way to get the Agent Job Step to skip loading the SQLPS module and you get to use PowerShell natively and can load whichever modules you would like.
What? Huge News!
That is good news. SQLPS is so outdated it’s not even funny, so this gives you a much better alternative.
Comments closedRobert Cain has a bunch of posts:
Since September 2020 I’ve been posting extensively about PowerShell in a series I’ve titled Fun With PowerShell. In my next post I will begin a series on a new topic, but before I do I wanted to leave with a Fun With PowerShell Roundup” post.
Below you will find a listing of all posts in my Fun With PowerShell series. Note there are other posts I’ve done in this time frame, but since they did not focus on PowerShell I’ve omitted them from this listing.
Click through for a lengthy and good series.
Comments closedChad Baldwin doesn’t need no fancy GUIs:
Let’s talk about how to make something that’s already super exciting, even more fun, by using PowerShell. Why bother with fancy GUI’s and polished tools when you can do it the fun way?
Yes, there’s lots of good options now when it comes to logging, like structured logs, AWS CloudWatch, Azure Monitor, ELK, etc. Tools that give you a lot of power when it comes to filtering, alerts, and monitoring. However, I still often find myself digging through good ol’
*.logfiles on a server.
Read on for some good information about how to analyze a log file using nothing more than Powershell.
Comments closedEitan Blumin dives into Powershell:
As part of my journey to get better at Powershell, I gave myself a task: Create a project utilizing Powershell at its core, to solve a complicated problem as elegantly as possible.
A complicated problem indeed presented itself: How to remotely control multiple computers without having to log into them? Make them perform any task that could possibly be needed? Control them from one central location? And make the solution as easily scalable as possible?
Read on to see what Eitan has learned and applied.
Comments closedEric Rouach replaces SQL Agent:
For future use in our PowerShell script and since we do not want our Server’s credentials to appear in clear text, our next step will the creation of a credential within the Automation account. This will hold the credentials (username and password) that we’d use for connecting to our SQL Server target.
Click through to learn more.
Comments closedI was recently working on a client server and need to install the Az PowerShell module. I opened and administrator window and typed
Install-Module Azand received this error:
WARNING: Unable to find module repositories.
Turns out that was not the real answer. Click through to see what Frank ended up needing to do.
Comments closedJeffery Hicks wants to check Git status:
I write a lot of PowerShell modules. And probably like you, I am working on more than one project at a time. I was finding it difficult to keep track of what I was working on and what I might be neglecting. So I turned to PowerShell and created a tool that I use to keep on top of my projects. The PowerShell module is called PSProjectStatus and you can install it from the PowerShell Gallery. You can find the project on GitHub, but I thought I’d provide an introduction here.
Read on to see how it works.
Comments closedJeffery Hicks translates security identifiers:
As usually happens during my day, I get sidetracked to another issue, and before you know it, I have a new PowerShell tool. In this instance, I was looking at event logs using Get-WinEvent. One of the event record properties is a UserID.
That’s very nice, but who is this? In this particular instance, the UserID property is SecurityIdentifier object.
Read on to see how to translate a SecurityIdentifier into something human-understandable.
Comments closed