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
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…