Created by Camtasia 9

Over 175 More SQL and PowerShell Procedures and CmdLets: Names and Descriptions
  • Migration Commands General Administration Commands
  • Clear-DbaSqlConnectionPool
  • Start-SqlMigration Backup-DbaDatabase
  • Export-DbaExecutionPlan
  • Server
  • Find-DbaAgentJob
  • Copy-SqlCustomError
  • Find-DbaDatabase
  • Copy-SqlSpConfigure
  • Find-DbaDatabaseGrowthEvent
  • Export-SqlSpConfigure
  • Find-DbaLoginInGroup
  • Import-SqlSpConfigure
  • Find-DbaOrphanedFile
  • Find-DbaStoredProcedure
  • Databases
  • Find-DbaUserObject
  • Copy-DbaQueryStoreConfig
  • Get-DbaAgentAlert
  • Copy-SqlDatabase
  • Get-DbaAgentJobOutputFile
  • Copy-SqlDatabaseAssembly
  • Get-DbaAgentOperator
  • Copy-SqlSysDbUserObjects
  • Get-DbaAvailabilityGroup
  • Export-DbaAvailabilityGroup
  • Get-DbaBackupHistory
  • Test-SqlMigrationConstraint
  • Get-DbaClientProtocol
  • Get-DbaConfig
  • Security
  • Get-DbaCredential
  • Copy-SqlLogin
  • Get-DbaCustomError
  • Copy-SqlCredential
  • Get-DbaDatabase
  • Copy-SqlAudit
  • Get-DbaDatabaseAssembly
  • Copy-SqlAuditSpecification
  • Get-DbaDatabaseFile
  • Export-SqlLogin
  • Get-DbaDatabaseFreespace
  • Export-SqlUser
  • Get-DbaDatabaseSnapshot
  • Get-DbaDatabaseState
  • Server Objects
  • Get-DbaDetachedDatabaseInfo
  • Copy-SqlBackupDevice
  • Get-DbaDatabaseEncryption
  • Copy-SqlEndpoint
  • Get-DbaExecutionPlan
  • Copy-SqlLinkedServer
  • Get-DbaHelpIndex
  • Copy-SqlServerTrigger
  • Get-DbaNetworkActivity
  • Get-DbaPermission
  • SSIS
  • Get-DbaProcess
  • Copy-SqlSsisCatalog
  • Get-DbaRestoreHistory
  • Get-DbaRoleMember
  • Management
  • Get-DbaRunningJob
  • Copy-SqlPolicyManagement
  • Get-DbaBackupDevice
  • Copy-SqlDataCollection
  • Get-DbaClusterActiveNode
  • Copy-SqlResourceGovernor
  • Get-DbaConfigValue
  • Copy-SqlExtendedEvent
  • Get-DbaDependency
  • Copy-SqlDatabaseMail
  • Get-DbaDiskSpace
  • Get-DbaMemoryUsage
  • Registered Servers
  • Get-DbaMsdtc
  • Copy-SqlCentralManagementServer
  • Get-DbaPageFileSetting
  • SQL Server Agent
  • Get-DbaQueryExecutionTime
  • Copy-SqlServerAgent
  • Get-DbaQueryStoreConfig
  • Copy-SqlJob
  • Get-DbaJobCategory
  • Copy-SqlSharedSchedule
  • Get-DbaLocaleSetting
  • Copy-SqlAgentCategory
  • Get-DbaPrivilege
  • Copy-SqlAlert
  • Get-DbaServerProtocol
  • Copy-SqlOperator
  • Get-DbaSpConfigure
  • Copy-SqlProxyAccount
  • Get-DbaSpn
  • Get-DbaSqlBuildReference
  • Best Practice Commands
  • Get-DbaSqlService
  • Expand-SqlTLogResponsibly
  • Get-DbaServerAuditSpecification
  • Find-SqlDuplicateIndex
  • Get-DbaStartupParameter
  • Find-SqlUnusedIndex
  • Get-DbaTcpPort
  • Get-DbaLastBackup
  • Get-DbaTempdbUsage
  • Get-DbaLastGoodCheckDb
  • Get-DbaTrigger
  • Get-DbaMaxMemory
  • Get-DbaUptime
  • Repair-DbaServerName
  • Get-DbaXEventsSession
  • Set-DbaDatabaseOwner
  • Get-SqlRegisteredServerName
  • Set-DbaJobOwner
  • Get-SqlServerKey
  • Set-DbaMaxDop
  • Install-SqlWhoIsActive
  • Set-DbaPowerPlan
  • Measure-DbaBackupThroughput
  • Set-DbaMaxMemory
  • New-DbaDatabaseSnapshot
  • Set-SqlTempDbConfiguration
  • New-DbaSqlDirectory
  • Test-DbaMaxDop
  • New-DbaSsisCatalog
  • Test-DbaDatabaseCollation
  • Read-DbaBackupHeader
  • Test-DbaDatabaseCompatibility
  • Read-DbaTransactionLog
  • Test-DbaDatabaseOwner
  • Remove-DbaBackup
  • Test-DbaDiskAlignment
  • Remove-DbaDatabase
  • Test-DbaDiskAllocation
  • Remove-DbaDatabaseSnapshot
  • Test-DbaJobOwner
  • Remove-DbaSpn
  • Test-DbaLastBackup
  • Remove-SqlDatabaseSafely
  • Test-DbaMaxMemory
  • Remove-SqlOrphanUser
  • Test-DbaOptimizeForAdHoc
  • Rename-DbaLogin
  • Test-DbaPowerPlan
  • Repair-SqlOrphanUser
  • Test-DbaServerName
  • Reset-SqlAdmin
  • Test-DbaSpn
  • Resolve-DbaNetworkName
  • Test-DbaValidLogin
  • Restore-DbaDatabase
  • Test-DbaVirtualLogFile
  • Restore-DbaFromDatabaseSnapshot
  • Test-SqlTempDbConfiguration
  • Restore-SqlBackupFromDirectory
  • Set-DbaAgentJobOutputFile
  • Set-DbaConfig
  • Set-DbaDatabaseState
  • Set-DbaQueryStoreConfig
  • Set-DbaSpConfigure
  • Set-DbaSpn
  • Show-SqlDatabaseList
  • Show-SqlServerFileSystem
  • Show-SqlWhoIsActive
  • Sync-SqlLoginPermissions
  • Test-DbaConnectionAuthScheme
  • Test-DbaIdentityUsage
  • Test-DbaLinkedServerConnection
  • Stop-DbaProcess
  • Test-DbaFullRecoveryModel
  • Test-SqlNetworkLatency
  • Test-SqlPath
  • Update-SqlWhoIsActive
  • Watch-SqlDbLogin

