What time is it in Oz?
How Australian daylight saving time affects time zone conversions in SQL Server and why the offset can surprise you.
Continue readingBrowse the archive
PowerShell
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 for a specific schema …
Continue reading
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 …
Continue reading
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 …
Continue reading
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.
Continue reading
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 cursing whoever was …
Continue reading
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 it. …
Continue reading
Is that share using SMBv1?
Check whether a Windows file share still uses SMBv1 before disabling the legacy protocol.
Continue reading
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, you can access SQL Server …
Continue reading
Troubleshooting Powershell errors from SQL Agent job
Question I have a powershell script that I am trying to add in to a sql agent job, but the job step is failing with the following error A job step received an error at line 1 in a PowerShell script. The corresponding line is 'import-module SQLPS …
Continue reading