PowerShell can’t see network locations after SQLPS module is loaded
vstrien is using the (legacy) SQLPS Powershell module, and running into a bug where importing the module changes your current directory.
PowerShell
What time is it in Oz?
There was a recent post on Database Administrators, where there was some confusion over Daylight Saving Time(DST) in Australian timezones. Let’s be honest though–timezones are confusing, especially when DST comes into play. Arizona Time doesn’t observe Daylight Saving Time, so sometimes it’s the same as … [Read More]
Function to create SQL TABLE does not works well using Powershell
Question I need to get the values from a Excel Sheet (in a shared folder) to export it and then create a SQL Table in my instance. After of this I will execute a Stored Procedure (I already created) in order to create extended properties … [Read More]
Multi-subnet availability group, with mixed MultiSubnetFailover support (Part 2)
In yesterday’s post, I showed how to configure an availability group (AG) to use the RegisterAllProvidersIP=0 when you can’t get clients to connect using the MultiSubnetFailover=true connection string attribute. I mentioned that you have to make some trade-offs when you set RegisterAllProvidersIP=0, and included this … [Read More]
Multi-subnet availability group, without MultiSubnetFailover support (Part 1)
As a DBA, we have the opportunity & responsibility to build highly available database platforms for use by applications & users. Even if you are a DBA at a small company supporting databases for only internal applications, we are usually still responsible for providing databases … [Read More]
Copying SQL Server settings to new server
UserSteve is upgrading to a new server and needs to move all his server settings to the new instance. I introduce him to DBA Tools as a quick way to copy configurations and other stuff to the new instance.
Using PowerShell to tidy up CSV files
I was recently fussing with a CSV file that had an inconsistent number of columns. UGH. There was a bunch of historical data that had 4 columns, and then more recent data had a new attribute added with 5 columns. I spent a few minutes … [Read More]
Generating artificial CPU load 🔥
I was recently asked: For testing, I need to generate artificial CPU load on the server, outside of SQL Server. Do you have any ideas? Maybe something with PowerShell? I quickly replied: Heck yea, PowerShell can do that. I mean, I knew PowerShell could do … [Read More]
Is that share using SMBv1?
In case you’ve missed it (though, if you’re a data professional or other IT pro, you must live under a rock if you’ve missed it), SMBv1 should never ever be used. Alas, some shares out there still exist & use it. Recent Windows updates have … [Read More]
Using PowerShell to navigate SQL Server as a drive
I might be a SQL Server pro, but I’m still a PowerShell novice. I learn best by doing, so I keep pushing myself to do more with PowerShell so that I can learn more. If you don’t already know this about the SqlServer PowerShell Module, … [Read More]