22 May 2023
22 May 2023

Optimizing MySQL: Adding Data to Tables

0
1
Welcome back to the MySQL optimization series! In case you haven’t been following this series, in the past couple of articles we have discussed the basics of query optimization, and told you how to optimize SELECT queries for performance as well. In this blog, we’re further learning ways to optimize INSERT operations and look at … Read more
0
1
15 May 2023
15 May 2023

Changing log growth strategy in SQL Server 2022

When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for log file growth, I was excited. When I later learned it only applies to automatic growths, and only those of 64 MB or less, I was a little less excited. With those limitations, I was skeptical this enhancement … Read more

Uncovering the mysteries of PostgreSQL (auto) vacuum

Welcome to the second blog of the “magic of parameters” series. In the first entry, I covered memory parameters, and in this article. In this article will talk about PostgreSQL configuration parameters which manage the (auto)vacuum and (auto)analyze background processes. Why vacuuming is necessary? Before we start talking about vacuum and analyze-related parameters, we need … Read more
08 May 2023
08 May 2023

Xerox stars for accessibility

I was working for Xerox when the Xerox Star, precursor to all the computer systems in use today, was introduced. Before then, computer users just had command-line or character-based GUIs. The Xerox Star workstations were displayed for the first time for us insiders in a special room, like a secular chapel, guarded over by the … Read more
24 April 2023
24 April 2023

PostgreSQL Basics: Getting started with psql

PostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation of PostgreSQL. Many long-term PostgreSQL users, developers, and administrators rely on psql to help them quickly connect to databases, examine the schema, and execute SQL queries. Knowing how to install and use basic psql commands is an essential … Read more
17 April 2023
17 April 2023

Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook

I use Chat-GPT occasionally, instead of Google, to get answers to technical questions. Well there is definite value in promise in the technology, the trouble is that it currently uses authoritative sources with the same eagerness as blog posts written by newly-trained wannabe database devs who seek to get their names known, and I have … Read more

How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks

0
2
Cross-Site Request Forgery (CSRF) attacks are widespread, and even some BigTech companies suffer from them. Netflix suffered in 2006 with CSRF vulnerabilities. Attackers could change login credentials, change the shipping address and send DVDs to a newly set address. YouTube suffered from CSRF attacks where an attacker could perform actions of any user ING Direct … Read more
0
2
07 April 2023
07 April 2023

Ordered Columnstore Indexes in SQL Server 2022

One of the more challenging technical details of columnstore indexes that regularly gets attention is the need for data to be ordered to allow for segment elimination. In a non-clustered columnstore index, data order is automatically applied based on the order of the underlying rowstore data. In a clustered columnstore index, though, data order is … Read more