A Fine Slice Of SQL Server
Tomaz Kastrun takes out the trash:
Sample Powershell script for deleting datasets in all workspaces. These datasets are visible in Admin console under Datasets for every workspace.
Click through to see which Powershell module you’ll need, as well as to get a helpful script.
Comments closedJeffrey Hicks has a new module:
I spend my working days living in a PowerShell console. Over the years, I’ve developed many PowerShell modules to help me manage the chaos that is my work life. One area that always demands attention is managing my tasks and To-Dos. For several years I have been using the MyTasks module. This module stored tasks and supporting information in a set of XML files. The code in the module treated the XML files as databases. I was trying to avoid a dependency on a SQL Server Express installation with the idea that would be overkill.
ln the meantime, I finally got around to finishing and publishing the MySQLite PowerShell module. This module has a set of PowerShell functions designed to simplify working with SQLite database files. This type of database has a much smaller footprint than SQL Server Express and would streamline my task management.
Click through to see how it works.
Comments closedChad Callihan works with some data in MySQL:
I recently went through an example of making SQL Server changes with PowerShell. To continue on a PowerShell trend, let’s take a look at inserting and exporting MySQL values with PowerShell.
Read on to see how to insert data as well as reading data into a CSV.
Comments closedTracy Boggiano kicks off a notebook:
As part of starting a new job you need a way to get a good inventory of basic information of SQL Server instances. Once you have done what I outlined in this blog post. I find it helpful to run Glenn Alan Berry’s Diagnostic Notebooks against all the instances to get a static point in time snapshot of all the properties and some performance information. While dbatools has commands under the Community Tools section for running the data into spreadsheets and creating notebooks for the newest queries I like to go get Glenn’s because he has all the comments in there of what the mean and links to resources about things. So you can explore that route if you like but I’ll be manually downloading them from Glenn’s site for that reason. To able to open the notebooks successfully in ADS look for the tip on my blog post on Tools I Use on My Jumpbox for opening large notebooks.
Click through for a script Tracy uses to kick off the notebook regardless of the SQL Server version.
Comments closedKenneth Fisher needs someplace to put all of his great ideas:
Last week I posted about a request to get a list of services. The first problem I ran into was expanding the column width, now I need to get the output off my screen and into a file to send the requestor. The cmdlet out-file is perfect for this and it’s pretty simple.
Click through to see how the Out-File cmdlet works as well as another cmdlet you may wish to use instead.
Jeffrey Hicks explains the value of working with objects in Powershell:
I expect I will write several articles about PowerShell and its relationship with objects. I know that this is the biggest hurdle for PowerShell beginners to overcome. But once they grasp that PowerShell is about working with objects in the pipeline, they recognize the value and begin finding it easier to write PowerShell code and use it interactively at a console prompt.
Read the whole thing and if you like what you see, there’s also a Substack where you can sign up for free or subscribe for additional content.
Comments closedJon Fletcher doesn’t have time to upload reports one by one with the UI:
In this blog post, I will be sharing a PowerShell script that allows multiple Power BI reports to be uploaded at once. In a previous blogpost, I shared a PowerShell script that allowed users to downloaded multiple Power BI reports. Combined you could move several reports from one workspace to another in a few seconds.
The script is downloadable at the bottom of the page as a txt file. To use the script there are three steps to take.
Click through to see how it all works.
Comments closedKenneth Fisher supersizes the screen:
Notice the ellipsis (the three dots). That’s showing us that the name was too long and ended up being truncated. Given that I’ve been doing this for a little while now I’m almost completely certain that if I send this as it is the users are going to want to know full names. And with my luck I’ll end up having to give them each truncated string individually. On the theory that if I have time to do it twice I probably have time to do it right the first time, let’s figure out how to expand the columns. Fortunately, as with most things Powershell, there’s a cmdlet for that.
Read on to see what the process looks like.
Comments closedStephanie Bruno fixes a credentials issue:
Have you ever had a Usage Metrics Report just stop refreshing? At the bottom you’ll see a little message that tells you to check the credentials. But you don’t have access to the Usage Metrics Report dataset in the list of datasets in the workspace because it’s hidden! So even if you wanted to delete it and nicely ask it to start again, you can’t do it from the workspace. What can you do? Well, you can delete the Usage Metrics Report dataset with the Power BI Rest API.
Read on to see how.
Comments closedPatrick Gruenauer does a bit of debugging:
The Set-PSBreakPoint cmdlet sets a breakpoint in a script. When you are troubleshooting a script it could be helpful to know what’s going on in a particualar step or workflow. In this blog bost I will give you an overview and the basics you can build on to troubleshoot and investigate your script. Let’s jump in.
One of these years, I’m finally going to learn command-line debugging. I grew up in the IDE era and so never took the time to learn that skill.
Comments closed