Compare data of two tables
Script to facilitate the comparison of data between two SQL Server tables
2019-09-23 (first published: 2019-09-07)
4,046 reads
Scripts
A DateRange Table Valued function
The function is an inline table-valued function (or sometimes called a parameterised view) so it can be used just like a view or a table but needs parameters. It generates a single-column table of datetime2 with rows differing by any multiple of any of the dateparts that SQL Server provides.
2019-08-29 (first published: 2019-08-20)
5,316 reads
ErrorHandling for running or deploying code
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)
1,491 reads
A simple powershell script to look up server hardware and OS information
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)
2,484 reads
Create a Tally Function (fnTally)
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)
7,927 reads
Previous Monday to the Start of the Previous Quarter
Previous Monday to the Start of the Previous Quarter
2019-07-29 (first published: 2019-07-18)
537 reads
VIEW to list running and completed jobs
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)
2,013 reads
Look up AD user properties using powershell
I realize that this is a bit of a lengthy script for something that you can use a one liner in the power shell:
Example:
Get-ADUser
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)
1,277 reads
Creating an Automated Database Update\Upgrade Script with RedGate SQL Compare Command-Line and Powershell
A script to drive SQL Compare for building upgrade scripts.
2019-07-11 (first published: 2019-06-26)
2,150 reads
Add working days but avoid holidays
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)
5,225 reads
Blogs
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Forums
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Another Model, More Data Loss
Comments posted to this topic are about the item Another Model, More Data Loss
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers