by nsadmin | Apr 17, 2025 | SQL coding, SQL Performance, Videos
The YouTube video by Andy Novick demonstrates using a large language model (specifically Grok-3 in April 2025) to generate T-SQL code for a simple ETL task. Novick, a SQL Server consultant, provides a scenario involving moving data between two similar tables with...
by andrew novick | Dec 15, 2020 | SQL coding
I responded to a posted question about the EOMONTH() function, which was: if there’s an EOMONTH function, why isn’t there a start of month function. The reason is that DATEFROMPARTS does the trick. It was added in SQL 2012 along with EOMONTH and...
by Ian Bachman-Sanders | Dec 10, 2020 | SQL coding
This article continues where the last one left off. If you’d like and go back and read that one you can find it here. In that article, an updatable view was created to replace an existing table. The table had been named myData and was renamed myDataBaseTable....
by andrew novick | Dec 9, 2020 | SQL coding, SQL Performance
I attended a webinar on Microsoft Databricks yesterday. The only link I have is a zoom registration so you’ll have to search. I’m sure they’ll run it again. The hands-on-lab made it very worthwhile. The rest was marketing fluff. They did a good...
by Ian Bachman-Sanders | Dec 2, 2020 | SQL coding
A reader, Rebecca, wrote asking: I have a table that contains a column. That table and column are used throughout our web site. The column is no longer valid and needs to come from another table. I need to quickly do this without having to change all of the code in...
by Ian Bachman-Sanders | Nov 23, 2020 | SQL coding
There are many reasons for almost every table to have a primary key. This articles UDF locates any user tables that don’t have primary keys. Here’s the CREATE FUNCTION script: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE FUNCTION...
