New PowerShell Cmdlets in SQL Denali CTP3

CTP3 of SQL Denali is finally publicly available!

I woke up at 5 am this morning to kick off my download.  I’ve finished the install and I’m happy that I can finally report that we have new cmdlets for SQL Server. 

First off, after running Get-Module -ListAvailable I saw:

Manifest   SQLASCMDLETS
Manifest   SQLPS

This means that SQLPS inside of SQL Agent should finally allow you to import a module during your job step. 

There is now a Function called SQLServer that, from what I can tell, is the SQLServer Provider.  When under PS SQLSERVER:\> if you do a dir | Select pschildname you will find the following list:

PSChildName
———–
SQL
SQLPolicy
SQLRegistration
DataCollection
XEvent
Utility
DAC
IntegrationServices
SQLAS

From my notes it looks like XEvent, IntegrationServices, and SQLAS are the directories that have been added here.  Can’t wait to try out the IntegrationServices portion!  [Update]: Apparently I may need a defaul instance install for this to work.

I also noticed that Tab-Completion appears to be fixed!!  🙂  Also, SQL Registrations > ‘Database Engine Server Group’ are split up into instances like CMS was.  Not sure what that’s all about just yet.  In fact when I try to use it, it doesn’t seem to work.  Maybe I should read the help files.  But I think they may have just gotten CMS & RS reversed.  CMS isn’t working for me either yet.

When you drill down under XEvents and go to your Denali instaince you will see: Packages, & Sessions.  I guess this means that I finally need to read Jonathat’s blog series on X-Events.

When I imported the SQLPS module I received a warning about unapproved verbs.  Oh well, hopefully they’ll work that out soon.  Next I ran Get-Command -Module “SQLPS” and found the following list of cmdlets.

NameModule
Add-SqlAvailabilityDatabaseSQLPS
Add-SqlAvailabilityGroupListenerStaticIpSQLPS
Backup-SqlDatabaseSQLPS
Convert-UrnToPathSQLPS
Decode-SqlNameSQLPS
Disable-SqlHADRServiceSQLPS
Enable-SqlHADRServiceSQLPS
Encode-SqlNameSQLPS
Invoke-PolicyEvaluationSQLPS
Invoke-SqlcmdSQLPS
Join-SqlAvailabilityGroupSQLPS
New-SqlAvailabilityGroupSQLPS
New-SqlAvailabilityGroupListenerSQLPS
New-SqlAvailabilityReplicaSQLPS
New-SqlHADREndpointSQLPS
Remove-SqlAvailabilityDatabaseSQLPS
Remove-SqlAvailabilityGroupSQLPS
Remove-SqlAvailabilityReplicaSQLPS
Restore-SqlDatabaseSQLPS
Resume-SqlAvailabilityDatabaseSQLPS
Set-SqlAvailabilityGroupSQLPS
Set-SqlAvailabilityGroupListenerSQLPS
Set-SqlAvailabilityReplicaSQLPS
Set-SqlHADREndpointSQLPS
SQLSERVERSQLPS
Suspend-SqlAvailabilityDatabaseSQLPS
Switch-SqlAvailabilityGroupSQLPS
Test-SqlAvailabilityGroupSQLPS
Test-SqlAvailabilityReplicaSQLPS
Test-SqlDatabaseReplicaStateSQLPS

Analysis Services got some love too in the form of 11 cmdlets!  After inporting the SQLASCMDLETS module I ran this Get-Command -Module “SQLASCMDLETS” and found the following.

NameModule
Add-RoleMemberSQLASCMDLETS
Backup-ASDatabaseSQLASCMDLETS
Invoke-ASCmdSQLASCMDLETS
Invoke-ProcessCubeSQLASCMDLETS
Invoke-ProcessDimensionSQLASCMDLETS
Invoke-ProcessPartitionSQLASCMDLETS
Merge-PartitionSQLASCMDLETS
New-RestoreFolderSQLASCMDLETS
New-RestoreLocationSQLASCMDLETS
Remove-RoleMemberSQLASCMDLETS
Restore-ASDatabaseSQLASCMDLETS

More news to follow soon!

Please Share This:

Share on facebook
Share on twitter
Share on linkedin

You may also like:

2 Responses

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Follow:

Subcribe to Blog Via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

What I'm Saying on Twitter

Subscribe via feedburner