Script out EXISTING database mail profile's settings
Script out EXISTING database mail profile settings
2018-04-25 (first published: 2018-04-23)
34,931 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)
2,691 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)
521 reads
2018-04-19 (first published: 2018-04-12)
4,239 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)
1,934 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)
632 reads
Rename Foreign Key Constraints
Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.
2018-04-13 (first published: 2013-03-19)
1,361 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)
738 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,469 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,541 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform
Comments posted to this topic are about the item Two New Shortcuts for Fabric...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers