Use SqlCredential with Powershell to connect to an instance of SQL Server
In this post I will share how to use the SqlCredential object with Powershell when using SQL Authentication in order to pass the password in
No Comments
Read More »
Use PowerShell to Install a Windows Service remotely
When installing a Windows Service remotely as a “Local Service” there are no credentials involved and this is a pretty straight forward task. But if
No Comments
Find the specific sql server t-log to be restored for an unrecovered database
Recently when I needed to find the Transaction Log file that can be applied to a log shipping secondary database I decided to take a
No Comments
Improve performance of files purge with PowerShell
Here is a technique to improve performance when you come across the task of deleting thousands of files located under many folders This is
No Comments
Compressing SQL Server backups using 7Zip4Powershell
When maintaining client’s systems, I tend to pay extra attention about SQL Servers backups, being a ware that the data in most cases is the
No Comments
Sending IIS logs to Logstash and Elasticsearch
Parsing the IIS logs to get statistics can be very useful as these logs hold many properties for each request that has been served by
No Comments
The following two tabs change content below.
Yaniv Etrogi is an SQL Server consultant. He loves SQL Server and he is passionate about Performance Tuning, Automation and Monitoring.
Latest posts by Yaniv Etrogi (see all)
- Monitor AlwaysOn Availabilty Groups - July 6, 2023
- SQL Server – The secret index syntax - February 8, 2023
- Use .net SqlClient with Powershell to access data - January 25, 2023
- Use Powershell to find unused resources in Azure - August 5, 2022