BuboFlash - helps with learning

Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.

Presentation
Question

Answer

Tags

#Agile #Docs #Powershell #SQL

Question

Which params are used for generating docs in function Generate-Documentation() ?

Answer

The idea is to automate the documentation of multiple SQL Server instances. To make this possible I’ll create a function that takes an argument for the server name, the instance name, and the destination to which to export the Excel file.

function Generate-Documentation()
{
  param(
   [Parameter(Mandatory=$true, Position=1)]
   [ValidateNotNullOrEmpty()]
   [string]$server,
   [Parameter(Mandatory=$true, Position=2)]
   [string]$instance = '',
   [Parameter(Mandatory=$true, Position=3)]
   [ValidateNotNullOrEmpty()]
   [string]$destination
)

Tags

#Agile #Docs #Powershell #SQL

Question

Which params are used for generating docs in function Generate-Documentation() ?

Answer

function Generate-Documentation()
{
  param(
   [Parameter(Mandatory=$true, Position=1)]
   [ValidateNotNullOrEmpty()]
   [string]$server,
   [Parameter(Mandatory=$true, Position=2)]
   [string]$instance = '',
   [Parameter(Mandatory=$true, Position=3)]
   [ValidateNotNullOrEmpty()]
   [string]$destination
)

If you want to change selection, open document below and click on "Move attachment"

Documenting SQL Server with PowerShell - Simple Talk
ses the functions defined in PSSQLLib to retrieve the information, and uses ExcelPSLib to export it to a nicely formatted Excel spreadsheet. Setting the target server and output file properties <span>The idea is to automate the documentation of multiple SQL Server instances. To make this possible I’ll create a function that takes an argument for the server name, the instance name, and the destination to which to export the Excel file. The code below shows the start of the function 1 2 3 4 5 6 7 8 9 10 11 12 function Generate-Documentation() { param( [Parameter(Mandatory=$true, Position=1)] [ValidateNotNullOrEmpty()]

Summary

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Details

No repetitions

Discussion

Do you want to join discussion? Click here to log in or create user.