Over 165 SQL Management Objects (SMO) for Database Properties and Database Property Descriptions
  • int ActiveConnections: 0
  • DatabaseActiveDirectory ActiveDirectory:
  • bool AnsiNullDefault: False
  • bool AnsiNullsEnabled: False
  • bool AnsiPaddingEnabled: False
  • bool AnsiWarningsEnabled: False
  • ApplicationRoleCollection ApplicationRoles:
  • bool ArithmeticAbortEnabled: False
  • AsymmetricKeyCollection AsymmetricKeys:
  • bool AutoClose: False
  • bool AutoCreateIncrementalStatisticsEnabled: False
  • bool AutoCreateStatisticsEnabled: True
  • bool AutoShrink: False
  • bool AutoUpdateStatisticsAsync: False
  • bool AutoUpdateStatisticsEnabled: True
  • AvailabilityDatabaseSynchronizationState:
  • string AvailabilityGroupName:
  • string AzureEdition:
  • string AzureServiceObjective:
  • bool BrokerEnabled: False
  • bool CaseSensitive: False
  • bool ChangeTrackingAutoCleanUp: False
  • bool ChangeTrackingEnabled: False
  • int ChangeTrackingRetentionPeriod: 0
  • RetentionPeriodUnits ChangeTrackingRetenti: None
  • bool CloseCursorsOnCommitEnabled: False
  • string Collation: SQL_Latin1_General_CP1_CI_AS
  • ColumnMasterKeyCollection ColumnMasterKeys:
  • CompatibilityLevel: Version100
  • bool ConcatenateNullYieldsNull: False
  • ContainmentType ContainmentType: None
  • datetime CreateDate: 3/28/2017 1:23:47 PM
  • DatabaseAuditSpecificationCollection:
  • DatabaseEncryptionKey DatabaseEncryptionKe: Microsoft.SqlServer.Management.Smo.DatabaseEncryptionKey
  • guid DatabaseGuid: ef41eb1f-d2fd-47cb-8ab5-0dc8047b0d1d
  • DatabaseOptions DatabaseOptions: Microsoft.SqlServer.Management.Smo.DatabaseOptions
  • bool DatabaseOwnershipChaining: False
  • string DatabaseSnapshotBaseName:
  • double DataSpaceUsage: 4336
  • bool DateCorrelationOptimization: False
  • bool DBOLogin: True
  • string DefaultFileGroup: PRIMARY
  • string DefaultFileStreamFileGroup:
  • string DefaultFullTextCatalog:
  • DefaultLanguage DefaultFullTextLanguage: Microsoft.SqlServer.Management.Smo.DefaultLanguage
  • DefaultLanguage DefaultLanguage: Microsoft.SqlServer.Management.Smo.DefaultLanguage
  • string DefaultSchema: dbo
  • DelayedDurability DelayedDurabilityt;s: Disabled
  • bool EncryptionEnabled: False
  • DatabaseEvents Events: Microsoft.SqlServer.Management.Smo.DatabaseEvents
  • ExecutionManager ExecutionManager: Microsoft.SqlServer.Management.Smo.ExecutionManager
  • FileGroupCollection FileGroups: [PRIMARY]
  • string FilestreamDirectoryName:
  • FilestreamNonTransactedAccessType: Off
  • FullTextCatalogCollection:
  • bool HasFileInCloud: False
  • bool HasMemoryOptimizedObjects: False
  • bool HonorBrokerPriority: False
  • int Database ID: 13
  • double IndexSpaceUsage: 1368
  • bool IsAccessible: True
  • bool IsDatabaseSnapshot: False
  • bool IsDatabaseSnapshotBase: False
  • bool IsDbAccessAdmin: True
  • bool IsDbBackupOperator: True
  • bool IsDbDatareader: True
  • bool IsDbDatawriter: True
  • bool IsDbDdlAdmin: True
  • bool IsDbDenyDatareader: False
  • bool IsDbDenyDatawriter: False
  • bool IsDbManager:
  • bool IsDbOwner: True
  • bool IsDbSecurityAdmin: True
  • bool IsDesignMode: False
  • bool IsFederationMember:
  • bool IsFullTextEnabled: True
  • bool IsLoginManager:
  • bool IsMailHost: False
  • bool IsManagementDataWarehouse: False
  • bool IsMirroringEnabled: False
  • bool IsParameterizationForced: False
  • bool IsReadCommittedSnapshotOn: False
  • bool IsSystemObject: False
  • bool IsUpdateable: True
  • bool IsVarDecimalStorageFormatEnabled: True
  • datetime LastBackupDate: 5/12/2017 7:40:31 PM
  • datetime LastDifferentialBackupDate: 1/1/0001 12:00:00 AM
  • datetime LastLogBackupDate: 1/1/0001 12:00:00 AM
  • DatabaseScopedConfigurationOnOff LegacyCar: Off
  • DatabaseScopedConfigurationOnOff LegacyCar: Primary
  • bool LocalCursorsDefault: False
  • LogFileCollection LogFiles: [PHS_CMS2_log]
  • LogReuseWaitStatus LogReuseWaitStatust: Nothing
  • MasterKey:
  • int MaxDOP: 0
  • System.Nullable[int] MaxDopForSecondary:
  • double MemoryAllocatedToMemoryOptimizedObjectsInKB: 0
  • double MemoryUsedByMemoryOptimizedObjectsInKB: 0
  • decimal MirroringFailoverLogSequenceNumber: 0
  • guid MirroringID: 00000000-0000-0000-0000-000000000000
  • string MirroringPartner:
  • string MirroringPartnerInstance:
  • int MirroringRedoQueueMaxSize: 0
  • int MirroringRoleSequence: 0
  • MirroringSafetyLevel MirroringSafetyLevel: None
  • int MirroringSafetySequence: 0
  • MirroringStatus MirroringStatus: None
  • int MirroringTimeout: 0
  • string MirroringWitness:
  • MirroringWitnessStatus MirroringWitnessSta: None
  • string Database Name:RGP_CHM
  • bool NestedTriggersEnabled: True
  • bool NumericRoundAbortEnabled: False
  • string DB Owner: LAPTOP-40FLRU68\jfbev
  • PageVerify PageVerify: Checksum
  • DatabaseScopedConfigurationOnOff Parameter: On
  • DatabaseScopedConfigurationOnOff Parameter: Primary
  • Server Parent: [LAPTOP-40FLRU68\MSSQLSERVER2K16EVAL]
  • PartitionFunctionCollection PartitionFunct:
  • string PrimaryFilePath: C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER2K16EVAL\MSSQL\DATA
  • DatabaseScopedConfigurationOnOff: Off
  • DatabaseScopedConfigurationOnOff: Primary
  • QueryStoreOptions QueryStoreOptions: Microsoft.SqlServer.Management.Smo.QueryStoreOptions
  • bool QuotedIdentifiersEnabled: False
  • bool ReadOnly: False
  • guid RecoveryForkGuid: 0b49f734-dc5a-4c24-9576-ae7db7a527c8
  • RecoveryModel: Simple
  • bool RecursiveTriggersEnabled: False
  • string RemoteDataArchiveCredential:
  • bool RemoteDataArchiveEnabled: False
  • string RemoteDataArchiveEndpoint:
  • string RemoteDataArchiveLinkedServer:
  • bool RemoteDataArchiveUseFederatedServiceAccount:
  • string RemoteDatabaseName:
  • ReplicationOptions ReplicationOptionst: None
  • DatabaseRoleCollection Roles: [db_accessadmin] [db_backupoperator] [db_datareader] [db_datawriter] [db_ddladmin] [db_denydatareader] [db_denydatawr
  • iter] [db_owner] [db_securityadmin] [public]
  • RuleCollection Rules:
  • SchemaCollection Schemas: [db_accessadmin] [db_backupoperator] [db_datareader] [db_datawriter] [db_ddladmin] [db_denydatareader] [db_denydatawriter
  • ] [db_owner] [db_securityadmin] [dbo] [guest] [INFORMATION_SCHEMA] [policy] [sys]
  • SearchPropertyListCollection:
  • SecurityPolicyCollection SecurityPolicies:
  • SequenceCollection:
  • Broker.ServiceBroker ServiceBroker: Microsoft.SqlServer.Management.Smo.Broker.ServiceBroker
  • guid ServiceBrokerGuid: c3803c71-15df-4363-974f-8af6a076de6e
  • double Database Size: 24053.5
  • SnapshotIsolationState SnapshotIsolationSt: Disabled
  • double SpaceAvailable: 17354296
  • SqlSmoState State: Existing
  • DatabaseStatus Status: Normal
  • int TargetRecoveryTime: 0
  • bool TransformNoiseWords: False
  • bool Trustworthy: False
  • int TwoDigitYearCutoff: 2049
  • PHS_CMSRGP_CHM
  • DatabaseUserAccess UserAccess: Multiple
  • System.Object UserData:
  • string Current UserName: dbo
  • PARTNERSSOLUTIONS
  • int Version: 852

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.