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,773 reads
Delete files on a fileshare leaving behind files not older than n-days.
2011-09-13 (first published: 2008-04-02)
10,047 reads
2011-09-12 (first published: 2011-09-02)
1,504 reads
2011-09-09 (first published: 2007-11-19)
8,932 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,264 reads
Generate the scripts that will allow you to compare tables pass/fail.
2011-09-07 (first published: 2007-12-28)
12,577 reads
2011-09-05 (first published: 2007-01-25)
3,935 reads
2011-08-31 (first published: 2011-08-24)
2,520 reads
Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).
Useful when rebuilding indexes online.
2011-08-30 (first published: 2011-08-25)
758 reads
2011-08-24 (first published: 2011-08-12)
1,162 reads
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
By Steve Jones
This is kind of a funny page to look at. The next page has...
Comments posted to this topic are about the item Why End-User Testing Is Even...
I have a table I didn't design that has tons of repeating groups in...
Comments posted to this topic are about the item Writing as an Art and...
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers