Changing Foreign key names to standard naming convention across the DB
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2011-07-06 (first published: 2010-02-09)
1,150 reads
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2011-07-06 (first published: 2010-02-09)
1,150 reads
T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.
2011-07-04 (first published: 2010-06-14)
3,756 reads
A short script to backup all filegroups, for those who utilise filegroups within a database.
2011-06-29 (first published: 2010-07-20)
1,259 reads
Script to setup transactional replication with updatable subscriptions when also using mirroring
2011-06-28 (first published: 2010-06-16)
4,319 reads
2011-06-24 (first published: 2011-06-14)
1,800 reads
This powershell script updates the server name specified in connections within a SQL 2005 SSIS package
2011-06-24 (first published: 2011-06-22)
831 reads
2011-06-23 (first published: 2011-06-20)
555 reads
Calculates the latlon coordinates for a given bearing and distance from reference latlon coordinates
2011-06-22
413 reads
Do you verify database backups regularly? If not, you may find this toolbox solution usable.
2011-06-21 (first published: 2011-06-15)
1,927 reads
This script helps to find all columns of an index on a table. Include columns covered (include)
2011-06-17 (first published: 2011-05-31)
1,351 reads
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers