Security is probably one of a production DBA's most important tasks and if developers use application or service accounts to run queries in your production environment you need to identify then and prohibit it. I notice some unwanted activity after staring a new job and decided to create a script that notifies me via email when […]
2019-07-04 (first published: 2019-06-26)
Script database and object level permissions for all database users
2019-07-03 (first published: 2019-06-10)
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-04-25 (first published: 2019-04-18)
A short demo of a CTE used to perform aggregations.
2019-04-16 (first published: 2019-04-12)
Function that converts AD UserAccountControl number to details text
2019-04-15 (first published: 2019-04-12)
A nasty fast way to remove non-numeric and non-alphanumeric characters from a string
2019-03-15 (first published: 2016-05-17)