Couple of weeks back I released Powershell cmdlets for DocumentDB in Github (Further info on this can be found in my blog here). Today I merged & added Automatic Indexing & IndexingMode parameters to the Add-DocumentCollection Cmdlet to the project in the module. https://github.com/savjani/Azure-DocumentDB-Powershell-Cmdlets Azure DocumentDB collections are auto-indexed by default allowing the developers to…
Azure DocumentDB is Microsoft’s new budding NoSQL Schema Free database offering which is relatively a recent addition to the mammoth Microsoft Data Platform Stack. Azure DocumentDB provides great flexibility to the Developer world who feels a lot restricted with RDBMS data model, adhering to the data types, schema, index designs & patterns. Azure DocumentDB gives…
Following is the powershell script to script out all the Jobs in one go. param($sqlserver) [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SqlServer.Smo”) | Out-Null $srv = New-Object “Microsoft.SqlServer.Management.Smo.Server” $sqlserver $srv.JobServer.Jobs | foreach {$_.Script()} You can copy the above code in a notepad and save it as .ps1 file in some location on server. Next from the Object Explorer in SQL Management…