A Fine Slice Of SQL Server
Jack Vamvas wants us to remember who we are:
Question: I’m executing a Powershell Script . When I started the Powershell console , it was the “different user” option.
Within the powershell script – I want to check\confirm the current user executing the script.
Read on to learn how.
Comments closedJeffrey Hicks tries out the Secrets Management modules in Powershell:
So I’ve been kicking the tires and trying to do more with the Secrets Management modules from Microsoft, now that they are out of pre-release status. You can install the Microsoft.PowerShell.SecretStore and Microsoft.PowerShell.SecretManagement modules, you’ll need both, from the PowerShell Gallery. You can find extension modules that build on the Microsoft modules for working with other key vaults or secret store. Run
find-module -tag secretmanagementto find additional modules. But what I want to talk about today relates to the Microsoft modules. Although, it might apply to you with any of the extension modules. The challenge is using the secrets management modules with a PowerShell profile script.
Read on for a challenge around running scheduled tasks which require secrets and a solution.
Comments closedJack Vamvas has a cmdlet for us:
Question: I have an SQL Server Instance – currently configured with a Dynamic Port. I’d like to change the setting from a Dynamic port configuration to a Static port configuration , using Powershell.
I want to change to a static port as we need to set up some Firewall rules , and using a static port will be much easier
How can this be done?
Click through for the answer.
Comments closedEric Cobb has a Powershell snippet for us:
I recently had a case where I needed to compare the Active Directory Groups of 2 users and determine which AD Groups both users were in. As it turns out, with a little prep work this is really easy to do in PowerShell.
Click through for the setup and the process.
Comments closedEmanuele Meazzo was in a bind:
If you read my previous article on how to configure a Linked server to Oracle , you know that I feel like someone is plotting to keep the topic of how to get our precious data outside of the Oracle ecosystem as obscure as possible out of the oracle circle
Fear not! I’m here to get you all the info in order to get data from Oracle Database via Powershell, in a native high-performance way, allowing you to create a multithreaded, reliable and connected ETL flow to feed a data warehouse from Oracle data, like the owner of this blog, or just move quickly some data from one place to another, programmatically, whatever it’s your need.
I support any effort to get data away from Oracle. Click through for the script and an explanation of each step.
Comments closedJeffrey Hicks follows up on a prior post:
Last week I shared a little nugget about making PowerShell life easier by using the built-in variable, $PSDefaultParameterValues. This is a special hashtable where you can define default parameter values for any PowerShell command. This means any PowerShell script or function that has defined parameters AND uses [cmdletbinding()]. If you have a simple function that only uses a Param() block, $PSDefaultParameterValues won’t work for that function. I recommend that all PowerShell functions use [cmdletbinding()] so hopefully, this won’t be an issue. Since I received some positive feedback and a few questions on the previous post, I thought a quick follow-up might be in order.
Read on for additional useful information regarding $PSDefaultParameterValues.
Rob Farley has a change of heart:
The concept is that if I have a notebook with a bunch of queries in it, I can easily call that using Invoke-SqlNotebook, and get the results of the queries to be stored in an easily-viewable file. But I can also just call Invoke-SqlCmd and get the results stored. Or I can create an RDL to create something that will email me based on a subscription. And I wasn’t sure I needed another method for running something.
Read on to see what changed Rob’s mind.
Comments closedJack Vamvas answers a question:
I use Powershell extensively to manage SQL Server and the Windows OS. A common problem is to identify location of the Windows Recycle Bin and clear the contents down – particuarly if there is a space issue.
How can I locate the Windows Recycle Bin and clear it down?
Read on for the Powershell v5 solution as well as the solution which works for earlier versions.
Comments closedJeffrey Hicks doesn’t have time for parameters:
A quick post today to remind you of a way to make PowerShell even easier to use. PowerShell cmdlets and functions obviously help us get a lot done, and most commands offer a number of parameters to customize what needs to be done. Unless you love typing, you probably would like an even easier way to use PowerShell. Let me show you.
Read on to see how. My one concern here would be if you forget about the parameters, you may end up with unexpected results compared to people without your default parameters. This seems to me a case for using these defaults somewhat sparingly.
Comments closedJeffrey Hicks does some spring cleaning:
Springtime is approaching in North America. Where I live, the snow has finally melted and we have blue skies with warmer temperatures. Of course, this means Spring Cleaning. Time to clear out the winter debris and spruce up the house. For me, this is also a good time for some computing housecleaning as well. I don’t know about your Windows environment, but I tend to accumulate a lot of junk. Most of the time I don’t see it, but I know it’s there. While the junk normally doesn’t have a negative impact, I think mentally, I like clearing things out and tidying up. So I pulled out some older PowerShell code, freshened it up, and now I have a set of tools for clearing out junk and temporary folders. Let me show you what I came up with.
Click through for the scripts.
Comments closed