I read something recently on LinkedIn about Deadlocks in SQL Server and how to monitor them. This reminded me of a script I wrote at the last place I worked that used the system_health Extended Event ...

SQL-Mongo Converter is a lightweight Python library for converting SQL queries into MongoDB query dictionaries and converting MongoDB query dictionaries into SQL statements. It is designed for ...

Of course, it’s frustrating to discover a corrupted database on your SQL Server for apparent reasons. You can’t access the information, and your work stops. However, you can fix this problem in many ...

The world of data is rapidly evolving, and artificial intelligence (AI) is no longer confined to just tech giants. Today, organizations of all sizes are leveraging AI to enhance their data-driven ...

A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

Transportation is undergoing rapid electrification, with electric buses at the forefront of public transport, especially in China. This transition, however, could strain electricity grids. Using a ...

Although a serious engineering challenge, database vectorization delivers orders-of-magnitude performance boosts for a real-time analytics engine such as StarRocks. Here’s how we did it. Improving ...

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...

SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power. SQL Bulk Insert is not a new technology. In ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...