FilesExpand file tree

master

/

Utility Scripts

/

Copy path

Directory actions

More options

More options

Directory actions

More options

More options

Latest commit

 

History

History

History

 

 

master

/

Utility Scripts

/

Copy path

Top

Folders and files

Name		Name	Last commit message	Last commit date
parent directory ..
CertificateManagement		CertificateManagement
Columnstore/Generic Columnstore migration		Columnstore/Generic Columnstore migration
GPUCache		GPUCache
Partitioning		Partitioning
ActiveGeoReplicationSetup.sql		ActiveGeoReplicationSetup.sql
Add UPDATE CASCADE to All Foreign Keys with DELETE CASCADE.sql		Add UPDATE CASCADE to All Foreign Keys with DELETE CASCADE.sql
Add_Columns_to_CDC_Captured_tables_without_data_loss.sql		Add_Columns_to_CDC_Captured_tables_without_data_loss.sql
Analyze Database for SSDT.sql		Analyze Database for SSDT.sql
Asynchronous Ledger Demo.sql		Asynchronous Ledger Demo.sql
Attach all database files in a folder.sql		Attach all database files in a folder.sql
Audit trace file binary search by timestamp.sql		Audit trace file binary search by timestamp.sql
AzureCosmosDB_TablesAPI_MigrateAllTables_DMT.ps1		AzureCosmosDB_TablesAPI_MigrateAllTables_DMT.ps1
Balance CPU Cores Across NUMA Nodes.sql		Balance CPU Cores Across NUMA Nodes.sql
Basic_SQL_Server_table_migration_using_Powershell.ps1		Basic_SQL_Server_table_migration_using_Powershell.ps1
CDC disable for all tables.sql		CDC disable for all tables.sql
CDC enable for all tables.sql		CDC enable for all tables.sql
Cached_Plan_Types.sql		Cached_Plan_Types.sql
Change Tracking Generic Synchronization.sql		Change Tracking Generic Synchronization.sql
Check Compression Candidate - Single Table.sql		Check Compression Candidate - Single Table.sql
Check Local Time Zone.sql		Check Local Time Zone.sql
Check_Index_Fragmentation_Based_on_Page_Fullness_and_Fill_Factor.sql		Check_Index_Fragmentation_Based_on_Page_Fullness_and_Fill_Factor.sql
Collation Different From Default.sql		Collation Different From Default.sql
Configure load balancer IP and name for a domain-independent AG.ps1		Configure load balancer IP and name for a domain-independent AG.ps1
Create Database Snapshot.sql		Create Database Snapshot.sql
Create_Named_SQL_Server_Linked_Server.sql		Create_Named_SQL_Server_Linked_Server.sql
DB Trigger to Refresh Views When Underlying Objects are Modified.sql		DB Trigger to Refresh Views When Underlying Objects are Modified.sql
DDLEvents_Default_Trace.sql		DDLEvents_Default_Trace.sql
DENY ALTER ANY DATABASE DDL TRIGGER TO all database users.sql		DENY ALTER ANY DATABASE DDL TRIGGER TO all database users.sql
Decrypt All Encrypted Objects in Server.sql		Decrypt All Encrypted Objects in Server.sql
Delete Data from Multiple Tables with Referential Integrity.sql		Delete Data from Multiple Tables with Referential Integrity.sql
Delete_Batches_From_Table_By_DateTime_Column.sql		Delete_Batches_From_Table_By_DateTime_Column.sql
Deploy_DACPAC_DbaTools.ps1		Deploy_DACPAC_DbaTools.ps1
Determining the SET Options for the Current Session.sql		Determining the SET Options for the Current Session.sql
Drop Database Snapshot.sql		Drop Database Snapshot.sql
Drop or rebuild all Disabled Indexes.sql		Drop or rebuild all Disabled Indexes.sql
Encrypt using HASHBYTES instead of PWDENCRYPT.sql		Encrypt using HASHBYTES instead of PWDENCRYPT.sql
Enqueue and Dequeue Using Tables - Retain Fetched.sql		Enqueue and Dequeue Using Tables - Retain Fetched.sql
Enqueue and Dequeue Using Tables.sql		Enqueue and Dequeue Using Tables.sql
Execute Stored Procedures Dynamically with Minimal Parameters.sql		Execute Stored Procedures Dynamically with Minimal Parameters.sql
Extended Properties as Database Global Variables.sql		Extended Properties as Database Global Variables.sql
F_Calc_Age.sql		F_Calc_Age.sql
F_StringWithNumericAndAlpha.sql		F_StringWithNumericAndAlpha.sql
Failover_All_AGs_to_SECONDARY.sql		Failover_All_AGs_to_SECONDARY.sql
Find SHRINK sessions with lock info.sql		Find SHRINK sessions with lock info.sql
Find index hints for a specific index.sql		Find index hints for a specific index.sql
Find what could slow down SHRINK operations.sql		Find what could slow down SHRINK operations.sql
FindNvarcharMaxColumns.sql		FindNvarcharMaxColumns.sql
FindShrinkableFiles.sql		FindShrinkableFiles.sql
Fix_ServerName_To_MachineName.sql		Fix_ServerName_To_MachineName.sql
ForEachDB_AzureSQL.ps1		ForEachDB_AzureSQL.ps1
ForEachDB_AzureSQL_File.ps1		ForEachDB_AzureSQL_File.ps1
Foreign_Key_Hierarchy_Tree.sql		Foreign_Key_Hierarchy_Tree.sql
GeneratePartitionedView.sql		GeneratePartitionedView.sql
GeneratePeriodsByInterval_Inline.sql		GeneratePeriodsByInterval_Inline.sql
GeneratePeriodsByInterval_MultiLineFunc.sql		GeneratePeriodsByInterval_MultiLineFunc.sql
GeneratePeriodsByPeriodsNumber_Inline.sql		GeneratePeriodsByPeriodsNumber_Inline.sql
GeneratePeriodsByPeriodsNumber_MultiLineFunc.sql		GeneratePeriodsByPeriodsNumber_MultiLineFunc.sql
GeneratePeriodsByRange_Inline.sql		GeneratePeriodsByRange_Inline.sql
GeneratePeriodsByRange_MultiLineFunc.sql		GeneratePeriodsByRange_MultiLineFunc.sql
GeneratePeriods_Inline.sql		GeneratePeriods_Inline.sql
GeneratePeriods_MultiLineFunc.sql		GeneratePeriods_MultiLineFunc.sql
Generate_Procedure_Unit_Test_with_Auto_Comparison.sql		Generate_Procedure_Unit_Test_with_Auto_Comparison.sql
Generate_recommendations_for_clustered_indexes.sql		Generate_recommendations_for_clustered_indexes.sql
Generic script to create an indexed view and gradually migrate data into it - Print Only.sql		Generic script to create an indexed view and gradually migrate data into it - Print Only.sql
Get Job Output File Contents.sql		Get Job Output File Contents.sql
Get-MSSQLAllCredentials.ps1		Get-MSSQLAllCredentials.ps1
GetTempDBAvailableSpace.sql		GetTempDBAvailableSpace.sql
GrantRevokeDatabasePermissions.sql		GrantRevokeDatabasePermissions.sql
Grow a Database File in Specified Increments.sql		Grow a Database File in Specified Increments.sql
HowToEncryptData.sql		HowToEncryptData.sql
Hypothetical Indexes - Example Usage.sql		Hypothetical Indexes - Example Usage.sql
IPv4 and IPv6 Conversion Functions.sql		IPv4 and IPv6 Conversion Functions.sql
Identify Tempdb Contention.sql		Identify Tempdb Contention.sql
ImportExportBacpacWithSqlPackage.txt		ImportExportBacpacWithSqlPackage.txt
Increase_Database_File_in_Specified_Increments.sql		Increase_Database_File_in_Specified_Increments.sql
InstancePropertiesComparison.sql		InstancePropertiesComparison.sql
InstancePropertiesGenerateForCompare.sql		InstancePropertiesGenerateForCompare.sql
JSON_FindAndReplaceByNameAndValueInAllPaths.sql		JSON_FindAndReplaceByNameAndValueInAllPaths.sql
JSON_FindAndReplaceElementInAllPaths.sql		JSON_FindAndReplaceElementInAllPaths.sql
JSON_FindElementInAllPaths.sql		JSON_FindElementInAllPaths.sql
Manual_Cascade_Delete.sql		Manual_Cascade_Delete.sql
Move User Database Files to another drive.sql		Move User Database Files to another drive.sql
Move-SqlFilesAlwaysOn.ps1		Move-SqlFilesAlwaysOn.ps1
NewScdScript.sql		NewScdScript.sql
Number of Rows for each table in Azure Synapse.sql		Number of Rows for each table in Azure Synapse.sql
Object Dependencies.sql		Object Dependencies.sql
Powershell Get AzSql Databases.ps1		Powershell Get AzSql Databases.ps1
Powershell Get Procedure Parameters using SMO.ps1		Powershell Get Procedure Parameters using SMO.ps1
Powershell_Check_Outdated_Modules.ps1		Powershell_Check_Outdated_Modules.ps1
Powershell_Template_with_AzModules_Initialization.ps1		Powershell_Template_with_AzModules_Initialization.ps1
Powershell_Template_with_Transcript.ps1		Powershell_Template_with_Transcript.ps1
Powershell_Template_with_Transcript_and_AzModules.ps1		Powershell_Template_with_Transcript_and_AzModules.ps1
PrintMax.sql		PrintMax.sql
PrintMax_Minified_Temporary_Procedure.sql		PrintMax_Minified_Temporary_Procedure.sql
Procedures_to_Start_and_stop_CDC_Capture_Jobs.sql		Procedures_to_Start_and_stop_CDC_Capture_Jobs.sql
Query Template Forced Parameterization.sql		Query Template Forced Parameterization.sql
ReNumber_Identity_Column.sql		ReNumber_Identity_Column.sql
Read All Error Logs (SQL Server & Agent).sql		Read All Error Logs (SQL Server & Agent).sql
Remove Redundant Transaction Log Files.sql		Remove Redundant Transaction Log Files.sql
Reseed IDENTITY column based on utilization threshold.sql		Reseed IDENTITY column based on utilization threshold.sql
View all files