Files

 master

/

Misscellaneous Queries

/

Copy path

Directory actions

More options

Directory actions

More options

Latest commit

imajaydwivedi

Added/Modified few script for better resultset

Nov 18, 2020

c942743 · Nov 18, 2020

History

History

This branch is 107 commits ahead of mtikoian/SQLDBA-SSMS-Solution:master.

/

Misscellaneous Queries

/

Top

Folders and files

Name		Name	Last commit message	Last commit date
parent directory ..
AO_RoleSwitch_History.sql		AO_RoleSwitch_History.sql	Modifying Inventory Project	Apr 28, 2018
BCP-QueryOut.sql		BCP-QueryOut.sql	Grafana Monitoring Updates	Sep 5, 2020
Backup Restore CreateDate Test.sql		Backup Restore CreateDate Test.sql	Adding LogShipping Project	Apr 4, 2018
Combine-Perfmon-BLG-Files.sql		Combine-Perfmon-BLG-Files.sql	Changed Code to Merge multiple Perfmon files	May 10, 2019
Command Prompt.sql		Command Prompt.sql	Removed any word related to my current organization	Apr 13, 2020
Create Perfmon Collector.sql		Create Perfmon Collector.sql	Removed any word related to my current organization	Apr 13, 2020
Cross-Server-Database-Tables-RowCount-Comparision.sql		Cross-Server-Database-Tables-RowCount-Comparision.sql	Adding more code to fetch data from dbo.WhoIsActive_ResultSet	Apr 23, 2019
Error-Trying-2-Load-Assembly.sql		Error-Trying-2-Load-Assembly.sql	Adding script to keep skype alive	Feb 12, 2020
Estimate_Data_Compression_Savings.sql		Estimate_Data_Compression_Savings.sql	Updating Scripts - July 10th	Jul 10, 2018
FOR XML PATH.sql		FOR XML PATH.sql	Removed any word related to my current organization	Apr 13, 2020
Find Long Running Query.sql		Find Long Running Query.sql	Adding New Code for 'What's running.sql'	Mar 28, 2018
Get-EventLog-SQLCluster.sql		Get-EventLog-SQLCluster.sql	Removed any word related to my organization name	Apr 13, 2020
Get-Process-Locking-File.sql		Get-Process-Locking-File.sql	Added few Scripts	Mar 11, 2020
HADR or Mirroring.sql		HADR or Mirroring.sql	Updating Scripts - July 10th	Jul 10, 2018
Kill All Session for DB.sql		Kill All Session for DB.sql	Adding New Code for 'What's running.sql'	Mar 28, 2018
Log-Off-Users-with-PowerShell.sql		Log-Off-Users-with-PowerShell.sql	Added few Scripts	Mar 11, 2020
Maintainence - Delete files older than 72 hours.sql		Maintainence - Delete files older than 72 hours.sql	Adding Powershell Scripts to Create VMS in VirtualBox	Dec 21, 2018
Maintainence - Delete folder-files older than 120 hours.sql		Maintainence - Delete folder-files older than 120 hours.sql	Adding Transactional Replication Codes	Feb 7, 2019
Misscellaneous Queries.ssmssqlproj		Misscellaneous Queries.ssmssqlproj	Grafana Monitoring Updates	Sep 5, 2020
PS-Keep-Skype-Alive.sql		PS-Keep-Skype-Alive.sql	Adding script to keep skype alive	Feb 12, 2020
PowerShell Commands - iCacls.sql		PowerShell Commands - iCacls.sql	Removed any word related to my current organization	Apr 13, 2020
Powershell - Stop - SQLServices.sql		Powershell - Stop - SQLServices.sql	Updated scripts	Aug 20, 2019
Powershell-Add-Local-Administrator.sql		Powershell-Add-Local-Administrator.sql	Removed any word related to my current organization	Apr 13, 2020
Replace-Words-In-Body-Text-HTML.sql		Replace-Words-In-Body-Text-HTML.sql	Updating Few Scripts	Oct 24, 2019
Return Query Output as HTML Table.sql		Return Query Output as HTML Table.sql	Removed any word related to my current organization	Apr 13, 2020
RoboCopy.sql		RoboCopy.sql	Adding New Project for Sql-Lab	Apr 16, 2020
SQL Server Error Logs.sql		SQL Server Error Logs.sql	Modified Scripts for Blog Posts	Aug 14, 2020
SQLQuery1.sql		SQLQuery1.sql	Added/Modified few script for better resultset	Nov 18, 2020
SSMS Tricks 01.sql		SSMS Tricks 01.sql	Removed any word related to my current organization	Apr 13, 2020
Simulating a Multi Subnet cluster for setting up SQL Server Always On Availability Groups - lab setup.pdf		Simulating a Multi Subnet cluster for setting up SQL Server Always On Availability Groups - lab setup.pdf	Updates	Oct 1, 2019
Sql-Installation-Hosts.sql		Sql-Installation-Hosts.sql	Updates	Oct 1, 2019
Sql-Installation-Powershell-Codes.sql		Sql-Installation-Powershell-Codes.sql	Updates	Oct 1, 2019
SqlCluster-Troubleshooting.sql		SqlCluster-Troubleshooting.sql	Added few more scripts	Apr 21, 2020
System Memory Usage.sql		System Memory Usage.sql	Updating few commands	May 26, 2018
TableSizeMetrics - RecordCount n PageCount.sql		TableSizeMetrics - RecordCount n PageCount.sql	Updating Scripts - July 10th	Jul 10, 2018
Tell Me About Yourself.sql		Tell Me About Yourself.sql	Removed any word related to my organization name	Apr 13, 2020
TempDb-Shrink-LogFile-Loop.sql		TempDb-Shrink-LogFile-Loop.sql	Adding Few More Codes	Apr 7, 2019
Tempdb_Usage.sql		Tempdb_Usage.sql	Updating few commands	May 26, 2018
VSCode-Settings-General.sql		VSCode-Settings-General.sql	Adding Mail Notification For Active Jobs	Apr 19, 2019
dbo.usp_ConvertQuery2HTMLTable.sql		dbo.usp_ConvertQuery2HTMLTable.sql	Adding New Code for 'What's running.sql'	Mar 28, 2018
sp_Kill.sql		sp_Kill.sql	Adding New Project for Module Signing	Jun 4, 2019
View all files