July, 2011:

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. Name Module Add-SqlAvailabilityDatabase SQLPS Add-SqlAvailabilityGroupListenerStaticIp SQLPS Backup-SqlDatabase SQLPS Convert-UrnToPath SQLPS Decode-SqlName SQLPS Disable-SqlHADRService SQLPS Enable-SqlHADRService SQLPS Encode-SqlName SQLPS Invoke-PolicyEvaluation SQLPS Invoke-Sqlcmd SQLPS Join-SqlAvailabilityGroup SQLPS New-SqlAvailabilityGroup SQLPS New-SqlAvailabilityGroupListener SQLPS New-SqlAvailabilityReplica SQLPS New-SqlHADREndpoint SQLPS Remove-SqlAvailabilityDatabase SQLPS Remove-SqlAvailabilityGroup SQLPS Remove-SqlAvailabilityReplica SQLPS Restore-SqlDatabase SQLPS Resume-SqlAvailabilityDatabase SQLPS Set-SqlAvailabilityGroup SQLPS Set-SqlAvailabilityGroupListener SQLPS Set-SqlAvailabilityReplica SQLPS Set-SqlHADREndpoint SQLPS SQLSERVER SQLPS Suspend-SqlAvailabilityDatabase SQLPS Switch-SqlAvailabilityGroup SQLPS Test-SqlAvailabilityGroup SQLPS Test-SqlAvailabilityReplica SQLPS Test-SqlDatabaseReplicaState SQLPS 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. Name Module Add-RoleMember SQLASCMDLETS Backup-ASDatabase SQLASCMDLETS Invoke-ASCmd SQLASCMDLETS Invoke-ProcessCube SQLASCMDLETS Invoke-ProcessDimension SQLASCMDLETS Invoke-ProcessPartition SQLASCMDLETS Merge-Partition SQLASCMDLETS New-RestoreFolder SQLASCMDLETS New-RestoreLocation SQLASCMDLETS Remove-RoleMember SQLASCMDLETS Restore-ASDatabase SQLASCMDLETS More news to follow soon!