Rodrigo Ribeiro Gomes in T-SQL Programming AI in SQL Server 2025: Embeddings One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for text, video, or... 18 February 2025 48 min read
Ben Johnston in Blogs SQL Server 2022 CU Updates and Error Code 0x851A0043 I’ve been working in the Azure space for the last few years and less with full server installations. Azure leaves... 18 February 2025 5 min read
Louis Davidson in Opinion Pieces The State of the Database 2025 Less than a week ago, Redgate released their annual State of the Database Landscape report. You can read about the... 17 February 2025 3 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Descending B-Tree Indexes Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly used data structures... 13 February 2025 11 min read
Edward Pollack in T-SQL Programming Exploring Scalar Solutions to Complex Data Math There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity. A... 12 February 2025 17 min read
Kellyn Pot'Vin-Gorman What is Oracle RAC and Why Use it for Scaling Workloads? Oracle Real Application Clusters (RAC) is a database clustering solution that enables multiple servers to operate as a single, unified... 10 February 2025 6 min read
Louis Davidson in T-SQL Programming SQL Server BIT_COUNT and an Alternative I was editing an article the other day that uses the BIT_COUNT function that was added to SQL Server 2022.... 08 February 2025 11 min read
Bravin Wasike in Containers and Virtualization Kubernetes vs. Serverless: When to Choose Which? As a DevOps engineer working with software development teams, the debate between Kubernetes and serverless computing often arises when the... 06 February 2025 14 min read
Dennes Torres in Blogs Analysing Kusto Query Performance In Fabric We already discovered how to investigate Kusto query history. Let’s discover how to analyse query performance considering the information on... 06 February 2025 6 min read
Laerte Junior in PowerShell Fun with PowerShell Asynchronous Imagine a candle that is lit and takes 1 hour to burn out. Now imagine one hundred candles. How many... 03 February 2025 7 min read
Louis Davidson in Editorials Art and Science and of course AI There is a classic argument that goes like this, “is programming art or a science?” In its purest form, science... 03 February 2025 5 min read
Louis Davidson in SQL Server Dark Mode in SSMS 21 and overall first impressions Let me cut to the chase. If you are like me, you may have been searching for: How to turn... 02 February 2025 4 min read
Goodness Woke in Web Frappe and Laravel: Database Management and Migrations In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of database management and... 01 February 2025 14 min read
Phil Factor in Editorials Accessibility, and the Need for Ingenious Simplicity in Computer Scripts, Languages and Programs I’m very keen on accessibility in computer systems. Nowadays we tend to take a rather superior attitude to this problem,... 30 January 2025 12 min read
Dennes Torres in Blogs SQL Endpoint Secrets you need to know Recently I had a severe problem with SQL endpoints and I was required to build a quick workaround for this.... 29 January 2025 5 min read
Robert Sheldon in MongoDB Creating Time Series Collections in MongoDB Throughout this series, I’ve introduced you to different features in MongoDB and provided examples to help demonstrate how the database... 27 January 2025 15 min read
Louis Davidson in Blogs Weekly Blogging I spent a few weeks away from the office in early January, just like last year, mostly on vacation. Something... 27 January 2025 3 min read
Joe Celko in Theory and design Temporary Tables There is a feature of SQL I have not seen used much and probably with good reason. It’s the use... 24 January 2025 9 min read
Dennes Torres in Blogs Azure SQL Serverless: Discover What’s new and Increase Your Savings Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure SQL Serverless? The... 22 January 2025 3 min read
Louis Davidson in Editorials Nostalgic Memory Loss Today’s topic pertains to 99.999% of all people, young, old, and all age ranges . I am also not talking... 20 January 2025 4 min read