Recently one of my friend was doing some investigation in a new/unknown database and had really hard time locating the primary key – foreign key relations. Like it’s really tough to locate these relations when not enforced at database level in terms of primary key and foreign key constraints. But generally all database developers keep […]
2011-09-14 (first published: 2007-08-15)
2,794 reads
Delete files on a fileshare leaving behind files not older than n-days.
2011-09-13 (first published: 2008-04-02)
10,069 reads
2011-09-12 (first published: 2011-09-02)
1,517 reads
2011-09-09 (first published: 2007-11-19)
8,939 reads
Script one or all roles in a database. Includes users, obect permissions and column permissions.
2011-09-08 (first published: 2008-01-08)
5,271 reads
Generate the scripts that will allow you to compare tables pass/fail.
2011-09-07 (first published: 2007-12-28)
12,604 reads
2011-09-06 (first published: 2011-08-13)
1,982 reads
2011-09-05 (first published: 2007-01-25)
3,960 reads
This function returns the difference between the date in text format
2011-09-01 (first published: 2011-08-30)
1,049 reads
2011-08-31 (first published: 2011-08-24)
2,553 reads
If you spend your days tuning queries, managing pipelines, or keeping a production database...
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Comments posted to this topic are about the item Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers