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,251 reads
Find all storage including mount points and show' free and used available. Needs powershell.
2014-08-25 (first published: 2011-12-15)
1,378 reads
works two different ways using sql for 2000 and 2005 and powershell for 2008.
2012-05-23 (first published: 2012-05-01)
5,709 reads
Create a c:\servers.txt list of servers. No spaces or it wont work. Then copy the code into a ps1 file and edit the directroyfilename to show where you want the files to end up.
2012-02-17 (first published: 2012-01-23)
1,839 reads
Find drive, freespace, usedspace and percent free for all drives and mounted volumes.
2012-02-16 (first published: 2011-12-15)
804 reads
2012-02-07 (first published: 2011-12-15)
1,031 reads
2012-01-25 (first published: 2011-12-15)
1,180 reads
find and replace text in a text file using tsql
2012-01-23 (first published: 2011-12-16)
3,059 reads
will create jobs script for backup or DR purposes to install on another server.
2012-01-18 (first published: 2011-12-15)
2,141 reads
This script will backup your files that have changed only. old files will not be copied just newer ones.
2012-01-17 (first published: 2011-09-20)
711 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers