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 »
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 »
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 »
Working with partitions at different environments has led me to think that a generic unified code to manage partitions can be very useful and practical. Think about it, if you look at a code that manages a partition sliding window implemented by 10 different DBAs you are going to see 10 different variations of the
SQL Server exposes missing indexes metadata via the following 3 DMVs (Dynamic Management Views) sys.dm_db_missing_index_details, sys.dm_db_missing_index_groups and sys.dm_db_missing_index_group_stats which combined in a simple query return valuable information of indexes that were detected as missing by the Optimizer and logged in those DMVs. The information in these DMVs is updated by the execution of every query
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
As far as I recall the trigger to code sp_helpindex2 was that with the introduction of INCLUDE columns to indexes that was added in SQL Server 2005 the old way of viewing indexes using sp_helpindex was useless since Microsoft has not modified their procedure to support the recently added INCLUDE columns. I had therefore found myself, when tuning queries,
