Author: drweb

SQL

We’re a week late, once again my fault. I was still coming out of the holidays and forgot to check on my host. Luckily, Louis Davidson (who did have Feb) agreed to go early. He has a nice invite, and I am glad to answer.This is the monthly blog party on something SQL Server/T-SQL/etc. related. I have about half of 2026 covered, but if you would like to host, I’d love to have you. Ping me on X/LinkedIn/BlueSky.A MistakeSince we aim for T-SQL, I decided to ping something I’ve done a number of times in T-SQL, and sometimes still break.…

Read More

We’re Kinnovis, a fast-growing and family-run B2B SaaS company on a mission to modernize the self-storage industry across Europe with smart, automated software solutions. Our headquarters is in Vienna, Austria, and our international team is based in Austria, the UK, Slovenia, Spain and France. As one of Europe’s leading software providers in our niche, we help self-storage operators manage their facilities efficiently through smart, automated software. Currently, we serve clients in 22+ countries, and we are in a phase of fast growth and keep expanding. Our growth is sustainable, and we focus on long-term customer relationships and internal decision-making— without…

Read More

ARM (Advanced RISC Machine) is a RISC (Reduced Instruction Set Computing) instruction-set architecture developed by ARM Holdings, which is increasingly used in Linux devices, primarily due to its energy efficiency and suitability for everyday use. Therefore, every day more and more applications from various fields are trying to offer versions dedicated specifically to this architecture, such as Calligra Suite, Gnumeric, AbiWord, etc. One of these applications is also ONLYOFFICE Desktop Editors, which is a free and open-source desktop application for editing text documents, spreadsheets, presentations, PDF files, and fillable forms, which now natively supports Linux ARM64 systems. Therefore, in this…

Read More

My latest book, Vibe Coding Video Games with Python, is now available as an eBook. The paperback will be coming soon, hopefully by mid-February at the latest. The book is around 183 pages in length and is 6×9” in size. In this book, you will learn how to use artificial intelligence to create mini-games. You will attempt to recreate the look and feel of various classic video games. The intention is not to violate copyright or anything of the sort, but instead to learn the limitations and the power of AI. Instead, you will simply be learning about whether or not you…

Read More
SQL

I’m not trying to start up a debate whether you should use tabs or spaces when indenting code. Personally, I prefer spaces because when I copy the code to another editor the outlining of the code remains the same while with tabs it’s not always the case (looking at you, Word and Outlook). But I don’t want to hit the spacebar 4 times whenever I want to indent something, so I use the setting “insert spaces instead of tabs”:Best of both worlds However, recently I was writing some T-SQL code and I noticed that tabs were being inserted instead of…

Read More
SQL

I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece of ASCII Art. I have a screenshot here:For some reason, I thought, “I should do this in SQL”.” Then I thought, can the AIs help?Let’s see.This is part of a series of experiments with AI systems.SQL Prompt AIMy first instinct is to use Claude first, but here I decided to ask SQL Prompt AI for help. I generically asked for a function that would take a word as a parameter and then produce ASCII Art. I ended up with a function and a procedure. I won’t…

Read More
SQL

I’m in the UK today, having arrived this morning in London. Hopefully, by this time ,I’m in Cambridge and at the Redgate office. Maybe sitting in the foyer alcove, playing a little guitar (like I did last Oct).I’m here for a week of Redgate meetings as we kick off the year and it’s good to see colleagues and friends. All of the advocates are here, including Pat Wright, our newest advocate, and we’re hoping to record a Simple Talks podcast episode this afternoon. Maybe a second one if I can get someone from our data team to come in on…

Read More