Author: drweb

SQL

I’ve been using the SSMS preview for v21. This is the next evolution of SSMS, where the VS shell is finally being updated. For many of us, SSMS has been using an old version of the Visual Studio shell as its basis for development. It’s a locked down version, which is limited what’s possible in SSMS. Redgate and a few other companies have hacked in tools like SQL Prompt and SQL Source Control, but the number of extensions.In any case, this post looks at the upgrade to preview 6. I was on 4 on this machine, and I noticed a…

Read More

ttyd is a lightweight, open-source command-line tool that enables you to share your Linux terminal session via a web browser. By using WebSockets, ttyd allows you to interact with the terminal remotely as if you were directly on the machine, making it ideal for remote administration, team collaboration, or educational demonstrations. This tool wraps a terminal application (such as bash) and provides a simple, web-based interface accessible from any modern browser. With its ease of installation and customizable security features like basic authentication and SSL, ttyd is a powerful solution for accessing and sharing terminal sessions over the web. Use…

Read More
SQL

I’m excited to announce that on June 17 – 18, 2025, I’ll be running a special Online Live Training event focused entirely on SQL Server Query Tuning! This is a compact, intensive 2-day version of my highly acclaimed SQL Server Query Tuning Workshop – a course I delivered extensively across Europe before the COVID-19 pandemic. Hundreds of database professionals have benefited from this hands-on workshop, and now it’s your turn to experience it live and online, from the comfort of your own home or office.Why attend?In just two focused days, you will learn everything you need to know to truly…

Read More

Imagine trying to solve a puzzle but with only half the pieces. Your puzzle will always fall short, missing key elements that reveal the whole picture. This is the challenge you can face when applying AI to your code. Without access to the right kind of data, even the most advanced AI models face limitations in their ability to transform, analyze or understand software at scale.  Code isn’t just text — it’s a living, interconnected system of logic, dependencies and relationships. Code representations such as abstract syntax trees (ASTs) offer a step forward from raw text, providing structure and syntax awareness.…

Read More

Backups are essential for keeping your data safe, and automating the backup process can save you both time and effort. If your database is ever lost or corrupted, having a recent backup can be a lifesaver. Regular backups are crucial for any website or application using a MySQL database. Automating this process ensures that backups occur regularly, without the need to remember to perform them manually. In this guide, we’ll show you how to create a simple Bash script to automate MySQL database backups. Then, we’ll set up a Cron job to run this backup script automatically at scheduled times,…

Read More
SQL

I’ll walk through the KDA UI and tackle the first challenge before diving into the real cases.The UI layoutThis is what your layout might look like:LHS menu where you can switch challenges.All currently available cases. You’ll start with one and unlock new ones. Ordered like a mailbox, with the oldest at the bottom.Flavor text introducing the challenge.Ingestion script to load the data into your personal cluster.The main question that needs to be answered.Answer field — usually includes hints about the expected answer format.Three hints — IIRC, not all are available from the start; you might need to wait before requesting…

Read More

The rapid development of online gaming and gambling facilities, and the billions they generate around the world, require fair processes that can be proven. This not only protects consumers but also helps operators present a trustworthy product and maintain a good reputation.Python’s versatility for multiple tasks makes it the perfect option for the online gaming industry, making it easier for operators to prove that they are trustworthy and improve customer confidence. Online iGaming expert Carlos De Lanuza provides consumers with expert advice on everything from how to sign up at crypto casinos to their benefits, one of which is their…

Read More

The race to accelerate digital transformation across business units within an organization has led to a rapid surge in APIs, though unfortunately, without a central strategy in place.  In 2023, the majority of internet traffic (71%) was API calls, with typical enterprise sites seeing an average of 1.5 billion API calls. Large companies with over 10,000 employees tend to have over 250 internal APIs. This challenge is exacerbated by the growth of SaaS applications in organizations’ IT landscapes, with each application bringing its own integration and API needs. On average, an organization manages over 1,000 different apps. Besides, it is not…

Read More

In December of 2024, we published a blog with Anthropic about their totally new spec (back then) to run tools with AI agents: the Model Context Protocol, or MCP. Since then, we’ve seen an explosion in developer appetite to build, share, and run their tools with Agentic AI – all using MCP. We’ve seen new MCP clients pop up, and big players like Google and OpenAI committing to this standard. However, nearly immediately, early growing pains have led to friction when it comes down to actually building and using MCP tools. At the moment, we’ve hit a major bump in…

Read More

AufgabenWir suchen einen erfahrenen und talentierten Senior Backend Developer mit Fachkenntnissen in PHP und Cloud-Technologien zur Verstärkung unseres Teams. Du bist mitverantwortlich für die erfolgreiche Umstellung und Weiterentwicklung unserer Cloud Anwendung ZEP. Du wirst dich um die Entwicklung, Erstellung und Wartung der Backend-Infrastruktur unserer Webanwendungen kümmern und deren Leistung, Skalierbarkeit und Sicherheit gewährleisten.QualifikationDu passt zu uns, weil…du mehrjährige Erfahrung in der objektorientierten Entwicklung mit PHP sowie modernen Frameworks wie Laravel mitbringstdu Vue.js, Inertia.js und Tailwind CSS entweder bereits kennst oder motiviert bist, dich intensiv einzuarbeitendu Webanwendungen mit sauberem Code entwickelst und dabei auf Performance, Sicherheit und Wartbarkeit achtestdu solide Kenntnisse…

Read More