SQL 2005 Get Roles, Schemas & Object Permissions
Pulls all DB/Server fixed roles, default schemas & object permissions for all logins
2008-11-28 (first published: 2008-10-25)
2,383 reads
Pulls all DB/Server fixed roles, default schemas & object permissions for all logins
2008-11-28 (first published: 2008-10-25)
2,383 reads
Often during the development lifecycle columns are added to tables that become redundant or remain unused.
this script removes unused (empty) columns
2008-11-27 (first published: 2008-10-22)
1,167 reads
Get the all the SQL Server related services information,
2008-11-26 (first published: 2008-10-13)
1,246 reads
2008-11-25 (first published: 2008-10-20)
1,304 reads
use metadata to generate basic create procedure statements for insert update and select
2008-11-22 (first published: 2008-10-10)
3,808 reads
This is related to my other autogenerate code. this is just an example of how to use it.
2008-11-21
719 reads
2008-11-20 (first published: 2008-10-06)
958 reads
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
280 reads
Find indexes associated with queries and vice versa. Helps figure out what procedures are using indexes.
2008-11-18 (first published: 2008-07-31)
1,693 reads
Script to found out how much time before Restore or Backup Process remain
2008-11-17 (first published: 2008-09-30)
1,055 reads
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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