A Fine Slice Of SQL Server
Last year I benchmarked a few ways of shuffling columns in a data.table, but what about pandas? I didn’t know, so let’s revisit those tests and add a few more operations! pandas winds up being much more competitive than I expected.
Click through for those findings and the code Tom used for the task. H/T R-Bloggers.
Comments closedErik Darling sets MAXDOP to 1:
It’s August, and that means one thing: Family Vacation. I’m taking this month off from regular blogging, and posting some of my paid beginner training content for you to enjoy, while I enjoy not blogging.
Click through for a good video and no text I can use as a helpful graf.
Comments closedErik Svensen gets things organized:
This might be the default way of doing it but if you always want the chart to be sorted by a particular measure even though you are showing another measure then you can use this workaround. You should of course inform the user about the chosen sort order for instance in the subtitle or similar.
Click through to see what Erik has in mind.
Comments closedReza Rad does more than copies:
Copy Activity is one of the most commonly used activities in Microsoft Fabric’s Data Factory Pipeline. The Copy Activity copies the data from a source to a destination. However, there is more to that rather than just a simple copy. In this article, you will learn what Copy Activity is, its rationale, how it works, and its configuration options.
Reza has a video, as well as a demo-heavy full-length article on the topic.
Comments closedSalman Ahmed automates query execution:
In PostgreSQL, there are several ways to execute queries, and one of them is by executing queries from SQL files. This approach allows users to manage and store their SQL queries separately and make debugging and development simpler. Using SQL files also helps in replication of database schemas. This blog discusses how to execute queries from SQL files in PostgreSQL.
Read on to see how you can use the psql command line tool to do just that.
Comments closed