O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Cmdlets

SQL Server 2012 implements a small number of PowerShell cmdlets for the Database Engine. These cmdlets are available within the SQL Server PowerShell console or if the snap-in is loaded manually, which is not covered in any detail here:

Image Invoke-PolicyEvaluation—A cmdlet that evaluates a SQL Server Policy-Based Management policy (or policies) against a target server.

Image Invoke-SqlCmd—A cmdlet that runs any regular T-SQL command and any languages and commands supported by the sqlcmd utility, which may be more familiar to most users.

Encode-SqlName ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required