Microsoft – SQLMint

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

Powershell Notes: SSMS 2017

Error screenshots and resolution.

Issue from SSMS 2017 – Click here to download SSMS 2017

Get Powershell Gallery from this link. Click here.

Database mail failure – SQL Server 2016 – On Windows Server 2016

Issue:

SQL Server 2016 would not send mail on a new server migration to Windows Server 2016

Solution:

By default, Windows Server 2016 installs .net framework 4.7

The database mail feature needs .Net 3.5

Install this windows feature and this issue gets resolved.

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

Security Update for SQL Server 2014 Service Pack 2 GDR (KB3194714)

“KB Articles: KB3194714 Security bulletins:SQL Server 2014 MS16-136 Security issues have been identified in SQL Server 2014 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. You can help protect your computer by installing this update from Microsoft. After you install this item, you may have to restart your computer.” …. source Microsoft website

Click here for the download/installation link. https://www.microsoft.com/en-us/download/details.aspx?id=54190

Microsoft R – SQL 2016 – Notes

“R is a free software environment for statistical computing and graphics” – source click here.

Useful links:

Quick notes:

You need Windows Server 2012 R2
JDK needs to be installed before running the SQL 2016 setup program
Enable TCP/IP and restart your SQL 2016 instance.
Connect to the instance.
Run:Exec sp_configure ‘external scripts enabled’, 1;reconfigure;
Restart all services, SDE, SSA, Polybase, Launchpad service.
Note. If you don’t restart the Launchpad service, you will get below error message.
Msg 39011, Level 16, State 1, Line 8
SQL Server was unable to communicate with the LaunchPad service. Please verify the configuration of the service.
Msg 11536, Level 16, State 1, Line 8
EXECUTE statement failed because its WITH RESULT SETS clause specified 1 result set(s), but the statement only sent 0 result set(s) at run time.

Microsoft SQL Server 2016 – Basic Installation in picture steps

Microsoft SQL Server 2016 – Basic Installation in picture steps.

Note the differences from SQL 2012/2014 installation. Also, SSMS [SQL Server management studio] 2016 is a separate installation which you can download from here,

Links

Microsoft R Getting Started Guide

Click here for a good guide on Microsoft R Getting Started Guide – R was introduced with Microsoft SQL Server 2016

Click here for the documentation link, by Josee Martens.

Diskspd – SQLIO Replacement

Diskspd Utility application. This is a new robust storage Testing Tool (superseding SQLIO).
“”A feature-rich and versatile storage testing tool, Diskspd combines robust and granular IO workload definition with flexible runtime and output options, creating an ideal tool for synthetic storage subsystem testing and validation.””

Click here for the download link.

Sample output from a run on a basic PC hard drive.