FlogDonkey

DECLARE @WorkingSQL		 VARCHAR(8000)
		,@NewPath		 VARCHAR(8000) = 'G:\SQL Data\' /* Root location to move files */
		,@TargetDatabase sysname	   = '%';			/* Specify a singular database, or % for All Databases */

SET NOCOUNT ON;

/* Enable xp_cmdshell */
EXEC sys.sp_configure 'Show Advanced Options', 1;
RECONFIGURE;

EitanBlumin

/**************************************************************************
	Check Index Fragmentation based on Page Fullness and Fill Factor
***************************************************************************
Author: Eitan Blumin | https://www.eitanblumin.com
Version History:
	2020-10-20	Added @MaxDOP parameter, and better comments & indentation
	2020-01-07	First version

Description:
	This script was inspired by Erik Darling's blog post here:

mweisel

function Get-DiskFree
{
    [CmdletBinding()]
    param 
    (
        [Parameter(Position=0,
                   ValueFromPipeline=$true,
                   ValueFromPipelineByPropertyName=$true)]
        [Alias('hostname')]
        [Alias('cn')]

raelgc

Setup a Local Only Email Server (Windows Only)

1 - Install hMailServer

Download hMailServer from here: http://www.hmailserver.com/index.php?page=background_download_file&downloadid=207.

• In setup, select internal db engine.
• Now you have a service called hMailServer and an administration program on the Windows start menu (hMailServer Administrator).

2 - Create a domain