SQL Server 2016 Cluster – Partially Running [half red/half green] – came across below issue, and upon further investigation l noticed the nodes has CEIP versions of Analysis services as well as Agent. Simply removing these roles, returned the server roles status to running/green Click here for reference link on msdn.microsoft forum Click here […]
Reference link: Click here for the reference link. Screenshot – after Removing SQL 2005 using Programs Add/Remove on Windows Server :
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 […]
update-help set-executionpolicy remotesigned $PSversiontable get-module import-module SQLPS psdrive import-module -Name SQLServer -Scope CurrentUser -AllowClobber
For SQL 2014/2016: Concise guide here: Quick Start: Extended events in SQL Server – click here Root URL on extended events – click here.
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
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: Powershell Gallery Download SSMS -SQL Server Management Studio
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.
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.