I am deploying new Dell server that has custom software application that requires Microsoft SQL server. However the new SQL 2016 software during the install says I should not install 2016 SQL on a Primary Domain Controller which has not ever been a problem in the past Microsoft server OS's.
So I think my options are to purchase another workstation and install the SQL on that workstation and make it a member of the 2012 R2 domain.
Should I install Hyper-V and use the two Windows 2012 R2 licensees with one Hyper-V server as the PDC and the second Hyper-V server as the SQL server? I really do not feel comfortable using Hyper-V in a production enviroment where critical company business is be being done everyday. Also backups for Hyper-V are no as easy as Windows 2012 R2 as they are built into the OS and very easy to manage.
New deployment is the following:
Brand new Dell server
Windows 2012 R2 Standard software
SQL 2016 standard software
Optimized for private cloud infrastructures and datacenters, Nano Server is minimalistic, yet super-efficient, OS for services such as Hyper-V and Hyper-V cluster. Learn how you can easily deploy Nano Server and unlock its power!
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.