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,786 reads
Delete files on a fileshare leaving behind files not older than n-days.
2011-09-13 (first published: 2008-04-02)
10,064 reads
2011-09-12 (first published: 2011-09-02)
1,510 reads
2011-09-09 (first published: 2007-11-19)
8,936 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,266 reads
Generate the scripts that will allow you to compare tables pass/fail.
2011-09-07 (first published: 2007-12-28)
12,600 reads
2011-09-06 (first published: 2011-08-13)
1,978 reads
2011-09-05 (first published: 2007-01-25)
3,953 reads
This function returns the difference between the date in text format
2011-09-01 (first published: 2011-08-30)
1,043 reads
2011-08-31 (first published: 2011-08-24)
2,548 reads
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
No two SQL Server environments are alike. A fix that resolves a performance issue...
WA CS 08218154392 Jl. Dr Ir H Soekarno, Ruko promenade. 8 Surabaya 60298, Kedung...
Comments posted to this topic are about the item Are You Working More Hours?
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers