5 Days of Building, Developing and Managing SQL Server

Monitoring, Maintaining, and Tuning, For Database Administrators, For IT Professionals

SQTH19 Manage SQL Server 2012 on Windows Server Core Using PowerShell

12/13/2012

3:00PM - 4:15PM

Level: Intermediate to Advanced

Allen White

Allen White

Practice Manager

UpSearch Technology Services

Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform.

You will learn:

  • The benefit of Server Core
  • How to install SQL Server 2012 on Server Core
  • How to use PowerShell to manage SQL Server 2012 on Server Core