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 in AlwaysOn Availability Groups for HA and host 26 user databases which on the Enterprise Edition were part of the same single AlwaysOn Group. Now moving to SQL Server Standard …
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 there are plenty of other reasons as well. In order to shorten my Powershell code and simplify my work I have created the bellow Powershell function years a go and …
Use .net SqlClient with Powershell to access data Read More »
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 down payments. First you will need to connect to your Azure account 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 S3 or Azure Blob Storage (applies for On Premise servers). This option is really great and gives you lots of confidence letting you sleep better at nights. it had already …
Download files from Amazon s3 to local folder using Powershell Read More »
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 a secured way connecting to an instance of SQL Server. First step is a one time step creating a secured encrypted password saved in a text file that we latter …
Use SqlCredential with Powershell to connect to an instance of SQL Server Read More »
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 you need to have the service installed under the account of a local user or a domain user then this is somewhat tricky. The security credentials you create using the …
Use PowerShell to Install a Windows Service remotely Read More »
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 few moments and automate the process that I usually do in the old fashion manual way and that includes: 1. generating the restore log commands using a query over backupset …
Find the specific sql server t-log to be restored for an unrecovered database Read More »
Here is a technique to improve performance when you come across the task of deleting thousands of files located under many folders This is a common way to get all the files meeting a criteria of “older than a specific date” from a specific folder including any sub folder if exists while filtering on …
Improve performance of files purge with PowerShell Read More »
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 organization’s most important asset. With that in mind I always look for the extra layer of protection I can provide so that data is protected against any potential threat and …
Compressing SQL Server backups using 7Zip4Powershell Read More »
As a professional maintaining and managing databases for clients I am very well aware of the fact that Data Integrity in relational databases is absolutely crucial. As DBAs the data we maintain and support, is in many cases the organization’s most important asset. Data Corruption is a topic for it self that I will not …
Perform DBCC CHECKDB Data Integrity checks on Log Shipping Secondary server Read More »
Years a go when working on a .net project I came across log4net and thought I will give it a shot. Using log4net in my project I immediately saw the advantage of using this logger and adopted it ever since replacing my home made hand crafted logger. Checkout the features page of log4net. As time …
Before moving forward be sure to have read this previous post that is the basis for the current post. This is the link to me GitHub diskspd project containing the relevant files discussed in these 2 blog posts mini serious. Working quiet often with diskspd it was only natural for me to automate the tiring …
This is the link to my GitHub diskspd project diskspd was designed as a storage testing tool and that basically mean test your SAN or NAS but not only SAN/NAS based disks, you can test any other disk, be it a DAS, a local drive on your server or your new laptop’s SSD (I always …
Using diskspd to test disk performance with SQL Server Read More »
This is my very first blog post at my own site after over a year of none blogging. What happened is that the site I use to blog at http://blogs.microsoft.co.il/yaniv_etrogi has gone down…. yes, I know…. with tones of my blog posts, I had so many posts just around the Replication features, Partitioning and lots …
Use Powershell to Multi Thread SQL Server Index Maintenance tasks Read More »
