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.
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 »
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 »
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 »
SQLScripter is a powerful command line utility designed to automate the process of schema generation. SQLScripter simply preserves your schema on the file system at many points in time allowing you to easily access any object that you may need, be it a Stored Procedure, a Job, a Login, Partition Function or any other object …
