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 Managed WordPress Migration User | 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 Managed WordPress Migration User | 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 Managed WordPress Migration User | 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. ...
by andrew novick | Apr 21, 2015 | Past Events, Presentations, SQL Performance, Uncategorized
SQL Server In-Memory Tables(Hekaton) Andy Novick April 2015 SQL Server 2014 aimed to improve OLTP performance by adding In-Memory tables and native compilation of the stored procedures that use them. In-Memory tables bring incredible speed for the right workload so...