PowerShell script to check last backup date for Databases

PowerShell script to check last full backup, transaction log backup date for SQL Server databases.

Generate All Table Script By Using SMO C#

Generate Script All Table and Specific Table By Using SMO C#

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes

YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.

Powershell - Export Stored Proc results to CSV file

This Powershell script calls a stored procedure and exports the results to a CSV file

PowerShell to SlipStream SQL 2008

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.

Find storage including mount points sql/powershell

Find all storage including mount points and show' free and used available. Needs powershell.

Script to Restore Entire database from a directory

Script to restore the entire databases from the backup directory just by passing the backup directory.

Powershell script to read Windows 2012 R2 Failover cluster log for Sql

I was having a hard time to reading the Windows 2012 R2 Failover cluster log from my live server. That is why I just wrote a simple PowerShell script to get the job done for me.

Change password for user 'sa'

Last week one of my team members was supposed to create a SQL Authenticated ID on a SQL Server 2005 instance. This was as per the request of the Application team who would be using it for an Application.

Aging report GP Dynamics

Using Pivot, coalesce, datediff