2016-11-30 (first published: 2016-11-22)
683 reads
Sourav Mukherjee
2016-11-29 (first published: 2015-03-30)
3,656 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)
209 reads
2016-10-28 (first published: 2016-10-05)
4,407 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,517 reads
2016-10-20 (first published: 2015-05-15)
1,471 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,721 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)
756 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)
473 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)
823 reads
Blogs
Event Notifications Example
By SQLPals
Event notifications are kinda like a trigger in the sense that they respond to...
Did you know we have another SQL Server book coming out?
SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...
Batch Scripting SQLCMD–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Can't Get Attunity Oracle Connector to Work with SQL Server 2017 / Oracle 12c
I've tried many times to install the various versions of the Attunity Data Connector...
Using Java script to import word and pdf into SQL server
I am looking for example or use case codes in using Java script to...
Using sftp in Visual Studio for SSIS packages
Hi, I've inherited the maintenance of SSIS packages that were created by our former...
Ask SSC