I realize that this is a bit of a lengthy script for something that you can use a one liner in the power shell:
But I needed to highlight certain properties of given user and take certain actions based on the values. And the result is this power shell script.
2019-07-15 (first published: 2019-07-02)
Avoid conversion errors when using UNION to stack rows from multiple tables.
2019-07-12 (first published: 2019-04-11)
A script to drive SQL Compare for building upgrade scripts.
2019-07-11 (first published: 2019-06-26)
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-07-10 (first published: 2019-06-26)
Get a count of non NULL rows.
2019-07-09 (first published: 2019-05-01)
This Script will read the Estimated Time for recovery from Error Log
2019-07-08 (first published: 2019-06-26)
You find you are querying a vendor supported database where you're not allowed to make any collation changes, and which has a weird collation setup: default DB collation that matches your server and other databases all character related columns are explicitly a different collation that does not match your DB or server collation Rather than […]
2019-07-05 (first published: 2019-06-26)
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)