Send Email to recipients with Attachment using PowerShell
If you have a requirement to send email to recipients with attachment, can use the script.
2019-05-03 (first published: 2016-05-17)
3,142 reads
Scripts
Setup Alerts for SQL Replication
If you want to monitor few specific alerts for SQL Replication (Merge and Transnational), you can may consider adding these 14 alerts.
2019-05-03 (first published: 2015-06-16)
1,480 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.
2019-05-03 (first published: 2016-09-22)
927 reads
Simple script to list out SPID, Program_name and login details
If you have any requirement where you want to find out all the SPIDs running on a database along with the program/application name of the SPID and the login details. You can run the procedure to get the details very easily.
2019-05-03 (first published: 2014-06-30)
4,100 reads
Standardizing DBMAIL Profile & Account Setup for Notification
If you have a requirement to setup with a default global dbmail profile and account you can use my script.
2019-05-03 (first published: 2015-05-28)
1,075 reads
Taking Backup Of All DBs
Wrote the script to take compressed backup with combining many other features.
2019-05-03 (first published: 2015-04-29)
1,052 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.
2019-05-03 (first published: 2016-11-01)
282 reads
2019-05-03 (first published: 2015-03-30)
3,905 reads
Verify Login SID and Machine SID
This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.
2019-05-03 (first published: 2014-12-24)
1,640 reads
SQL Server Worker Thread Alert
We decided to build a quick worker thread alert so we know when we are near the limits.
2019-05-02
1,586 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers