Do you ever wish you had a better way to run or deploy scripts? We use this format for all types of work.
2019-08-20 (first published: 2019-07-26)
This is a simple powershell script to query and display hardware and OS information from a remote computer.
It uses CIM (Common Information Model) that is available since Powershell version 3 so as long as you have version 3 and up, you should be able to run this script against any server that you have access to.
2019-08-14 (first published: 2019-08-06)
Many people have published high performance, read-less, Inline Table Valued functions that use Itzik Ben-Gan's wonderful "Virtual Numbers Table" to replace WHILE loops and other forms of RBAR. This one is Jeff Moden's version.
2019-08-13 (first published: 2019-08-04)
Previous Monday to the Start of the Previous Quarter
2019-07-29 (first published: 2019-07-18)
This view will list all completed and running jobs. It give running times, current step (if active) and average run times for steps.
2019-07-22 (first published: 2019-03-21)
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)