I haven't examined the ANSI standard compared with T-SQL. It does seem like some of the stuff from there related to the OVER() and window functions has been implemented, but...

I dont have access to SQL22, but looking at GREATEST/LEAST, I assume that using them in a WHERE clause will make the query NON-SARGEABLE.

SELECT P.Name, P.SellStartDate,...

Thanks for the complement, Jeff. I think you've written some great articles and I always look forward to reading them.

I'll mess around with it and see. I think using the...

I haven't done this myself. I've mostly been running PoSh interactively for administrative scripting items. All my Agent jobs are T-SQL based or they use some batch scripting.

I was looking...

Hi FRank, useful post, all works fine except when I try the best way by running

$SqlSqlConn = New-Object System.Data.SqlClient.SqlSqlConnection("Server = $Server; Database = $Database; Integrated Security...

That's a great question. I'll see if I can write an...

I liked your article, and it sparked a little more research on my part. I remembered reading something about Filtering Objects vs Where-Object, and wanted to know what is the...

There are many editors available for Powershell - and the default Windows Powershell ISE works quite well for basic scripting.  It allows writing the script and executing command line...

Thank you very much for the very informative article!  I really gained an understanding from the way you explain things.  I would like to understand why we see what...

Thanks for this, I keep forgetting about that...

Thanks.

The SSMS thing works well, but it's manual when trying to save the data. I use PoSh to let this run regularly, as you noted, in an automated fashion.