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 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 | Nov 21, 2020 | SQL coding, SQL Performance
The previous two articles have been devoted to implementations of the Rot13 cipher. This is a character substitution cipher that is used to obscure text strings in the Window registry and in many web cookies. Both implementations were contributed by Luke Schollmeyer. ...
by andrew novick | Dec 1, 2016 | SQL coding, SQL Performance, Talks and Seminars
in-memory-tables-with-natively-compiled-t-sql-blazing-speed-for-oltp-and-more The SQL Server 2014 and 2016 Hekaton project brings us In-Memory tables and Natively Compiled T-SQL objects that run at amazing speed. What you can accomplish is astounding. This...
by andrew novick | Sep 20, 2016 | Past Events, Presentations, SQL coding, SQL Performance
Download the presentation: 100-times-faster-experiences-making-sql-server-fly-sql-saturday-prov-2015-12-12 How do you go about making a program run a lot faster! Like 100 times faster? It’s difficult. Microsoft tried in the Hekaton project, its in-memory tables...
by andrew novick | Sep 18, 2016 | SQL coding, SQL Performance, Talks and Seminars
Download the Presentation .Natively-Compiled-T-SQL-Andrew-Novck-presentation Demo files: Natively-Compiled-T-SQL-Andrew-Novck-demo-sql SQL Server’s In-Memory tables are accompanied by Natively Compiled Stored Procedures and Functions that run at amazing speed. ...
