In this tutorial, we build a comprehensive, hands-on understanding of DuckDB-Python by working through its features directly in code on Colab. We start with the fundamentals of connection management ...

Hello there! 👋 I'm Jin, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI In the era of big data and diverse data formats, the ability to store and query ...

SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time ...

Community driven content discussing all aspects of software development from DevOps to design patterns. Once you’ve installed SQLite, you’ll probably want to learn how to maneuver around the ...

When developing database-driven .NET and .NET Core, regardless of the database we intend to deploy in the end, we will often want to work with a database engine that is lightweight and fast, in order ...

Most of the time when I’m developing applications, I default to using some form of SQL. Whether it’s a simple application using SQlite or something a bit more robust that I plan to scale out with ...

SQLCodeGuard MSBuild SQLCheck SQL code violations reported by the plugin This is an example for sonar settings for project which uses custom plugin rules from local directory (located at ./rules ...

In my recent article I've reported about a nice free alternative to manage SQL databases, which, from the same UI can manage also MySQL databases. I thought that it might be a good idea to actually ...