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 Ian Bachman-Sanders | Nov 20, 2020 | SQL coding
This article was about ufn_Rot13 a letter exchange cipher contributed by Luke Schollmeyer. The Rot13 cipher is often used for very basic hiding of text. The Windows Registry uses it and it’s also used in many web cookies. ufn_Rot13 uses a loop to compute each...
by Ian Bachman-Sanders | Nov 19, 2020 | SQL coding
How protected is the data in your database? For most databases, the answer is: “Not very”. Have you ever thought of encrypting your database? Make no mistake about it your database is vulnerable to prying eyes. SQL Server now has several options that...
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 6, 2014 | Past Events, Presentations, User Groups
Join me as I discuss SQL Server 2014’s new In-Memory option for tables with the natively compiled stored procedures. This features allows up to 25 times the performance of traditional disk based tables for OLTP workloads. Presentation at the New England...