Combining LDAP, SMO, DDE and CMS with PowerShell

Restructuring your entire approach to SQL Server DatabaseMaintenance Practices, SQL Server Performance Tuning, SQL Log File Consolidation and Analysis as well as Auditing for Best Practices and Compliance Requirements will pay dividends now and in the future.

Applying Consistent Design Principles

Incorporating the various components of our solutions, including some or all of our 400 PowerShell Scripts and SQL Stored Procedures combined with SQL Management Objects (SMO) with all data extracts going directly into Excel Workbook Tabs in real time updated using Dynamic Data Exchange (DDE) is a winning combination that must be seen to be fully appreciated. Consistent, Predictable and Repeatable Results are what Auditors and Compliance Staff are striving for today.


Benefits of Implementing Our PowerShell Based Consulting Services

Creation of an Integrated and Consistent Solution to SQL Server Management

  • Adherence to Accepted Microsoft Best Practices for SQL Server
  • Consistently Addressing Data Governance, Compliance and Auditing Issues
  • Innovative Approaches to Automation of Database Maintenance Processes
  • Rigorous Consistency Applied to All SQL Server Properties and Settings
  • Usage of PowerShell with SQL Management Objects (SMO) and Excel Reporting
  • Optimization of the Viewing and Analysis of All SQL and Windows Logs
  • Adoption of the Central Management Server Tools, Methods and Techniques
  • Implement Single Click Sign-Ons for DBAs for Query Windows and RDP Access
  • Replacing Risks of SQL Server Exchange eMail with the SMTP Equivalents

Research beyond the business plan

Conveniently orchestrate goal-oriented collaboration and idea-sharing and visionary methodologies. Completely fabricate.

Making a commitment to evaluating a PowerShell drive approach to SQL Server Maintenance Management will yield many benefits
Investing the time to overcome the PowerShell Learning Curve will not take as much time as you might think. PowerShell techniques build on familiar scripting tools We provide the frameworks and templates to assist developers in converting legacy scripts into more powerful and dynamic PowerShell equivalents.

Making a commitment to evaluating a PowerShell drive approach to SQL Server Maintenance Management will yield many benefits
Investing the time to overcome the PowerShell Learning Curve will not take as much time as you might think. PowerShell techniques build on familiar scripting tools We provide the frameworks and templates to assist developers in converting legacy scripts into more powerful and dynamic PowerShell equivalents.