Monitor AlwaysOn Availabilty Groups
One of my client’s has recently downgraded his SQL Servers from Enterprise Edition to Standard Edition to cut costs. The 2 SQL Servers are configured
No Comments
Read More »
SQL Server – The secret index syntax
In this post I would like to share a CREATE INDEX syntax I was not aware of which I came across a few years ago
No Comments
Use .net SqlClient with Powershell to access data
As a DBA working daily with SQL Servers I use Powershell from time to time to access my sql servers mostly for automation tasks but
No Comments
Use Powershell to find unused resources in Azure
Here are a few scripts that I have recently used to find Azure resources that are no longer needed and can be removed to cut
No Comments
Download files from Amazon s3 to local folder using Powershell
As part of the services we provide our clients around Microsoft SQL Server we also provide a service that uploads database backup files to Amazon
No Comments
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
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