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.
2014-08-29 (first published: 2012-05-23)
3,296 reads
This Powershell script calls a stored procedure and exports the results to a CSV file
2014-08-28 (first published: 2013-01-03)
5,090 reads
PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.
2014-08-27 (first published: 2013-04-18)
1,201 reads
Find all storage including mount points and show' free and used available. Needs powershell.
2014-08-25 (first published: 2011-12-15)
1,399 reads
Script to restore the entire databases from the backup directory just by passing the backup directory.
2014-08-22 (first published: 2014-02-25)
3,324 reads
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.
2014-08-21 (first published: 2014-07-29)
1,755 reads
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.
2014-08-20 (first published: 2014-08-13)
1,916 reads
Using Pivot, coalesce, datediff
2014-08-18 (first published: 2014-07-28)
1,264 reads
This is a script to restore all databases from backups places in a folder.
2014-08-15 (first published: 2014-07-16)
1,559 reads
Restore script for moving databases from prod to dev with different path / logical name etc.
2014-08-14 (first published: 2014-05-30)
5,929 reads