Script out EXISTING database mail profile's settings
Script out EXISTING database mail profile settings
2018-04-25 (first published: 2018-04-23)
35,960 reads
Scripts
Generate Large Amount of Data For Performance Testing
Generate large sample data for your performance and other uses
2018-04-24 (first published: 2018-04-18)
3,044 reads
Flexible Statistics Update
Update the statistics starting from most accessed and modified ones, with a time limit. Procedure will exit when @MaxExecutionTime parameter is greater than the current execution time.
2018-04-19 (first published: 2018-04-16)
528 reads
2018-04-18 (first published: 2018-04-12)
4,348 reads
Finding table name based on a specific value
This script is used to Find out the table name and column name where a specific string has been used
2018-04-17 (first published: 2018-04-13)
2,220 reads
Script - All Jobs (powershell/SMO)
Script powershell/SMO que gera os scripts de DROP/CREATE para cada JOB existente na instância
2018-04-16 (first published: 2018-04-13)
645 reads
Login restriction from selected applications and users
It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details
2018-04-11 (first published: 2018-03-29)
752 reads
DB Blocking Automated E-mail Alerting with Blocker SP ID & query's
It will Help DBA to monitor the instant blocking and can take the action immediately on blocker query and users.
2018-04-05 (first published: 2018-03-22)
1,482 reads
Grant Sp_who2, & who3 proc execution without granting sysadmin access
It will help to development team to find their developed & DB server status check.
2018-03-28 (first published: 2018-03-22)
2,622 reads
Change the server name of the SQL Server Instance
How to change the server name of SQL Server Instance?
2018-03-27 (first published: 2018-03-19)
1,307 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers