SQL and PowerShell Procedures and CmdLets Description
  • 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.