This will give you a list of jobs that contain SSIS Packages should you have a project in which you may need to review changes to Packages.
2014-02-17 (first published: 2011-07-28)
1,768 reads
This script will generate a report providing all normally expected statistics for data Profiling .(ie.. Min, Max, Unique Count, Pattern etc....)
2014-02-12 (first published: 2012-05-21)
4,130 reads
This will list the columns used by the update statement inside a trigger. More generic and useful for columns > 32.
2014-02-10 (first published: 2012-06-06)
1,580 reads
This will name Ignite SQL hashes that have not been named yet, based on the object (or batch) they are within.
2014-02-05 (first published: 2014-01-25)
701 reads
Convert Months,Days,ShortMonths to Different Langauges with out sql server set language function can be used in views tables and stored procedures also includes proper case conversion
2014-02-03 (first published: 2014-01-21)
1,283 reads
This script calculates table row count and size(MB), as well as the used space and free space.
2014-01-31 (first published: 2014-01-17)
2,693 reads
This script will return databases that have no backup.
2014-01-30 (first published: 2012-10-07)
2,186 reads
Profile all of a table's columns using Transact-SQL.
2014-01-28 (first published: 2013-01-16)
2,268 reads
Scripts role membership, object-level permissions for all DB users.
2014-01-24 (first published: 2010-11-02)
27,181 reads
This SQL script will return basic information on each database on your server.
2014-01-21 (first published: 2013-12-28)
2,256 reads