2016-11-30 (first published: 2016-11-22)
704 reads
Sourav Mukherjee
- Interests: Like to make friendship with people.
2016-11-29 (first published: 2015-03-30)
3,734 reads
Taking backup of the databases to the Active server alone
If you have Always On and need to stop running database backups to the stand by server, use the script.
2016-11-21 (first published: 2016-11-01)
231 reads
2016-10-28 (first published: 2016-10-05)
11,796 reads
Extracting only Deadlock details from ErrorLog
If you want to extract only deadlock details, use the script.
2016-10-24 (first published: 2014-12-03)
3,592 reads
2016-10-20 (first published: 2015-05-15)
1,503 reads
Copy Backup Files to Remote Shared Location and Delete them periodically
If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.
2016-10-18 (first published: 2015-06-01)
1,783 reads
Shrink Tlog Files
DBA many a times need to shrink the log files if that grows very large. Though I am not recommending to do it daily or often but if space is an issue and you want to release space to OS, you may use the script.
2016-10-11 (first published: 2016-09-22)
791 reads
Change datetime
If you have any requirement to extract next 100 sequential date from a present date, you can use the below script. You can change the @datetimeformat value and the output will appear in the same format.
2016-10-10 (first published: 2016-09-26)
481 reads
Enable Email Notification to all SQL Jobs
If you have a requirement to enable email notification to all the SQL Jobs, then you may use my script.
2016-10-06 (first published: 2016-09-20)
847 reads
Blogs
T-SQL Tuesday #137–Notebook Uses
By Steve Jones
It’s actually my month to host T-SQL Tuesday, and I came up with the...
Daily Coping 13 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Converting a SQL Server Docker image to a WSL2 Distribution
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
Forums
Using Cluster Aware Update - Applying Windows Update to SQL Server part of AG
Is there any official Microsoft documentation around why Cluster aware update cannot be used...
SQL server 2019 installation CU 10 where to upload and install on my server
Hello where can I find to apply latest CU thank you
sql server 2019 standard edition intallation question
for installation sql server standard edition for instance id should I put server name?...
Ask SSC