A Fine Slice Of SQL Server
My code was full of backticks. You could say I was daft about backticks. I loved them and thought they made my PowerShell code readable because they stopped the lines from running off the monitor. Someone asked me why I don’t use PowerShell splatting? “Whatting” I asked? I had never heard of splatting.
Click through to learn more.
Comments closedMark Lelijveld has updated a script for us:
Over a year ago, I wrote a blog about moving dataflows across workspaces using a PowerShell script. Especially useful if you want to move dataflow logic from your development to test, acceptance or production workspace.
I received a bunch of feedback on this script and run into some issues myself as well lately. It was about time for an update of the script! Below I share the issues that are addressed in this new version and what new additions are added to the script.
Click through for details on the update.
Comments closedAndy Levy makes an announcement:
Chrissy LeMaire (blog | twitter) pinged me earlier this week to tell me about Github Discussions. It’s a new feature of Github which is similar to Stack Exchange, but much more focused – it’s just for your project/repository! Get help, start discussions, share tips & tricks.
Give it a once-over and spread the word.
Comments closedJess Pomfret takes us through running dbachecks on an Azure SQL Database:
Last week I gave a presentation at Data South West on dbachecks and dbatools. One of the questions I got was whether you could run dbachecks against Azure SQL Databases, to which I had no idea. I always try to be prepared for potential questions that might come up, but I had only been thinking about on-premises environments and hadn’t even considered the cloud. The benefit is this gives me a great topic for a blog post.
Click through for the answer.
Comments closedJeffrey Hicks shows us how to keep track of lost time:
Here’s the “issue” that often arises. Someone will mention that PowerShell, and this includes PowerShell Core, takes too long to load. In fact, PowerShell now shows you how long it took to load. Almost always, the issue is something profile related. Sometimes a command is taking too long to run, or maybe the profile needs a little cleanup. I know my PS7 load times were high until I cleaned up a few items and re-structured some of the commands.
To make this easier, I put together a simple script that you can run in Windows PowerShell, or PowerShell (even cross-platform) that will run your profile scripts and report how long they take to complete.
Click through for more details, as well as a script to test how quickly your Powershell profiles load.
Comments closedGarry Bargsley shows how easy it is to save a transcript in Powershell:
This week we are going to launch a blog series geared towards folks that are new to PowerShell. The growing popularity of automation is seeing people getting started with the PowerShell scripting language.
The Start-Transcript is a built-in command that allows you to quickly build a log of actions being taken by your script. There are other ways to build logs, but for beginners using the commands that are available to you is pretty easy.
Read on for a demo.
Comments closedGilbert Quevauvilliers wants to go to infinity and beyond:
By default, when using Power BI Premium or Power BI Premium per user the dataset size is set to 10GB.
I have had the wonderful experience of refreshing my dataset and getting the following error:
In the steps below I will show you how to change this setting to allow for larger dataset sizes.
There are a few steps involved, but hey, if you’re paying for Premium, it’s worth a few steps to get this.
Comments closedJess Pomfret contributes to dbatools:
Once I was happy with my settings, I realised we were missing a ‘test’ command for dbatools. The suite of ‘test’ functions in dbatools (a lot that end up as checks in dbachecks btw!), give us an easy way to check our environment against best practices, or our desired settings.
Since dbatools is open-source I was able to write this function (Test-DbaDbQueryStore) and get it added into the module. It’s included as of version 1.0.131, so make sure you’re up to date. Taking Erin’s suggestions and wrapping them in a little PowerShell, I can make it easier for myself and everyone else to make sure we’re following her guidelines.
Click through to see what those settings look like and how you can compare against current settings.
Comments closedAdam Listek brings us up to date on the utility of Write-Host in Powershell:
Over the years, there has been a lot of debate around the PowerShell Write Host cmdlet on whether it’s needed and when to use it. As in most cases, the answer is maybe and dependent on your needs.
To understand
Write-Hostand when to use it, let’s quickly explore the history ofWrite-Hostand learn how best to use this useful cmdlet.
Read on to learn more.
Comments closedJeffrey Hicks takes us through color changes with Powershell:
I readily admit that I spend a great deal of my day at a PowerShell prompt. My day is very much run from the command-line, and has been for quite some time. This used to be a drab, gray existence. But I’ve been finding ways to liven things up. Here’s one way.
The PSScriptTools module includes a number of custom format files with alternate views. You need to make sure the module is imported before you can use any of them.
It’s interesting just how much of a quality of life improvement file type coloration is. I’ll go out of my way to use colorized shells with bash, as well as pretty much any IDE and even Notepad++.
Comments closed