Reference link:
Click here for the reference link.
Screenshot – after Removing SQL 2005 using Programs Add/Remove on Windows Server :
Tag: server
Active Directory Creation On Windows Server 2016
Active Directory Creation On Windows Server 2016 – using a Virtual Machine running under Windows 10 Pro Hyper-V
Screenshots:
DNS:
AD should now be functional, for other servers to join this domain.
Note, most core production servers use static ip addresses , and not dynamic/DHCP as might be seen in the screenshots above.
SQL – Powershell Useful Command(s)
update-help
set-executionpolicy remotesigned
$PSversiontable
get-module
import-module SQLPS
psdrive
import-module -Name SQLServer -Scope CurrentUser -AllowClobber
Quick Start: Extended events in SQL Server
Setup Active Directory on Windows server 2012 R2, Windows Server 2016
Screenshots on setting up active Directory on Windows Server 2012/2016:
- after installing Windows Server and running all updates
- Add the role Active Directory – server manager,local server,add roles and features wizard, AD Domain services
SQL Server PowerShell Module
In order to get this to work in Windows 10 , l ran the command below.
Install-module -Name SqlServer -Scope CurrentUser – Force -AllowClobber
Useful Links:
Transferring logins and passwords between separate SQL server Instances
Transferring logins and passwords between separate SQL Server instances eg SVR1\DEV to SVR1\DEV2 can be done by scripting out the encrypted passwords using the stored procedures sp_hexadecimal and sp_help_revlogin which can be found by following this detailed link by clicking here.
SQL Server 2012 System Views Map
Click here to download as a PDF or XLS file, the new SQL Server 2012 System Views Map.
Click here for the SQL 2008/2008 R2 version.
