Chapter 4
SQL Server Command-Line Administration
TOPICS COVERED IN THIS CHAPTER:
- Introducing the Command Prompt
- General Commands
- Batch Files
- Mastering SQLCMD
- Introducing Windows PowerShell
- Using SQL Server PowerShell Extensions
- Windows Scripting Host
Why would anyone want to use the command line to administer SQL Server when Microsoft's GUI tools are so convenient? This question comes up quite frequently when DBAs and other IT professionals are being coached on automation concepts in a Microsoft environment. This chapter is focused on answering that question through demonstration, but for now consider that the command line provides an interactive ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
