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,784 reads
Delete files on a fileshare leaving behind files not older than n-days.
2011-09-13 (first published: 2008-04-02)
10,056 reads
2011-09-12 (first published: 2011-09-02)
1,509 reads
2011-09-09 (first published: 2007-11-19)
8,935 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,265 reads
Generate the scripts that will allow you to compare tables pass/fail.
2011-09-07 (first published: 2007-12-28)
12,595 reads
2011-09-06 (first published: 2011-08-13)
1,978 reads
2011-09-05 (first published: 2007-01-25)
3,950 reads
This function returns the difference between the date in text format
2011-09-01 (first published: 2011-08-30)
1,036 reads
2011-08-31 (first published: 2011-08-24)
2,546 reads
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Comments posted to this topic are about the item Can You Really Downgrade from...
Comments posted to this topic are about the item What is CPU Usage?
Comments posted to this topic are about the item Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers