GitHub - FirstCoder1/dba-sql-script: MS SQL Server scripts & code snippets

Branches Tags

About

MS SQL Server scripts & code snippets

sql sql-server dbapi dba

Activity

0 stars

1 watching

0 forks

Report repository

Releases

No releases published

Packages

No packages published

Name		Name	Last commit message	Last commit date
Latest commit History 35 Commits
DAC-config-enable.sql		DAC-config-enable.sql
DAC-connection-info.sql		DAC-connection-info.sql
Ola-build-backup-script.sql		Ola-build-backup-script.sql
Ola-query-CommandLog.sql		Ola-query-CommandLog.sql
ads-notebook-sql-server-audit.ipynb		ads-notebook-sql-server-audit.ipynb
ads-notebook-sql-server-ola-index-maint-setup.ipynb		ads-notebook-sql-server-ola-index-maint-setup.ipynb
ads-notebook-sql-server-triage.ipynb		ads-notebook-sql-server-triage.ipynb
alwayson-ApplicationIntent=ReadOnly.jpg		alwayson-ApplicationIntent=ReadOnly.jpg
alwayson-availability-group-detail.sql		alwayson-availability-group-detail.sql
alwayson-availability-group-replica-detail.sql		alwayson-availability-group-replica-detail.sql
alwayson-dashboard.sql		alwayson-dashboard.sql
alwayson-failover-database-recovery-status.sql		alwayson-failover-database-recovery-status.sql
alwayson-failover-database-status.sql		alwayson-failover-database-status.sql
alwayson-failover-times.sql		alwayson-failover-times.sql
alwayson-get-readonly-replica-temporary-statistics.sql		alwayson-get-readonly-replica-temporary-statistics.sql
alwayson-monitor-seeding.sql		alwayson-monitor-seeding.sql
alwayson-monitoring.sql		alwayson-monitoring.sql
alwayson-pause-resume-synchronization.sql		alwayson-pause-resume-synchronization.sql
alwayson-stop-restart-auto-seeding.sql		alwayson-stop-restart-auto-seeding.sql
alwayson-troubleshoot-hadr-endpoints.sql		alwayson-troubleshoot-hadr-endpoints.sql
alwayson-wait-stats.sql		alwayson-wait-stats.sql
backup-get-bakfile-information.sql		backup-get-bakfile-information.sql
backup-get-hist-avg-duration-and-size.sql		backup-get-hist-avg-duration-and-size.sql
backup-get-history.sql		backup-get-history.sql
backup-get-most-recent-duration-and-size.sql		backup-get-most-recent-duration-and-size.sql
backup-get-size-and-compression-ratio.sql		backup-get-size-and-compression-ratio.sql
backup-log-truncate-only-or-null.sql		backup-log-truncate-only-or-null.sql
backup-restore-build-script.sql		backup-restore-build-script.sql
backup-restore-get-estimated-completion.sql		backup-restore-get-estimated-completion.sql
backup-restore-helper-script.sql		backup-restore-helper-script.sql
backup-restore-service-master-key.sql		backup-restore-service-master-key.sql
backup-restore-to-RDS-for-SQL-Server.sql		backup-restore-to-RDS-for-SQL-Server.sql
backup-verify-backup-file.sql		backup-verify-backup-file.sql
batch-update-script.sql		batch-update-script.sql
cdc-master.sql		cdc-master.sql
cdc-online-schema-updates.sql		cdc-online-schema-updates.sql
cdc-rds.sql		cdc-rds.sql
cms-get-servers-and-groups.sql		cms-get-servers-and-groups.sql
database-add-object-metadata.sql		database-add-object-metadata.sql
database-attach-files.sql		database-attach-files.sql
database-detach-attach-files.sql		database-detach-attach-files.sql
database-detangle-nested-views.sql		database-detangle-nested-views.sql
database-drop-rds.sql		database-drop-rds.sql
database-enable-query-store-and-rcsi.sql		database-enable-query-store-and-rcsi.sql
database-get-checkdb-history.sql		database-get-checkdb-history.sql
database-get-detail-and-config.sql		database-get-detail-and-config.sql
database-get-encryption-state.sql		database-get-encryption-state.sql
database-get-estimated-backup-size.sql		database-get-estimated-backup-size.sql
database-get-file-detail.sql		database-get-file-detail.sql
database-get-file-growth-and-shrink-events.sql		database-get-file-growth-and-shrink-events.sql
database-get-file-size-and-space-used.sql		database-get-file-size-and-space-used.sql
database-get-file-to-volume-mapping.sql		database-get-file-to-volume-mapping.sql
database-get-foreign-keys-for-table.sql		database-get-foreign-keys-for-table.sql
database-get-foreign-keys.sql		database-get-foreign-keys.sql
database-get-last-known-good-CHECKDB.sql		database-get-last-known-good-CHECKDB.sql
database-get-log-file-VLF-count.sql		database-get-log-file-VLF-count.sql
database-get-log-info.sql		database-get-log-info.sql
database-get-log-space.sql		database-get-log-space.sql
database-get-memory-usage-by-table.sql		database-get-memory-usage-by-table.sql
database-get-object-dependencies.sql		database-get-object-dependencies.sql
database-get-orphan-logins.sql		database-get-orphan-logins.sql
database-get-scoped-configurations.sql		database-get-scoped-configurations.sql
database-get-sparse-column-estimation.sql		database-get-sparse-column-estimation.sql
database-get-status-CHECKDB.sql		database-get-status-CHECKDB.sql
database-get-table-and-index-size.sql		database-get-table-and-index-size.sql
database-get-table-compression-estimation.sql		database-get-table-compression-estimation.sql
database-get-table-last-update-date.sql		database-get-table-last-update-date.sql
database-get-table-size-all-dbs.sql		database-get-table-size-all-dbs.sql
database-get-table-size.sql		database-get-table-size.sql
database-get-tables-with-triggers-list.sql		database-get-tables-with-triggers-list.sql
database-get-untrusted-foreign-keys.sql		database-get-untrusted-foreign-keys.sql
database-migrate-encryption-keys.sql		database-migrate-encryption-keys.sql
database-online-rds.sql		database-online-rds.sql
database-purge-all-connections.sql		database-purge-all-connections.sql
database-refresh-views.sql		database-refresh-views.sql
database-relocate-files.sql		database-relocate-files.sql
database-remap-synonyms.sql		database-remap-synonyms.sql
database-rename-rds.sql		database-rename-rds.sql
database-resize-log-file-VLFs.sql		database-resize-log-file-VLFs.sql
database-revoke-connect-permissions.sql		database-revoke-connect-permissions.sql
database-script-missing-foreign-keys.sql		database-script-missing-foreign-keys.sql
database-shrink-file.sql		database-shrink-file.sql
dynamic-pivot-query-example.sql		dynamic-pivot-query-example.sql
error-log-find-size-and-location.sql		error-log-find-size-and-location.sql
error-log-query-using-fn_dblog.sql		error-log-query-using-fn_dblog.sql
error-log-query-using-rds_read_error_log.sql		error-log-query-using-rds_read_error_log.sql
error-log-query-using-xp_readerrorlog.sql		error-log-query-using-xp_readerrorlog.sql
execute-as.sql		execute-as.sql
extended-events-get-deadlock-report.sql		extended-events-get-deadlock-report.sql
fn_StripCharacters.sql		fn_StripCharacters.sql
get-blocking-info.sql		get-blocking-info.sql
get-connected-logins.sql		get-connected-logins.sql
get-connection-ip-address.sql		get-connection-ip-address.sql
get-database-column-datatype.sql		get-database-column-datatype.sql
get-estimated-completion.sql		get-estimated-completion.sql
get-memory-usage-by-database.sql		get-memory-usage-by-database.sql
get-open-transactions.sql		get-open-transactions.sql
get-session-aggregates.sql		get-session-aggregates.sql
get-session-details.sql		get-session-details.sql
get-session-locks.sql		get-session-locks.sql

FirstCoder1/dba-sql-script

Folders and files

Latest commit

History