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,146 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,489 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)
934 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,114 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,083 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,059 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)
283 reads
2019-05-03 (first published: 2015-03-30)
3,909 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,595 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers